Postgres/PostgreSQL: pgEdge Platform, Coroot, PostgreSQL at Home
-
PostgreSQL ☛ pgEdge Distributed PostgreSQL: The Next Generation — Introducing pgEdge Platform v24.7, Constellation Release
pgEdge has just released the latest version of its flagship product, pgEdge Platform v24.7, known as the Constellation Release. This update brings a host of new features designed to enhance the capabilities of distributed PostgreSQL databases. Building on its foundation as the only fully distributed PostgreSQL that is open (source code available) and based on standard PostgreSQL, pgEdge continues to lead the way in providing ultra-high availability and reduced latency across geographic regions. The Constellation Release introduces significant improvements, including advanced logical replication features, large object support, and enhanced error handling. These enhancements make pgEdge an even more powerful alternative for legacy multi-master replication technologies, offering greater throughput, flexibility, and control for users.
-
PostgreSQL ☛ Coroot 1.4: Simplify PostgreSQL Monitoring (Open Source)
Summary: Coroot, an open-source monitoring and observability tool, has been further optimized for PostgreSQL in version 1.4. This release offers seamless integration for better performance, security, and cost monitoring. No extra configuration needed.
Here's what Coroot 1.4 offers:
We moved our home DB to PostgreSQL
This is one of those unhelpful status updates with no detail whatsoever! But I successfully spent part of yesterday moving Clara’s and my internal DB on our FreeBSD homelab box to Postgres. Everything in our homelab (and home life) revolve around a single database, from helper scripts to budgets. It’s a mess, but it’s our mess, and it’s something that’s been oddly fun to see grow over the years. I tend to start with schemas or data structures before writing any program; it’s just how my mind works.
KiribenDB
started its life briefly as a SQLite3 database, before moving to MySQL in the late 2010s. There’s nothing exotic or interesting about it, save for it being fully BCNF’d, which I still maintain sounds like an American rail company. This made it easy to export, change a few suble lines of syntax, and import as Postgres. No indexes, no fancy data types, just your run-of-the-mill stuff.