@fanf@mendeddrum.org2025-12-24 09:42:03
from my link log —
Instant database clones with PostgreSQL 18.
https://boringsql.com/posts/instant-database-clones/
saved 2025-12-23 https://
@fanf@mendeddrum.org2025-12-24 09:42:03
@wyri@toot-toot.wyrihaxim.us2026-01-26 16:55:16
Set up HA to sent a metrics to Prometheus over MQTT so I can scale the PostgreSQL server I have on my home cluster for development down when my PC is off:
#MQTT #HomeAssistant #PostgresQL
@lightweight@mastodon.nzoss.nz2026-02-26 03:43:27
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!
@ladefuchs@electroverse.tech2025-12-25 17:12:09
Wir suchen ab sofort eine/n Backend Developer mit Skills in Rust, PostgreSQL, Next.js und Zeit und Lust in einem kleinen Team die eMobilität voranzubringen.
Nicht für Geld sondern für die Community, dafür für ein echtes Projekt mit ab und zu Dank und Mitgestaltungsmöglichkeiten.
malik@ladefuchs.app
@socallinuxexpo@social.linux.pizza2026-02-24 18:15:01
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
@fanf@mendeddrum.org2025-12-15 12:42:01
from my link log —
Do you really need Redis? PostgreSQL does queuing, locking, and pub/sub.
https://spin.atomicobject.com/2021/02/04/redis-postgresql/
saved 2021-06-12
@rperezrosario@mastodon.social2026-02-19 00:36:45
Tiger Data author Raja Rao makes a pretty good case for reducing operational complexity by using a single database server (PostgreSQL) to supplant non-relational use cases that were previously handled by the likes of Elasticsearch, Redis, and MongoDB to name a few.
He goes on to list and explain the different PostgreSQL extensions that can provide equivalent services without the database sprawl.
"It's 2026, Just Use Postgres"
@fanf@mendeddrum.org2025-12-21 09:42:03
from my link log —
pg_textsearch: PostgreSQL extension for BM25 relevance-ranked full-text search.
https://github.com/timescale/pg_textsearch
saved 2025-12-18
@frankel@mastodon.top2026-01-20 09:12:37
I Love You, #Redis, But I’m Leaving You for #SolidQueue
https://www.simplethread.com/redis-solidqueue/…
@fanf@mendeddrum.org2026-02-21 09:42:02
from my link log —
pgagroal: a high-performance connection pool for PostgreSQL.
https://github.com/agroal/pgagroal
saved 2020-01-29 https://dotat.at/…
@socallinuxexpo@social.linux.pizza2026-02-23 21:30:05
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! 🚀
@thoralf@soc.umrath.net2026-02-12 07:31:49
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.
@socallinuxexpo@social.linux.pizza2026-02-23 17:20:02
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
@socallinuxexpo@social.linux.pizza2026-02-23 17:10:01
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
@inthehands@hachyderm.io2026-02-08 22:49:35
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?
@nobodyinperson@fosstodon.org2026-02-13 18:22:30
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.
@rperezrosario@mastodon.social2026-02-19 00:17:21
This Supabase article by IT Tooling Engineer Pedro Rodrigues presents a code repository that contains best practices for PostgreSQL database design and development.
What makes this project outstanding is that best practices are encoded in a way an AI agent using MCP, and the Agent Skills open format can understand.
TLDR? Here is a direct link to the repo:
@fanf@mendeddrum.org2026-02-04 12:42:01
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
@michabbb@social.vivaldi.net2026-02-08 15:43:24
@fanf@mendeddrum.org2026-02-10 21:42:01
from my link log —
Debugging random slow writes with GIN indexes in PostgreSQL.
https://iamsafts.com/posts/postgres-gin-performance/
saved 2021-04-06
@aredridel@kolektiva.social2025-11-28 16:19:02
Content warning: open source whinging
Ugh why is this always the way. I evaluated like 25 authentication servers for a small scale web project — I do want to support things like OIDC and Passkeys, so this is not something I really want to make myself like the old days of “use crypt() on the passwords and just make a simple database”.
5 of them are just dev mode garbage that will never see the light of day as a thing people use.
2 of them are home network nonsense for people who want enterprise login for their family, but where One Nerd controls the whole user-list.
15 of them are freemium "open source" where they withhold features for their enterprise tier and make them so unfortunately difficult to deploy, all requiring postgresql databases and a complex containerization setup and helm charts and oh so much.
and then there's kanidm, which is great except its opinions make it completely unusable for a community project, it's really more trying to fit the ‘enterprise unix authentication' space. Kudos to them for communicating it but it's the wrong tool, even if it is really good.
And then there's rauthy. Which is exactly what I want, well built and delightful, uses a lightweight embedded database, and even has a peer-to-peer sync for scalability. But customizing it is going to be a lesson in building it from source repeatedly, and its configuration is just a bit strange, and its frontend is extremely Backend Developer Wrote A Web UI. I guess I got a second project. And maybe a third to make debian packages of it.
Yet it really is the best of the options _by far_.
NLNet supported projects continue to punch above their weight class.
@fanf@mendeddrum.org2026-01-12 00:01:42
got nerdsniped by a very old and widely-repeated falsehood in the postgres docs https://www.postgresql.org/message-id/6b35a3d6-ec6d-2c34-dc10-7cfa739c27cc@dotat.at
@socallinuxexpo@social.linux.pizza2026-02-18 11:45:02
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
@fanf@mendeddrum.org2026-02-10 09:42:01
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
@nobodyinperson@fosstodon.org2026-02-07 13:55:47
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
@socallinuxexpo@social.linux.pizza2026-02-09 18:20:02
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
@fanf@mendeddrum.org2026-01-19 15:42:03
from my link log —
diesel-guard: check for expensive PostgreSQL migrations in Rust.
https://dev.to/ayarotsky/your-diesel-migrations-might-be-ticking-time-bombs-30g7
saved 2026-01-16
@socallinuxexpo@social.linux.pizza2025-12-16 20:30:05
🧑💻 Whether it’s PostgreSQL or a passion project, we want it on the SCaLE 23x expo floor! Booths are free for community orgs—nominate now:
https://www.socallinuxexpo.org/blog/23x-booth-grants
@fanf@mendeddrum.org2025-12-07 15:42:01
from my link log —
Locks in PostgreSQL.
https://habr.com/en/company/postgrespro/blog/504498/
saved 2020-06-03 https://dotat…
@michabbb@social.vivaldi.net2025-12-14 00:44:23
#pgaiquery v0.1.0 — First stable release brings multi-model #AI directly into #PostgreSQL #opensource
@chris@mstdn.chrisalemany.ca2025-12-08 20:26:30
just looking at my archive of postgresql backups over the past 2 years of my mastodon instance.
In December 2023 just shy of 1 year since spinning it up, the compressed gz file of the database was 600MB.
By Aug 2024 it was 988MB
In April 2025 it was 1500MB
Today it is 1800MB.
That is a 2 user instance. Not small!
#selfhost #footiMac #Debian #mastodon #fediverse #upgrade
@socallinuxexpo@social.linux.pizza2026-02-14 22:10:02
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
@socallinuxexpo@social.linux.pizza2026-02-13 17:00:09
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
@fanf@mendeddrum.org2025-12-11 15:42:02
from my link log —
A workflow for maintaining feature branches and submitting patches to PostgreSQL.
https://blog.2ndquadrant.com/maintaining-feature-branches-submitting-patches-git/
saved 2019-01-15
@socallinuxexpo@social.linux.pizza2026-02-12 02:00:05
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
@socallinuxexpo@social.linux.pizza2026-02-11 16:25:01
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
@socallinuxexpo@social.linux.pizza2026-02-10 05:25:01
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
@fanf@mendeddrum.org2026-02-06 15:42:01
from my link log —
Notes on porting from Oracle to PostgreSQL.
https://news.ycombinator.com/item?id=21260001
saved 2019-10-15 https://
@fanf@mendeddrum.org2025-12-05 18:42:01
from my link log —
A PostgreSQL developer's .psqlrc
https://news.ycombinator.com/item?id=23826037
saved 2020-07-13 https://dot…