Tag: postgres

I built a snark detector and pointed it at myself

Reading your own writes with WAIT FOR LSN in Postgres 19

PostgreSQL 19's new WAIT FOR LSN command lets a replica block until it has replayed your write. The read-after-write problem it solves, the workarounds it replaces, and what the timeout, status, and mode options are actually for.

Just Use Postgres

Taking 'just use Postgres' to its logical endpoint: git push to deploy into a single Postgres process.

Git in Postgres

Instead of using git as a database, what if you used a database as a git?

How to Migrate Data From One Postgres Instance to Another

Here is how I migrated the data from one database to another using an SSH tunnel, `pg_dump` and `pg_restore`.

How to Migrate Data From One Postgres Instance to Another

Here is how I migrated the data from one database to another using an SSH tunnel, `pg_dump` and `pg_restore`.

Should I use a Managed Postgres Instance?

Choosing a managed Postgres instance gave me peace of mind that my data was safe, my app server and my database had isolated resources, and I had the flexibility to change the app server without affecting the data.

Should I use a Managed Postgres Instance?

Choosing a managed Postgres instance gave me peace of mind that my data was safe, my app server and my database had isolated resources, and I had the flexibility to change the app server without affecting the data.

Jeff Dickey - Mise, Usage, and Pitchfork and the Future of Polyglot Tools

Jeff Dickey discusses his polyglot development tools Mise, Usage, and Pitchfork, and how they're revolutionizing CLI frameworks and dev environments.

Seed your Supabase database with this simple pattern

Learn how to seed your Supabase database with this simple pattern.

Seed your Supabase database with this simple pattern

Learn how to seed your Supabase database with this simple pattern.

James Arthur - ElectricSQL

James Arthur from ElectricSQL explains how their local-first sync engine transforms Postgres into a distributed database that runs locally on every device.

Coerce a string into a uuid in Postgres

Postgres 10 to 11 upgrade

Using JSON in Postgres with Ruby and Sequel

With its fast, built-in support for JSON, it's worth considering Postgres for storing and querying your JSON data. Instead of using a specialised document server, Postgres may be the right choice for your application. As of Postgres 9.4 you can index data stored in a JSONB (binar