Supabase is acquiring Turso to build database infrastructure for AI agents. Supabase will continue supporting Postgres while Turso maintains SQLite, with both platforms integrated to provide seamless scaling from prototyping to production as agent-generated workloads grow.
An article examining Postgres reliability under adverse conditions, focusing on how memory management and query tuning challenges can cause databases to fail unexpectedly. It demonstrates through a practical example how a seemingly safe query can consume excessive memory as data scales, highlighting Postgres's lack of per-query memory limits and the complexities of the work_mem setting.
pg_redact is a Postgres extension that uses content-aware PII detection to redact personal information in free-text fields. It combines regex pattern matching to identify candidate snippets with Jev, TypeSafe's classification model, to determine what constitutes PII in context, then applies role-based masking rules via SQL functions.
Postgres DELETE operations have a poor reputation for performance, but the article demonstrates they can scale effectively with proper optimization. The key challenge isn't deleting workflows themselves, but managing the cascading deletions of associated data across multiple tables and handling the MVCC (multi-version concurrency control) overhead that creates dead tuples requiring vacuum cleanup. By understanding Postgres's internal deletion mechanism and optimizing cache and index performance, DELETE can be used reliably in high-throughput systems processing tens of thousands of workflows per second.
PlanetScale released TIN, a full-text search extension for Postgres that initially showed 8x performance improvements over ParadeDB. ParadeDB responded with optimization work and closed the performance gap through several optimization passes unrelated to TIN's claimed architectural advantage of using Postgres ctid fields as document identifiers.