pgloader
Common Lisp → Clojure
Load data into PostgreSQL — and migrate a whole database from MySQL, SQLite or MS SQL with a single command.
Projects
Open-source tools I build and maintain — mostly about getting data in and out of PostgreSQL and keeping it highly available. The full graveyard lives on my GitHub profile.
pg_auto_failover
C
Automated failover and high availability for Postgres, built around a simple and robust monitor.
pgcopydb
C
Copy a Postgres database to another server in parallel, with change-data-capture for near-zero-downtime migrations.
prefix
C
A Postgres extension: a prefix-range data type with a GiST index for fast prefix matching — routing tables and friends.
pginstall
Common Lisp
A PostgreSQL extension installer: build, distribute, and install extensions across architectures from a central repository.
el-get
Emacs Lisp
Install and manage Emacs Lisp packages from anywhere — the easy, fully documented way.
Learn to replace thousands of lines of code with simple queries.
The book, self-paced courses, live workshops, and The Lab — all built around the same teaching philosophy as this blog.
The Art of PostgreSQL
The definitive book on SQL and PostgreSQL for application developers — from indexing to window functions.
The Lab
500+ SQL queries from the book, real datasets, Docker-ready. Practice PostgreSQL hands-on.
Courses
Self-paced video courses covering the full PostgreSQL curriculum at your own speed.
Workshops
Live, hands-on PostgreSQL training for your team — remote or on-site.