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.