Tootfinder

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.

Welp, that was non-trivial, but I've just managed to upgrade one of my Peertube instances from 7.3.0 -> 8.0.2 (includes an upgrade from PostgreSQL 13 -> 17)! Very impressive bit of kit, this! Well done Framasoft and friends!

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

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

#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 —
pgagroal: a high-performance connection pool for PostgreSQL.
https://github.com/agroal/pgagroal
saved 2020-01-29 https://dotat.at/…

GitHub - pgagroal/pgagroal: High-performance connection pool for PostgreSQL
High-performance connection pool for PostgreSQL. Contribute to pgagroal/pgagroal development by creating an account on GitHub.

Phil Vacca will speak on 'Did VS Code Quietly Become a Go-To Postgres Tool?' as part of our PostgreSQL@SCaLE track at SCaLE 23x. Full details: https://www.socallinuxexpo.org/scale/23x

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.

Ich habe gestern Abend den #Homeassistant doch wieder auf PostgreSQL als recorder-Backend umgestellt, weil die SQLite-Datei geradezu explodiert ist (23 GB nach anderthalb Monaten) und das System immer langsamer wurde.
Außerdem habe ich ltss hinzugefügt, damit die reguläre PostgreSQL-Datenbank schnell und einigermaßen klein bleibt.

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

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.

Speaker Spotlight: Henrietta Dombrovskaya
PostgreSQL and Academia—Establishing Partnership Watch the full talk:
https://youtu.be/6sgV0UxZw5Y?si=eFG9FQs67e0ImYey
Join us at SCaLE 23x to explore how open source is transforming education! 🚀

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

Nick Meyer will speak on 'Practical PgBouncer Pain Prevention' as part of our PostgreSQL@SCaLE track at SCaLE 23x. Full details: https://www.socallinuxexpo.org/scale/23x

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, […]

Specific recommendations for deploying a fairly vanilla server-side Swift PostgreSQL project?
(Small project, small DB, low traffic, bonus points for non-US location but not required)
Thoughts on just going with a “generic Docker” service vs a service that natively supports Swift?

TIL that #Immich hard-codes all its paths into its postgresql database. What a nightmare for migrations. None of the tasks in the UI helped. Tried replacing it in the db, no chance. Had to resort to bind mounting shenanigans.

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

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

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?

🔁 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

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

from my link log —
Composite data type performance issues in PostgreSQL.
https://www.cybertec-postgresql.com/en/composite-type-performance-issues-in-postgresql/
saved 2020-06-17

#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 —
Debugging random slow writes with GIN indexes in PostgreSQL.
https://iamsafts.com/posts/postgres-gin-performance/
saved 2021-04-06

If you have an #sqlite-backed #paperless consume your email attachments, you'll frequently run into "database locked" errors. It'll retry next time, so you'll get there eventually, but still annoying. Might need to migrate to a

PostgreSQL@SCaLE is a co-event at SCaLE 23x. We're excited to have them join us in Pasadena. Learn more: https://www.socallinuxexpo.org/scale/23x/special-event/postgresqlscale

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

Alexandra Wang will speak on 'Helping the Planner Help You: Extended Statistics in PostgreSQL' as part of our PostgreSQL@SCaLE track at SCaLE 23x. Full details: https://www.socallinuxexpo.org/scale/23x

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…

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

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

🔧 Configurable thresholds for scan warnings, query cost limits & small table optimization
🧩 Custom analyser support via QueryAnalyser interface for PostgreSQL or other databases
🎯 Works with #PHPUnit setUp() & #Pest beforeEach() including "paranoid mode"
📦 compos…

Robert Treat will speak on 'Vacuuming Large Tables: How Recent Postgres Changes Further Enable Mission Critical Workloads' 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

Max Englander will speak on 'Building a Postgres DBaaS with open source' as part of our PostgreSQL@SCaLE track at SCaLE 23x. Full details: https://www.socallinuxexpo.org/scale/23x

📖 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

Bruce Momjian will speak on 'The Wonderful World of WAL' as part of our PostgreSQL@SCaLE track at SCaLE 23x. Full details: https://www.socallinuxexpo.org/scale/23x

Christophe Pettus will speak on 'Full Text Search, the Next Generation' as part of our PostgreSQL@SCaLE track at SCaLE 23x. Full details: https://www.socallinuxexpo.org/scale/23x

Ibrar Ahmed will speak on 'Eight Steps to Bullet-Proof Database Disaster Recovery' as part of our PostgreSQL@SCaLE track at SCaLE 23x. Full details: https://www.socallinuxexpo.org/scale/23x

from my link log —
Notes on porting from Oracle to PostgreSQL.
https://news.ycombinator.com/item?id=21260001
saved 2019-10-15 https://

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.

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

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

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

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

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

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