(Dave Stokes) Foreign Keys are often a mystery to new DBAs in the MySQL world. Hopefully this blog will clear some of this up.

(Pavel Stehule) Last week I play with Lua – It is really beautiful, powerful and strange language. I would to some image about this language so I wrote a primitive benchmark. Note: Although Lua is clean winner, I’ll use a my favourite PL/pgSQL still – for business logic implementation is really best

(Baron Schwartz) A while ago I wrote about some of the things that can make MySQL unreliable or hard to operate. Some time after that, in a completely unrelated topic, someone made me aware of a set of principles called 12-factor that I believe originated from experiences building Heroku.

(Josh Berkus) Thanks to Streaming-Only Remastering, PostgreSQL 9.3 has been a boon to high-availability setups and maintenance You can re-arrange your replicas however you like; remastered, in a tree, in a ring, whatever. However, there’s been one wart on this free reconfiguration of Postgres repl

(Mark Callaghan) MongoDB, TokuMX and MySQL use log files with high-value data. For MongoDB this is the journal that uses direct IO. For MySQL this is the binlog, relay log and InnoDB redo log, all use buffered IO by default, the InnoDB redo log uses 512 bytes as the “page size” and the replication

(Shaun M. Thomas) With the release of PostgreSQL 8.4, the community gained the ability to use CTE syntax. As such, this is a fairly old feature, yet it’s still misunderstood in a lot of ways. At the same time, the query planner has been advancing incrementally since that time. Most recently, Postgre

(Stephane Combaudon) One of the MySQL 5.6 features many people are interested in is Global Transactions IDs (GTIDs). This is for a good reason: Reconnecting a slave to a new master has always been a challenge while it is so trivial when GTIDs are enabled.

(Robert Berry) This post covers some of the features which make Postgresql a fun and effective database system for storing and analyzing time series: date functions, window functions, and series generating functions.

(Chris Calender) I ran into an issue the other day where Xtrabackup was not completing and threw the following error:

(Jim Mlodgenski) I recently had discussions with some folks about triggers in PostgreSQL. They had two main questions.