Public list by ~postgresweekly
https://github.com/davesavic/pgsavvy
pgsavvy: A Vim-Style TUI for Working With Databases — A Go-powered TUI app for browsing and querying Postgres databases from the terminal, complete with Vim-style navigation, SQL completions, and interactive EXPLAIN plan navigation.
about 1 month ago
https://malisper.me/the-four-horsemen-behind-thousands-of-postgres-outages/
The Four Horsemen Behind Thousands of Postgres Outages — Two weeks ago we mentioned pgrust, an AI-assisted rewrite of Postgres in Rust (which now passes 100% of Postgres's regression tests). Here, its creator outlines the biggest Postgres pain points he set out to conquer with the rewrite.
about 1 month ago
https://hakibenita.com/postgresql-partition-pruning
How to Achieve Pruning When Querying by Non-Partitioned Columns — If a non-partition key column correlates strongly with your partition key (e.g. sequential session IDs in time-partitioned data), CHECK constraints can enable pruning on that column too. Includes a BRIN-inspired approach for handling outlier values.
about 1 month ago
https://www.cybertec-postgresql.com/en/how-sql-pgq-rewrites-to-joins-on-postgresql-19/
How SQL/PGQ Rewrites to Joins on Postgres 19 — Behind the scenes of Postgres 19's support for graph queries and how the graph query syntax compiles down to plain joins.
about 1 month ago
https://www.youtube.com/watch?v=SxIgD1OfU_A
▶  Fixing Bad SQL in Postgres with Jimmy Angelakos — A 55-minute talk of concise explanations of common SQL anti-patterns paired with live psql demos.
about 1 month ago
https://github.com/commandprompt/plx
plx: Write Stored Functions in PHP, JavaScript, Python, and More — Hot on the heels of last week's PL/Ruby comes a more general extension that transpiles JavaScript, PHP, Python, Ruby and even COBOL to PL/pgSQL!
about 1 month ago
https://clickhouse.com/blog/introducing-pg_re2-regex-in-postgres
pg_re2: Fast, RE2-Powered Regular Expressions in Postgres — Google's re2 offers more predictable execution time on regexes than the traditional backtracking approach. ClickHouse shows off its use in Postgres here.
about 1 month ago
https://neon.com/blog/neon-sdk
@neon/sdk: Neon's New TypeScript Client Library — For Neon users who want to work with the Postgres platform's specific features to manage projects, branches, and databases.
about 1 month ago
https://paradedb.com/
Search Without a Second System — One Postgres for your application data, full-text search, vector retrieval, and aggregations. ParadeDB is an open-source Postgres extension that keeps pace with Elasticsearch.
about 1 month ago