dbbench: Bringing Active Benchmarking to Databases — dbbench is a fast, lightweight database workload generator that executes a workload defined a flexible configuration file.

Engine.so: A Catalog of Embeddable Data Storage Engines — A quick list of 21 different embeddable databases from obvious candidates like SQLite and Berkeley DB to unusual ones like Rlite and UpscaleDB.

OneCache: A Replicated Key/Value Store Accessible Via The Memcached Protocol — OneCache nodes natively support clustering and best effort replication. Adding nodes into the cluster effectively increases the in-memory storage capability of the cache.

PostgreSQL Past, Present, and Future: Moving the Goalposts — Learn about PostgreSQL: the history, the present, and the future from Robert Haas, Chief Architect, Database Server at EnterpriseDB and PostgreSQL Major Contributor and Committer.

Business Logic in The Database. Yes or No? It Depends — Why is it so controversial to have business logic in the database? In which situations is it truly the right place and when is it not? Lukas Eder investigates.

MySQL to Amazon Redshift Replication: A How-To Guide — Why do companies replicate their MySQL databases to Amazon Redshift and how can you approach it yourself?

Impress Your Coworkers by Using SQL UNPIVOT — Some advanced SQL wrangling indeed.

Adding Columns with Default Values to Really Large Postgres Tables from Rails — For most frameworks it’s common for you to set a default value when you add a new column, the problem is this can cause a full table re-write and hold a lock–read: not good. There’s a few methods to work around this.