How to INNER JOIN on the same table twice in SQL statement

Having more than one INNER JOIN to the same table can be confusing. More than one INNER JOIN can create a messy SQL statement. If you don’t use aliases they can become difficult to read. So join them with aliases, as explained below. For example say you have the following two tables: Users and Products. […]

What alternatives database engines are there to MySQL?

Unsure what alternatives there are to MySQL? Looking for increases in MySQL performance? You might not realize that there are some compatible relational database engines. That you can drop in to replace MySQL. You can even run SQLite without needing a server stack. SQLite is the most widely deployed database engine in the world Each […]

Reasons to switch from MySQL to MariaDB

Thinking of moving from regular MySQL to MariaDB? MariaDB has a considerable performance gain over MySQL 5.6 Need any more reasons than performance to switch? Switching from MySQL to MariaDB is easy, it’s still considered a drop in replacement. MariaDB definitely has more of an open source attitude. Galera implementation is better. Maria comes by […]

Pros and cons for switching to MariaDB from MySQL?

What are the advantages of switching to MariaDB from MySQL? And are there any disadvantages? If you like me, you may have only just heard about MariaDB. I came across it as a new option when adding a database to RackSpace Cloud hosting environment. After a quick read up about MariaDB and seeing that it […]