Category: SQL
RePost: SQLite is not a toy database by Anton Zhiyanov
A nice write up about the very powerful but often under appreciated SQLite. Do not let anyone say otherwise, SQLite is a valid solution for…
Postgres: The Graph Database You Didn’t Know You Had
by Dylan Paulus SQL engines and RDBMS are a battle tested, tried and true core technology of nearly every application. NoSQL for locally run applications,…
How To: Database clustering with MariaDB and Galera.
The Situation MariaDB, a fork of MySQL, has had multi-master clustering support from the the initial version 10 release. However, the more recent releases have…
How-to: Easily update MariaDB from 10.0 onward on Cent OS 7
The Situation Recently I had to update the database services in an number of environments. The reasons were the typical ones: performance, bug fixes, keeping-up-with-the-jones,…
Out of the box performance: PHP + PDO + MariaDB
Backstory: Another week, another evening at the Pub with some friends and colleges. Somehow or the other we got on the topic of database insert performance…