(Craig Ringer) You might have seen the support added for security_barrier views in PostgreSQL 9.2. I’ve been looking into that code with an eye to adding automatic update support for them as part of progressing row-level security work for the AXLE project, and I thought I’d take the chance to explai

(Ike Walker) I frequently use pt-query-digest to parse the MySQL slow query log. This morning I wanted to parse the MySQL binary log to find out how frequently various tables in my database are updated. A quick check of the pt-query-digest documentation confirmed that pt-query-digest does support pa

(Michael McLaughlin) Somebody asked how to create a SYNONYM in MySQL, which is interesting because MySQL doesn’t support synonyms. I thought the prior entry explained how to do it, but here’s a new post. However, you can create a view in one database that relies on a table in another database.

(Morgan Tocker) As part of the ongoing effort to refactor MySQL and make it better, we are defining the behaviour of certain features and in some cases reimplimenting them in a more maintainable fashion.

(selena deckelmann) I have been thinking about the kinds of questions people have about Postgres if they’re mostly users of MySQL. One thing that comes up a lot is how to use the psql command-line.

(Mike Chapple) Looking for a free or very low-cost way to host your MySQL databases in the cloud? You may wish to consider hosting your database in Amazon Web Services.

(Josh Berkus) One of PostgreSQL’s headline features — at least, compared to other relational databases — is the ability to do some ALTER TABLE ALTER COLUMN commands for “free”. It’s part of how we try to make things easier for DBAs and Devops staff, by not requiring a downtime for operations whic

(Selena Deckelmann) I had a recent code review problem that was very curious at first glance, but came down to the use of complex VIEW in an even more complicated and frequently used reporting query.

(Ronald Bradford) The announcement of the MySQL Yum repositories was a long overdue request on my wish list. While it was possible to find MySQL at http://public-yum.oracle.com/ it was not the GA version MySQL 5.6.

(Morgan Tocker) MySQL 5.6 introduced online DDL for InnoDB tables, which means that a number of ALTER TABLE statements no longer block access to data modification while running.