news
PostgreSQL and More
-
PostgreSQL ☛ plx : Write PostgreSQL functions in the language you already know.
What plx is
plx is a PostgreSQL extension that lets you write stored functions and triggers in the dialect you already know (the current set is listed below). When you run
CREATE FUNCTION, plx transpiles the body to plpgsql and stores that plpgsql inpg_proc.prosrc. At run time the function is executed by PostgreSQL's own plpgsql interpreter. There is no separate language runtime loaded into the backend, and nothing new to run in production. -
PostgreSQL ☛ SynchDB 1.4 Released - Oracle Container Database Support and TLS-Secured FDW Snapshots
Dear Community Members,
We are excited to announce the release of SynchDB 1.4, a PostgreSQL extension for real-time replication from heterogeneous source databases into PostgreSQL/IvorySQL.
This release extends Oracle Container Database support to every Oracle replication path, allows snapshot connections to be encrypted, and improves stability under sustained replication load.
-
PostgreSQL ☛ New Modern JDBC Driver for PostgreSQL
Sehrope Sarkini along with Claude has written a new JDBC driver from scratch. It's currently in pre-release. Here's an excerpt from his blog
PostgreSQL-first.
The native API is designed around PostgreSQL's wire protocol and feature set. It is not designed around the lowest common denominator that JDBC has to support across every database on earth. If PostgreSQL can do it, the API should be able to say it directly.
-
PostgreSQL ☛ Dasha - performance dashboard
Dasha is an open source performance dashboard for PostgreSQL fleets. It connects to your clusters with a read-only role, shows what the databases are doing right now, and explains what to do about it. Nothing is installed on the database hosts: no agent, no extension beyond the ones you already have.
-
The Register UK ☛ Tailscale says deeply buried 16-year-old SQLite bug caused last year's outages
The Tailscale team announced in a Wednesday blog post that it had finally addressed the issue with the help of SQLite maintainers, who even had to create a new tool (with Tailscale funding) to log virtual file system activity in order to track the thing down, which Tailscale software engineer Alex Chan described as resisting “all our initial attempts to find it.”