Killing a PostgreSQL Connection

Let’s kill a PG connection

PostgreSQL Schemas: Namespacing for Objects

For organizing objects in your DB, or setting up multi-tenancy

PostgreSQL: Create a Read-only User/Group

Let’s create a read only group in PG and add users to it

Timeseries and ASOF Joins

Pairing up timeseries data when the timestamps don’t match exactly (in Pandas, Polars, DuckDB, Postgres & QuestDB)

Archiving Time-Series Data from PostgreSQL into Parquet

Keeping your database lean

Lateral Joins & Iterators in SQL

Sneaking for-loops into SQL without anyone noticing

Generalized Range Difference, Recursion & Search Availability in PostgreSQL

We’re building a scheduling app. Users mark booked slots, represented in Postgres using time or date-range data types. Let’s see how we can find all the freely available slots efficiently

Speeding up unique constraint checks in PostgreSQL... or not

Are exclusion constraints using hash indexes faster than plain old uniqueness checks? Let’s find out

SQL gotcha: now() vs 'now'

Make sure you’re using the correct defaults when defining columns

Back To Basics: The foundation of Joins in SQL

Writing SQL joins without using joins at all. A quick history of Database Models, Schemas, Constraints, Cross-products and everything in between

SQL joins as reduce/folds over relations

Of what to make of joins in sql, mental models and building better understanding

Handling Bank Transactions, V2

Version 2 of a simplified Node.js-based API + PG database layer for handling a bank’s intra-account transfer operations

Handling Bank Transactions, V1

Overview of a simplified Node.js-based API + Postgres database layer for handling a bank’s intra-account transfer operations

PG Transactions & Isolation levels: Airline Seat Booking

Using the right isolation level to avoid nasty billing errors when building database-managed booking systems