PostgreSQL 19 Graph Queries & REPACK; SQLite Advanced SQL Patterns

PostgreSQL 19 Graph Queries & REPACK; SQLite Advanced SQL Patterns

Today's Highlights

PostgreSQL 19 introduces major features with SQL/PGQ for graph queries on relational data and a new REPACK command to combat table bloat. Meanwhile, the SQLite community explores advanced SQL patterns for complex 'first match' selection logic, pushing the boundaries of efficient embedded database querying.

SQL/PGQ in PostgreSQL 19: Graph Queries Without the Graph Database (Planet PostgreSQL)

Source: https://postgr.es/p/9kW