(Michael Paquier) Today here is a highlight of a new Postgres 9.4 feature interesting for developers and companies doing packaging of Postgres on Windows as it makes possible the installation of client-only binaries and libraries using MSVC. It has been introduced by this commit:

(Tim van der Linden) And so we arrive at the last part of the series.

(Dave Stokes) MySQL Triggers are changing in 5.7 in a big way. Triggers have been around since 5.0 and have not changed much up to 5.6 but will gain the ability to have multiple triggers on the same event. Previously you had ONE trigger maximum on a BEFORE UPDATE, for example, and now you can have m

(Robert Haas) When your database gets corrupted, one of the most important things to do is figure out why that happened, so that you can try to ensure that it doesn’t happen again. After all, there’s little point in going to a lot of trouble to restore a corrupt database from backup, or in attempti

(Martin Arrieta and Fernando Ipar) In our previous post, we introduced the MySQL Fabric utility and said we would dig deeper into it. This post is the first part of our test of MySQL Fabric’s High Availability (HA) functionality.

(Øystein Grøvlen) In years past, MySQL was a bit of a black box when it came to understanding what was happening and why. In MySQL 5.6 and 5.7, we’ve added many new features that provide much needed transparency and insight into the inner workings of MySQL.

(Josh Berkus) About a month ago, PostgreSQL fork vendor and Data Warehousing company CitusDB announced the availability of the open-source cstore_fdw. This foreign data wrapper creates an external table with highly compressed data, which allows you to keep large amounts of archival data on your Pos

(depesz) Today, I’d like to show you how you can use the same index for two different types of conditions. One that is using normal BTree indexing ( equal, less than, greater than ), and one that is using GIN/GiST index, for full text searching.

(Sergey Petrunia) Recently, I was asked about an interesting case in ORDER BY … LIMIT optimization. Consider a table

(Miguel Angel Nieto) The combination of max_allowed_packet variable and replication in MySQL is a common source of headaches. In a nutshell, max_allowed_packet is the maximum size of a MySQL network protocol packet that the server can create or read.