cartero Tuesday, August 11, 2026 · No. 25893
PostgreSQL

Regina Obe: Replacing pgAgent with pg_timetable: Part 1

pgAgent has been my go to scheduling solution for quite some time. Sadly in 6 months it will be completely retired and the pgAgent UI in pgAdmin will be gone. The main reasons I liked pgAgent were: Cross Platform: I have a lot on windows and linux customers, so this was important. Nice UI in pgAdmin, so I could do all work with PostgreSQL and schedule things at the same time as well as check status of jobs. The database backend is PostgreSQL, my favorite database Supports Multiple Agent...

NewSQL

The Consensus Weekly, June 20, 2026

From The Consensus Pierre Zemb from Clever Cloud Pierre Zemb is a staff engineer at Clever Cloud where he's building data layers API-compatible with services like Redis, PostgreSQL, and etcd on top of FoundationDB. The latest in our series interviewing developers working on software infrastructure.

Query Planning

Andrei Lepikhov: Optimising Polymorphic Associations in PostgreSQL

Recently, I looked into how common polymorphic associations actually are in relational databases — a performance-hostile pattern built around a discriminated foreign key that ORMs (Rails, Django, Hibernate), CRM platforms (Salesforce), and 1C generate automatically. The front page of a typical online store, or the activity feed of a CRM, is built by exactly this kind of query: a base table is LEFT JOIN-ed to every possible subtype through a (type, id) pair of columns.That earlier article an...

Rust

Cargo-Geiger

Graph Databases

Better Graph Database Ball

submitted by /u/eatonphil [link] [comments]