boringSQL | Supercharge your SQL & PostgreSQL powers

DELETEs are difficult

Text identifiers in PostgreSQL database design

We need to talk about ENUMs

Beyond Simple Upserts with MERGE in PostgreSQL

Gentle Introduction to Window Functions in PostgreSQL

The time keepers: pg_cron and pg_timetable

Deep Dive into PostgREST - Time Off Manager (Part 3)

Custom PostgreSQL extensions with Rust

Deep Dive into PostgREST - Time Off Manager (Part 2)

Deep Dive into PostgREST - Time Off Manager (Part 1)

How not to change PostgreSQL column type

The Bloat Busters: pg_repack vs pg_squeeze

When and Why PostgreSQL Indexes Are Ignored