Tootfinder

from my link log —
Querying PostgreSQL tables from DuckDB.
https://duckdb.org/2022/09/30/postgres-scanner.html
saved 2022-09-30 https://

Querying Postgres Tables Directly from DuckDB
DuckDB can now directly query tables stored in PostgreSQL and speed up complex analytical queries without duplicating data.

For folks considering converting their #Nextcloud database from MariaDB (or MySQL) to PostgreSQL: it is possible, there is a built-in tool, but there are also some bugs and gotchas along the way. Our Nextcloud DB has millions of records and takes hours to convert, so the try->find bug->clean DB or patch tool->clean target->try again cycle has now taken up three days of two Byobu screens. …

📊 Requires #PHP 8.2 and Laravel 12 or 13, works on #MySQL, #PostgreSQL & #SQLite. State liv…

from my link log —
Seamless application failover using libpq features in PostgreSQL.
https://www.percona.com/blog/2019/10/23/seamless-application-failover-using-libpq-features-in-postgresql/
saved 2019-10-30

Seamless Application Failover using libpq Features in PostgreSQL
Percona's Avinash Vallarapu talks about seamless application failover using libpq features in PostgreSQL, and how even with some slowness it still helps.

from my link log —
Fast IPv4 to hostname lookups: PostgreSQL vs ClickHouse.
https://tech.marksblogg.com/fast-ip-to-hostname-clickhouse-postgresql.html
saved 2020-01-09

Hey all
We have a new retrofit demo to share:
https://retrofit.sh/demos/manually-test-schema-changes/
Imagine your team has been using retrofit for the past couple weeks and now every branch to be reviewed has a schema change that will require a migration in pr…

Review schema-change branches against a production snapshot without reloading it · retrofit
Three branches, one snapshot of a production PostgreSQL database. See make db-up put each branch's schema change on the snapshot from its own dump, make db-down take it back off, a branch that drops a column refused before anything runs, and the clean branches merged with the snapshot following main.

A quick shadow drop of sorts: who hasn't implemented a cache on top of Postgres? I know, everyone has. And yet, here's another contender that's based on psycopg and can use existing SQLAlchemy engines (or whatever you implement): ⚡️psycache ⚡️
In my defence, when I wrote it (it's been in prod for years) there weren’t quite as many other implementations and the deep support for instrumentation sets this one apart, I think.
And thus Hynek's Summer of Postgres ha…

GitHub - hynek/psycache: A psycopg-Backed PostgreSQL Cache
A psycopg-Backed PostgreSQL Cache. Contribute to hynek/psycache development by creating an account on GitHub.

from my link log —
New things for regular expressions in PostgreSQL: pg_tre and pg_re2.
https://www.depesz.com/2026/08/25/new-things-for-regular-expressions-in-postgresql-pg_tre-and-pg_re2/
saved 2026-09-02

🐘 #pgrust is #PostgreSQL rewritten from scratch in #Rust — an experimental, AI-assisted project exploring what Postgres could look like built on modern primitives.

from my link log —
Faster asynchronous WAL archiving with pgBackRest to avoid PostgreSQL WAL backlog.
https://www.percona.com/blog/2020/12/01/how-pgbackrest-is-addressing-slow-postgresql-wal-archiving-using-…

How pgBackRest is Addressing Slow PostgreSQL WAL Archiving Using Asynchronous Feature
How pgBackRest is addressing slow PostgreSQL WAL Archiving using its Asynchronous archiving feature.

It’s Wednesday, and we’ve got a new demo.
https://retrofit.sh/demos/pull-and-sync/
In the demo we simulate a standard developer flow.

Keep a local PostgreSQL database in sync with the operation log · retrofit
See Retrofit identify which cut a local PostgreSQL database is at from a pg_dump, gate make run on the head of the operation log, migrate the database forward after a git pull, and capture a change made by hand into the log.

from my link log —
sqldef: idempotent MySQL/PostgreSQL schema management.
https://github.com/k0kubun/sqldef
saved 2019-09-04 https://dotat.at/:/CMJ55.…

GitHub - sqldef/sqldef: Idempotent schema management for MySQL, PostgreSQL, SQLite, and SQL Server
Idempotent schema management for MySQL, PostgreSQL, SQLite, and SQL Server - sqldef/sqldef

🚀 Programmatic access via REST APIs and the NocoDB SDK. Requests are authorized with JWT or social auth tokens.
🐳 Runs from a single #Docker command with SQLite or #PostgreSQL. An auto-upstall script installs Docker Compose, Redis and Traefik, and sets up plus renews SSL automatically.…

from my link log —
Failover replication slots for PostgreSQL.
https://www.2ndquadrant.com/en/blog/failover-slots-for-postgresql/
saved 2020-06-08

EDB Home - EDB Postgres AI
Experience zero data sprawl and fully repatriated EDB Postgres with AI, handling over 30B+ trades a day on a 50 TB scale.

In which I introduce my new project
#sql #postgreSQL

Introducing Retrofit | Chris K Wensel
Introducing Retrofit, a CLI that records database schema evolution as logical, identity-preserving operators instead of hand-written DDL migrations.

At Berlin Buzzwords 2026, Gülçin Yıldırım Jelinek joined us with "What you should know about constraints in PostgreSQL 18" and gave a detailed walkthrough of the pg_constraint catalog, what’s new in PostgreSQL 18 and what’s coming in PostgreSQL 19.
Full session: #bbuzz

from my link log —
Querying PostgreSQL tables from DuckDB.
https://duckdb.org/2022/09/30/postgres-scanner.html
saved 2022-09-30 https://

Querying Postgres Tables Directly from DuckDB
DuckDB can now directly query tables stored in PostgreSQL and speed up complex analytical queries without duplicating data.

🐘 #Microsoft open-sourced #pgdurable, a new #PostgreSQL extension that brings durable execution directly into the database — long-lived, fault-tolerant workflows run inside

from my link log —
LOAD "PL/CBMBASIC",8,1: Commodore 64 BASIC for PostgreSQL.
https://thombrown.blogspot.com/2026/07/load-plcbmbasic81-commodore-64-basic.html
saved 2026-07-06

🚀 Fits vector embedding pipelines (chunk, embed, upsert into #pgvector), ingest/ETL jobs, scheduled DB maintenance and external API workflows. Released under the permissive PostgreSQL License — clone and run it anywhere
🌐

Check out our latest retrofit demo:
https://retrofit.sh/demos/liquibase-adopt-retrofit/
This week we inject retrofit into a Liquibase user flow. Retrofit captures the current schema rendered by Liquibase and then authors forward and rollback migration scripts to be run b…

Use Retrofit with an existing Liquibase project · retrofit
See Retrofit import Metabase's Liquibase-built PostgreSQL schema, identify which version it is at, render a staged foreign key's forward and rollback SQL from one operation log, and have Liquibase deploy and roll back both.

📊 Every request, decision and response is written to #PostgreSQL for a complete audit trail, with a #React admin UI for the audit viewer, policy editor, eval results and agent management
🧪 A policy builder agent analyzes observed traffic and drafts policies automatically, an eval system…

📊 Architecturally minimal: a Postgres extension plus a background worker, built on two Rust libraries — duroxide (orchestration runtime with deterministic replay & checkpoints) and duroxide-pg (Postgres-backed state provider). Runs on PostgreSQL 17

Progress on my new open source project retrofit continues.
As we work to getting a stable release I’d be happy for others to kick around, we’ve decided to make Wednesdays demo day.
So do please check out our new demo:
https://retrofit.sh/demos/flyway-adopt-retrofit/

Use Retrofit with new or existing Flyway projects · retrofit
See Retrofit import Marquez's mature PostgreSQL schema, add and validate a foreign key between existing tables, and register the generated SQL with Flyway.

from my link log —
The curious case of the table-locking UPDATE query on PostgreSQL.
https://blog.heroku.com/curious-case-table-locking-update-query
saved 2019-12-19

The Curious Case of the Table-Locking UPDATE Query
Check out how I debugged a long-running UPDATE database query modifying a single row, and why such a seemingly simple query caused so much harm.

📊 Request logging lets you inspect authenticated traffic to monitor and diagnose agent behavior
⚙️ Single #Go binary acting as server and CLI: API on port 14321, proxy on 14322, #SQLite by default, #PostgreSQL

When I was advocating for nogil/free-threading, I always said that it’s important not to judge threads by the APIs we have, but by the APIs we will build once they’re worth the trouble.
Here’s my first contribution: a way to run fault-tolerant background threads with PostgreSQL-based¹ orchestration: lease-based leader election & NOTIFY dispatch.
Hope you like it—it fell out of 2 other projects I want to open-source eventually.
¹ requires @…, SQLAlchemy optional
https://github.com/hynek/pgbg

⚙️ Stack: #Go 1.25 backend with 90 REST endpoints, #Nextjs 15 React 19 #TypeScript frontend, #PostgreSQL

📋 #NocoDB turns any #MySQL, #PostgreSQL or #SQLite database into a collaborative spreadsheet …