Somehow, I forgot how to start locally-installed Postgres instances. My loss is your gain, now we all have a .
pg_idkit is an extension powered by pgx that makes generating identifiers based on new schemes (UUIDv6, v7, v8, etc) easy.
Slonik is a Postgres database driver for NodeJS and it's pretty awesome. You should check it out if you haven't already.
I'm starting off 2022 in classic yak shaver style; with something I'm not supposed to be doing for tenuous financial gain -- running Ceph on ZFS.
Looking to run Postgres on ZFS? I've gathered some of the information and sage advice out there to give you a head start on figuring out how to do it safely and efficiently.
Some quick code (PG migrations) to enable converting an auto-generated postgres primary key index to a covering index
I describe in detail the YAML and Makefile scripts that power the fio and pgbench based tests that will run on every storage provider I managed to set up
An exporation in defining a safer type for dealing with prices using basic Postgres constructs, and using those types happily with an ORM
A few talks I gave in June 2019 separately on Postgres and GitLab