PostgreSQL zero-downtime migrations made easy

A lightweight message queue. Like AWS SQS and RSMQ but on Postgres.

Subqueries and performance in PostgreSQL

Mini ORM for Python, with support for Postgres, MySQL, SQLite to be used with async frameworks

A truly Open Source MongoDB alternative, built on Postgres

The (composite_value).* expansion to columns was new to me. And useful in a recent query I had to write.

Free multi-platform database tool for developers, SQL programmers, database administrators and analysts. Supports all popular databases: MySQL, PostgreSQL, MariaDB, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Derby, etc.

Awesome post on how to write SQL:

UPDATE table_name SET array_col = ARRAY(SELECT DISTINCT UNNEST(array_col) ORDER BY 1) where array_length(array_col, 1) > 1;