Durable, crash-proof functions built into Postgres.

Orchestrate retries, scheduling, parallel fan-out, and conditional branching with a tiny SQL DSL. Built on Postgres + a background worker — no containers, no external services, just Postgres.

• pg_durable @ GitHub.

An AI-powered environment for monitoring, managing, and troubleshooting PostgreSQL systems.

• pgEdge AI DBA Workbench @ GitHub.

PostgreSQL extension for BM25 relevance-ranked full-text search. Postgres OSS licensed.

Intelligent Query Result Caching for PostgreSQL

Leverage vector embeddings to cache and retrieve query results based on semantic similarity.

• Semantic Caching in PostgreSQL: A Hands-On Guide to pg_semantic_cache @ pgEdge.

IVM (Incremental View Maintenance) implementation as a PostgreSQL extension

Incremental View Maintenance (IVM) is a way to make materialized views up-to-date in which only incremental changes are computed and applied on views rather than recomputing the contents from scratch as REFRESH MATERIALIZED VIEW does. IVM can update materialized views more efficiently than recomputation when only small parts of the view are changed.

Related contents:

• You Gotta Push If You Wanna Pull @ Gunnar Morling.

Logical multi-master PostgreSQL replication.

A PostgreSQL SQL syntax beautifier that can work as a console program or as a CGI.

This SQL formatter/beautifier supports keywords from SQL-92, SQL-99, SQL-2003, SQL-2008, SQL-2011 and PostgreSQL specifics keywords. Works with any other databases too.

• pgFormatter @ GitHub.

pgEdge is the open source Enterprise Postgres company.

pgEdge delivers PostgreSQL solutions for maximum high availability, ultra-low latency, zero downtime maintenance, and data residency across deployment options and cloud regions. Single instances can be scaled up to active-active (multi-master) distributed deployments in a matter of minutes, giving you the freedom and flexibility to shift your data needs for your business instantly.

• pgEdge @ GitHub.

Related contents:

• pgEdge goes Open Source @ pgEdge.

🐘 👥 Manage PostgreSQL roles and privileges from YAML or LDAP

Postgres is able to check password of an existing role using the LDAP protocol out of the box. ldap2pg automates the creation, update and removal of PostgreSQL roles and users from an entreprise directory.

• ldap2pg @ GitHub.

Related contents:

• ldap2pg 6.1 disponible @ Dalibo :fr:.
• ldap2pg 6.6 with GSSAPI @ Dalibo :fr:.