A (somewhat opinionated) list of SQL tips and tricks that I've picked up over the years. There's so much you can do with SQL but I've focused on what I find most useful in my day-to-day work as a data ...

This PostgreSQL extension provides a basic implementation of the Paxos algorithm in PL/pgSQL and basic table replication through Paxos. Warning: pg_paxos is in an early stage, consider it experimental ...

When developing MySQL database functionality, sometimes it is necessary to test stored procedures and functions. There are various utilities that allow you to do this, but in some situations, it is ...

SQL databases have constraints on data types and consistency. NoSQL does away with them for the sake of speed, flexibility, and scale. One of the most fundamental choices to make when developing an ...

With JSON now the default format for moving data between clients and servers, SQL Server adds JSON support to make it easier to get your data out of the database and down to the client. SQL Server ...