Skip to content
Standard Reader
Log in
Tag

Postgres

Articles and publications tagged Postgres across the Atmosphere.

19articles10publications
Redowan's Reflections
Redowan's ReflectionsAug 19, 2026
Postgres as an isolation reference model
Use PostgreSQL's transaction isolation levels as a reference model for reasoning about the guarantees and tradeoffs of other relational and non-relational databases.
DatabaseSQL
Redowan's Reflections
Redowan's ReflectionsAug 19, 2026
A return to Postgres isolation
Use PostgreSQL's transaction isolation levels as a reference model for reasoning about the guarantees and tradeoffs of other relational and non-relational databases.
DatabaseSQL
Justin-Stanley.com
Justin-Stanley.comJun 22, 2026
I built a snark detector and pointed it at myself
llmhomelab
Redowan's Reflections
Redowan's ReflectionsJun 13, 2026
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.
DatabaseSQL
Redowan's Reflections
Redowan's ReflectionsJun 13, 2026
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.
DatabaseSQL
Andrew Nesbitt
Andrew NesbittMar 10, 2026
Just Use Postgres
Taking 'just use Postgres' to its logical endpoint: git push to deploy into a single Postgres process.
gitpostgres
Andrew Nesbitt
Andrew NesbittFeb 26, 2026
Git in Postgres
Instead of using git as a database, what if you used a database as a git?
gitpostgres
oh hey, it's owais
oh hey, it's owaisDec 18, 2025
Community
Dev Log 38: 2025-12-18
FSharp.NET
enumerator.dev
enumerator.devJul 3, 2025
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`.
postgreswillow-camp
enumerator.dev
enumerator.devJul 3, 2025
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`.
postgreswillow-camp
enumerator.dev
enumerator.devJul 1, 2025
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.
postgreswillow-camp
enumerator.dev
enumerator.devJul 1, 2025
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.
postgreswillow-camp
Devtools FM
Devtools FMJan 26, 2025
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.
technologydevelopment
💌 Tiny Improvements - for builders, by @MikeBifulco.com
💌 Tiny Improvements - for builders, by @MikeBifulco.comJul 23, 2024
Seed your Supabase database with this simple pattern
Learn how to seed your Supabase database with this simple pattern.
supabasedatabase
Devtools FM
Devtools FMJul 7, 2024
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.
technologyreact
Philihp Busby
Philihp BusbyOct 4, 2022
Coerce a string into a uuid in Postgres
sqlpostgres
Reilly Wood
Reilly WoodJan 30, 2022
Pretending to be a Postgres server - Part 1
SoftwareDatabases
Philihp Busby
Philihp BusbyJan 16, 2019
Postgres 10 to 11 upgrade
postgresmacos
Barry Frost - Articles
Barry Frost - ArticlesOct 10, 2017
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
postgressequel

You've reached the end.