Posts | boringSQL

PostgreSQL Service Connections

Time to Better Know The Time in PostgreSQL

VIEW inlining in PostgreSQL

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

Are SQL & Databases Boring? Absolutely—and That's a Good Thing!

When and Why PostgreSQL Indexes Are Ignored