Tootfinder

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 —
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.

Henrietta Dombrovskaya will speak on 'PostgreSQL and Academia: Establishing Partnership' as part of our Open Source in Higher Education track at SCaLE 23x. Full details: https://www.socallinuxexpo.org/scale/23x

"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

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.

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 —
When upserts don't update but still write: debugging PostgreSQL WAL activity.
https://www.datadoghq.com/blog/engineering/debugging-postgres-performance/
saved 2026-03-24

When upserts don't update but still write: Debugging Postgres performance at scale | Datadog
When a high-volume upsert doubled disk writes, Datadog engineers traced the issue to Postgres WAL behavior and rewrote the query to eliminate hidden costs.

It took me way too long, but I finally migrated from PostgreSQL 13 to 17. The last two times I started working on it, I wasn't able to finish. I was convinced that a direct upgrade would have been best and got lost in researching how to do that with my setup (unraid, docker). Today, I went the backup restore route and was done in half an hour.

📐 #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 —
Replication configuration changes in PostgreSQL 12.
https://www.2ndquadrant.com/en/blog/replication-configuration-changes-in-postgresql-12/
saved 2019-10-07

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...

https://lemmy.world/post/43988094
There are going to be a lot of projects forked to remove or halt ai coming up.

New ntfy.sh v2.18.0 was written by AI - Lemmy.World
According to the release: >Adds experimental PostgreSQL support >The code was written by Cursor and Claude >14,997 added lines of code, and 10,202 lines removed >reviewed and heavily tested over 2-3 weeks This makes me a bit uneasy, especially as ntfy is an internet facing service. Am I overreacting or do you all share the same concern?

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/

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

🔁 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

Magnus Hagander will speak on 'What's new in PostgreSQL 18' as part of our PostgreSQL@SCaLE track at SCaLE 23x. Full details: https://www.socallinuxexpo.org/scale/23x

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 query cancellation / Ctrl-C in psql is insecure.
https://neon.com/blog/ctrl-c-in-psql-gives-me-the-heebie-jeebies
saved 2026-03-23

Ctrl-C in psql gives me the heebie-jeebies - Neon
There are a few different reasons to hit the brakes on a Postgres query. Maybe it’s taking too long to finish. Maybe you realised you forgot to create an index that will make it orders of magnitude quicker. Maybe there’s some reason the results are no longer needed. Or maybe you, or your LLM buddy, […]

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

#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,

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 —
pg_plan_advice: plan stability and user planner control for PostgreSQL?
http://rhaas.blogspot.com/2026/03/pgplanadvice-plan-stability-and-user.html
saved 2026-03-11

« 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…

Hamid Akhtar will speak on 'Where Does My INSERT Go? A Logical Replication Story' as part of our PostgreSQL@SCaLE track at SCaLE 23x. Full details: https://www.socallinuxexpo.org/scale/23x

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.
−

from my link log —
PostgresqlCO.NF: a PostgreSQL configuration guide.
https://postgresqlco.nf/
saved 2020-02-02 https://dotat.at/:/V3K8F.html

Elizabeth Christensen, Devrim Gunduz, Ryan Booz will speak on 'Postgres Query Tuning - Hour 6 of Postgres Training Day' as part of our PostgreSQL@SCaLE track at SCaLE 23x. Full details: https://www.socallinuxexpo.org/scale/23x

success! Upgraded #footiMac to Debian 13/Trixie and brought Mastodon along for the ride.
Had a few hiccups...
1) I upgraded elasticsearch and ended up having to clear out its cache files as it didn't want to 'upgrade' them itself.
2) postgresql 15 and 16 are still running in the background and needed new timezones in their configs.
3) Charlock_holmes ruby gem was unhappy (as noted in recent Mastodon release notes) and needed: bundle install --force to actually get it to install again.
4) libvibs is not happy either, so I turned it off in the config file. This seems to be an ongoing issue.
Once those things were found and fixed, it all came back up.
Phew! Wonder what else broke lol
#Mastodon #Debian #Trixie #MastoAdmin #selfhost

📖 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

from my link log —
pg_jitter: lighter-weight multi-backend JIT for PostgreSQL.
https://github.com/vladich/pg_jitter
saved 2026-03-04 https://dotat.…

GitHub - vladich/pg_jitter: Better JIT for Postgres
Better JIT for Postgres. Contribute to vladich/pg_jitter development by creating an account on GitHub.

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

from my link log —
The real cost of random I/O in PostgreSQL.
https://vondra.me/posts/the-real-cost-of-random-io/
saved 2026-03-02 https://…

from my link log —
Writing a PostgreSQL formatter / pretty printer in Rust.
https://blog.urth.org/2021/03/14/writing-a-postgres-sql-pretty-printer-in-rust-part-1/
saved 2021-03-18

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