Tag
Paul Graham highlights a graph showing Supabase now deploys over 1 million new Postgres databases every week, a notable milestone for a six-year-old company.
Andy Pavlo, a renowned database professor from Carnegie Mellon, joins ClickHouse to establish and lead ClickHouse Labs, a new research group focused on advancing database technology and integrating innovations into ClickHouse and PostgreSQL.
Azure Friday episode with Scott Hanselman and Paula Berenguel demonstrates scaling read-heavy PostgreSQL workloads on Azure Database for PostgreSQL Flexible Server using read replicas and virtual endpoints for failover, following the same pattern that powers ChatGPT.
DuckDB is introducing asynchronous I/O for Parquet and CSV files in v2.0, improving remote storage query performance by avoiding blocking worker threads during data fetches.
Rivet engineers detail how they built a zero-disk, S3-tiered storage engine for SQLite, enabling isolated databases with instant startup, low-latency writes, point-in-time recovery, and bottomless storage for millions of Actors.
Docker shares a comprehensive guide by Nick Janetakis on backing up PostgreSQL in Docker, covering local storage, S3, and the open-source Plakar tool for reliable daily backups and restores.
A detailed technical blog post explaining how to scale PostgreSQL-backed queues using SKIP LOCKED and proper transaction isolation levels, achieving 30K workflow executions per second.
Google Cloud provides a codelab for using the remote MCP server with AlloyDB to quickly build an AI agent that can query your database.
Vlad Mihalcea explains how the JTA transaction type works, including the 2PC protocol and how to use JTA with Spring for global transactions across multiple data sources such as PostgreSQL and Ehcache.
Alibaba Cloud launches a one-stop AI memory solution combining PolarDB, MemOS, and MemTensor, offering relational, vector, and graph retrieval in a single PolarDB-PG instance, reducing P99 latency by up to 89.2%.
A detailed technical analysis of PostgreSQL's MVCC design, its known drawbacks like write amplification and vacuum overhead, and a comparison to alternatives that shows all database engines face similar fundamental trade-offs.
Oracle announces a new era for MySQL, moving previously commercial features into the Community Edition and introducing a governance model to rebuild community trust, with the release of MySQL 9.7.0 LTS.
A SQL tutorial for building a logistics and shipment analytics database, covering schema design, sample data, and key business KPIs for supply chain optimization.
Samantha McBride's company migrated from a legacy stack to MongoDB to build a flexible financial services platform, enabling easier AI agent deployment without client data restructuring.
PGSimCity is a 3D interactive model that visualizes the inner workings of the PostgreSQL database engine, providing an educational tool for understanding its architecture.
SQLite's WAL mode can cause 'database is locked' errors for short-lived read-only connections due to internal locking of the WAL index file; a busy timeout or switching to DELETE mode can resolve the issue.
Release of sqlite-utils 3.39.1, a Python utility for manipulating SQLite databases.
This blog post debunks the myth that Postgres LISTEN/NOTIFY does not scale, showing how to optimize it for 60K writes per second with millisecond latency.
GoodfireAI used interpretability to predict which genetic variants cause disease, validated predictions with real-world data, and released an open-source database for all variants in the NIH's ClinVar database.
A comprehensive guide for startups running PostgreSQL in production, covering schema design, query optimization, indexes, migrations, connection management, and advanced topics like query planning and partitioning.