Tag
This article introduces a web-based tool that checks the safety of PostgreSQL migrations using a WASM parser, helping developers validate database changes.
The article explains that PostgreSQL's SELECT DISTINCT clause does not scale efficiently, as it always scans all matching rows, leading to performance problems in certain workloads, and provides insights and workarounds.
Cronhq is a scheduler that ensures exactly-once execution for cron jobs, featuring retries, HMAC-signed webhooks, and heartbeats, built on Rust and Postgres, and is open-source under MIT license.
TIN is a fast, full-featured full-text search extension for Postgres that supports boolean expressions, fuzzy matching, and concurrent operations, released by PlanetScale as a GA product.
A discussion about using Jev for query optimization, with one user sharing a 12% speed improvement in Postgres queries and another commenting on Jev's performance issues.
Supabase is an open-source Postgres development platform offering a hosted database, automatic API generation, authentication, and AI tools, earning over 109k stars on GitHub for its efficiency and comprehensiveness.
The article describes an experiment where a 4B AI model is trained via fine-tuning and reinforcement learning to optimize Postgres query plans, achieving an 81% faster performance and 44.7% latency reduction across join-heavy queries.
The article explores the role of humans in AI-assisted software development, emphasizing that human expertise is crucial beyond basic AI prompting, as seen in projects like rewriting Postgres in Rust for performance gains and the author's own AI orchestration systems.
This article analyzes trends in development activity for the Postgres project, using data from mailing lists and git repositories to quantify changes over time.
WalShadow is an open-source tool that replicates Postgres data to ClickHouse with sub-second latency by directly consuming physical WAL, enabling real-time analytics with high throughput and schema evolution support.
Sam Lambert tweets that Unsharded Neki is an extremely powerful tool for running PostgreSQL at any scale and predicts it will become the best method for doing so.
Neki is a sharded Postgres solution by PlanetScale that enables horizontal scaling to hundreds of millions of QPS and petabytes of data with zero-downtime operations.
EterDB is a Postgres fork that allows transaction-level undo and dependency-aware recovery, enabling easy reversal of mistakes in production databases without full restores.
The article explains how to handle race conditions in PostgreSQL when modeling state transitions with an append-only table, suggesting the use of SELECT FOR UPDATE to serialize transactions and avoid inconsistencies.
Restoredrill is an open-source tool that automates the testing of PostgreSQL backups by restoring them into a container and running verification checks, producing audit-ready reports for compliance.
The article identifies a common failure pattern in AI agent deployments where successful reports mask silent database write failures, and introduces a SDK called Synathic to automatically verify post-execution state.
This article explains the problem of poisoned connection pools in PostgreSQL when using PgBouncer, where stale session state can cause write errors, and provides a solution using DISCARD ALL to reset connections.
Cloudflare improved query performance by 35x on billion-row Postgres tables using TimescaleDB (Tiger Cloud), and built a real-time earthquake dashboard with Claude Code and Tiger CLI.
A developer reflects on a decade-old article about Postgres connection management, surveys popular managed Postgres providers, and argues that PgBouncer-style connection pooling is effectively a mandatory core feature.
Snowflake's engineering blog details the new Postgres data mirroring feature that pushes changes via a snowflake_cdc extension into Iceberg tables, aiming for resilient, low-lag transactional replication.