Tootfinder

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.

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 —
Foreign Data Wrappers for migrating from Oracle to PostgreSQL.
https://www.migops.com/blog/2021/02/15/role-of-foreign-data-wrappers-in-migrations-to-postgresql/
saved 2021-04-06

MigOps.com is for sale | HugeDomains
Join thousands of people who own a premium domain. Affordable financing available.

"PostgreSQL, MySQL, Cassandra, and other popular open source systems are not measured in and of themselves – only as part of commercial services."
What is the purpose of essentially delisting #PostgreSQL, #MySQL,

from my link log —
Updating the PostgreSQL root.crt file for TLS client auth.
https://www.2ndquadrant.com/en/blog/updating-the-postgresql-root-crt-file/
saved 2020-08-25

EDB Home - EDB Postgres AI
Join the era of Sovereign AI with EDB Postgres. Simplify your hybrid architecture, gain insights, and access training from leading Postgres experts.

#PostgreSQL running in the browser with an S3 storage backend - that's pretty impressive
https://www.zerofs.net/postgresql-in-the-browser

PostgreSQL 18 brings real changes to how constraints work. Gülçin Yıldırım Jelinek (PostgreSQL contributor, Xata) is at #bbuzz26 to walk through what you should know if you're running Postgres in production.
Learn more about this session: https://2026.berlinbuzzwords.de/session/what-you-should-know-about-constraints-in-postgresql-18/

from my link log —
Removing PostgreSQL bottlenecks caused by high traffic.
https://www.percona.com/blog/2020/05/29/removing-postgresql-bottlenecks-caused-by-high-traffic/
saved 2020-06-03

Removing PostgreSQL Bottlenecks Caused by High Traffic
Percona's Robert Bernier writes about removing PostgreSQL bottlenecks caused by high traffic.

For the first time, I tried the "Fix with Copilot" button. I used it for the most trivial thing: changing 'Postgresql' to 'PostgreSQL' in a comment.
And this obscure error happened:
Failed to Fix with Copilot. Please try again. (422)
(I tried again, it failed again.)
I thought that maybe it could be faster than me manually fixing the capitalisation of PostgreSQL in the source file. Turns out it was not since
1. It did not work at all
2. I took that screenshot and wrote that rant
3. I fixed it manually anyway
Shit like that is not going to improve my opinion of AI (which isn’t very high to begin with).

🔌 Non-blocking I/O for regular #PHP functions. fread, fwrite, file_get_contents, ob_start, curl, #MySQL, and #PostgreSQL now work asynchronously without extra effort.
🖥️ Built-in TrueAsync S…

from my link log —
Waiting for PostgreSQL 14: SEARCH and CYCLE clauses.
https://www.depesz.com/2021/02/04/waiting-for-postgresql-14-search-and-cycle-clauses/
saved 2021-03-05

I saw the news of that #PostgreSQL Backup & Restore project being abandoned. Sometimes you need to do what's necessary to put food on the table.
https://github.com/pgbackrest/pgbackrest

from my link log —
What is FETCH FIRST WITH TIES in PostgreSQL 13?
http://sqlservercode.blogspot.com/2020/05/postgresql-adds-fetch-first-with-ties.html
saved 2020-05-27

PostgreSQL adds FETCH FIRST WITH TIES.. just like TOP n WITH TIES in SQL Server
PostgreSQL 13 Beta 1 was released yesterday, you can read the release notes here https://www.postgresql.org/about/news/2040/ One thing t...

Daniel Seybold (co-founder of benchANT) is at #bbuzz26 to ask whether PostgreSQL is now a genuine option for analytical workloads, and what the benchmarks actually show.
Learn more: https://2026.berlinbuzzwords.de/session/from-oltp-to-olap-is-postgresql-eating-analytics-too/
Get your ticket: https://2026.berlinbuzzwords.de/tickets/

📐 #PostgreSQL types auto-generate #TypeScript clients — no manual type mappings, no DTO layers, no impedance mismatch. Types flow outward from DB to frontend automatically.

from my link log —
Tips for PostgreSQL bulk data loading.
https://www.2ndquadrant.com/en/blog/7-best-practice-tips-for-postgresql-bulk-data-loading/
saved 2020-09-16

EDB Home - EDB Postgres AI
Experience EDB Postgres AI, the world's first sovereign AI & data platform. Manage, observe, and operationalize your data for optimized AI strategies.

Kirby – Das elegante Flat-File CMS
https://graffiti.bayerwald.social/my-blog/mein-erster-test-artikel

Kirby – Das elegante Flat-File CMS
Kirby ist ein modernes Content Management System, das sich von der Masse der SQL-Datenbanken abhängig machenden Lösungen deutlich unterscheidet. Statt MySQL oder PostgreSQL nutzt Kirby das sogenannte

from my link log —
PostgreSQL is a great pub/sub and job server.
https://webapp.io/blog/postgres-is-the-answer/
saved 2021-12-18 https://

Postgres is a great pub/sub & job server
If you need a publish/subscribe or job server at any point in your project, try using Postgres. It'll give you lots of data integrity and performance guarantees, and it doesn't require you or your team learning any new technology.

🔁 RESTful path params like /products/{id}, reverse proxy endpoints (passthrough or transform), HTTP custom types letting #PostgreSQL functions call external APIs directly
🛡️ Enterprise-ready out of the box: authentication, authorization, rate limiting, caching, SSE streaming & full #OpenAPI

« J'ai découvert Beads, Dolt et DoltgreSQL »
#Git #PostgreSQL

from my link log —
BLOB storage in PostgreSQL.
https://www.2ndquadrant.com/en/blog/oracle-to-postgresql-binary-objects/
saved 2020-07-03

EDB Home - EDB Postgres AI
EDB features the world's first sovereign AI and data platform, optimized for your unique workloads and cloud strategy. Explore EDB Postgres AI now!

from my link log —
OLTP performance since PostgreSQL 8.3.
https://www.2ndquadrant.com/en/blog/oltp-performance-since-postgresql-8-3/
saved 2020-10-08

EDB Home - EDB Postgres AI
Explore EDB Postgres AI's solutions, gain insights from experts, and learn about AI strategy behind 5x ROI. Sign up for interactive sessions & download insightful reports.

#Directus layers a blazingly fast #NodeJS API on top of any existing SQL database. No schema changes needed, works with what you already have.
🗄️ Database Freedom:
#PostgreSQL,

« J'ai découvert Beads, Dolt et DoltgreSQL »
#Git #PostgreSQL

from my link log —
pgenie: Type-safe PostgreSQL client code generator.
https://github.com/pgenie-io/pgenie
saved 2026-04-02 https://dotat.at/:/FY5Y5…

from my link log —
PostgreSQL text search: balancing query time and relevancy.
https://about.sourcegraph.com/blog/postgres-text-search-balancing-query-time-and-relevancy/
saved 2021-10-21

No imperative validation in app code. Constraints, foreign keys, check constraints — all declarative in PostgreSQL. No app can corrupt your data. PUT requests are enforced as idempotent.
📦 Installation is simple:
#Docker image available. Native binaries for all platforms. Just run postgrest --help and get started. Current version: v14.4. 195 contributors strong.
−

📖 Automatic API documentation:
PostgREST generates #OpenAPI specs automatically from your schema. Hook up Swagger-UI − interactive, always up-to-date docs for your API. No more manual doc maintenance.
🏗️ Versioning through DB schemas:
Instead of managing API versions in code, PostgREST uses #PostgreSQL

from my link log —
PostgreSQL PostGIS trajectories through space and time.
https://blog.rustprooflabs.com/2020/11/postgis-trajectory-intro
saved 2020-12-02

from my link log —
Potential consequences of using PostgreSQL as a job queue.
http://richyen.com/postgres/2026/05/04/postgres_job_queue.html
saved 2026-05-07

#NpgsqlRest turns your #PostgreSQL database into a blazing-fast standalone #REST #API server …

from my link log —
Performance tuning PostgreSQL for SquareSpace's TLS certificate service.
https://engineering.squarespace.com/blog/2019/performance-tuning-postgres-within-our-tls-infrastructure
saved 2019-08…

Performance Tuning Postgres within our TLS Infrastructure — Squarespace Engineering Blog
At Squarespace, the Edge team manages the TLS infrastructure, which handles the life cycle of millions of SSL certificates used by our customers. This makes us one of the largest users of Let’s Encrypt , a free, automated, and open certificate authority (CA).

🐘 PostgREST turns your #PostgreSQL #database into a fully #RESTful #API — instantly. No back…