Databases
DatabasesPlanet PostgreSQL
Christophe Pettus: coddpiece: Watch Relational Algebra Become SQL
Learn relational algebra by building expressions that compile to real SQL.
Ideas and shifts that matter to people who design, build and run software—a concise pulse check for your craft.
Category
Learn relational algebra by building expressions that compile to real SQL.
We often hear that open source is about people. People who contribute their time and, in a way, parts of their lives to work on software that is available for everyone without limitations and without licensing costs. The more popular a…
Postgres has had native support for declarative partitions since version 10, and every release since has filed off another rough edge. We got partition-wise joins, default partitions, hash partitioning, and the ability to attach and detach…
Nearly a decade ago, I joined MongoDB as a Senior Product Manager to help build the company’s new cloud product, MongoDB Atlas. Our customers had been telling us they wanted to bring MongoDB’s familiar developer experience to the cloud,…
The Night When Things Almost Went Down Have you ever left for home on a Friday evening feeling confident about your work for the day, at peace knowing your system would survive the coming weekend? We’ve all felt that way at some point.…
In the previous post, we discussed the basic syntax of graph queries in PostgreSQL 19 and discussed some simple SQL/PGQ examples. However, more often than not applications are more complex and need more than just two basic tables.…
Reorder GROUP BY and DISTINCT keys to cut comparison costs and skip sorts—new optimizations in PostgreSQL 17 and 18 that usually stay invisible but…
Cygnet is a PostgreSQL ORM for async Python that refuses to hide the SQL.