--- title: Best PostgreSQL posts — January 2026 | daily.dev description: The most upvoted PostgreSQL posts from January 2026, curated by the daily.dev community. canonical: https://daily.dev/tags/postgresql/best-of/2026/01 twitter:card: summary_large_image twitter:site: @dailydotdev og:url: https://daily.dev/tags/postgresql/best-of/2026/01 og:type: website og:site_name: daily.dev og:title: Best PostgreSQL posts — January 2026 | daily.dev og:description: The most upvoted PostgreSQL posts from January 2026, curated by the daily.dev community. og:image: https://media.daily.dev/image/upload/s--VAY5ToZt--/f_auto/v1724209435/public/daily.dev%20-%20open%20graph --- # Best of PostgreSQL — January 2026 1. 1 [](/posts/i-replaced-redis-with-postgresql-and-it-s-faster--x7d3o8vu2 "I Replaced Redis with PostgreSQL (And It's Faster)") Article Lobsters · 39w I Replaced Redis with PostgreSQL (And It's Faster) PostgreSQL can replace Redis for caching, pub/sub, job queues, and sessions using UNLOGGED tables, LISTEN/NOTIFY, SKIP LOCKED, and JSONB. While PostgreSQL is 50-158% slower per operation (0.1-1ms difference), it eliminates network hops between databases, reduces infrastructure costs by \~$100/month, simplifies operations, and guarantees transactional consistency. The approach works best for small-to-medium apps with simple caching needs but isn't suitable for high-throughput scenarios (100k+ ops/sec) or applications requiring Redis-specific data structures like sorted sets or HyperLogLog. 744 61 2. 2 [](/posts/introducing-postgres-best-practices-oieboe2rs "Introducing: Postgres Best Practices") Article Supabase · 38w Introducing: Postgres Best Practices Supabase released Agent Skills for Postgres Best Practices, a collection of 30 rules across 8 categories to help AI coding agents write correct, performant Postgres code. The rules follow the Agent Skills open standard and cover critical areas like query performance, connection management, Row Level Security, schema design, and concurrency. The repository addresses common mistakes seen across hundreds of thousands of Postgres projects, such as missing indexes, RLS bypasses, and connection pool exhaustion. These best practices complement the Supabase MCP server by teaching agents proper judgment while the MCP server handles database connections and execution. 493 8 3. 3 [](/posts/scaling-postgresql-to-power-800-million-chatgpt-users-3mbfuagbd "Scaling PostgreSQL to power 800 million ChatGPT users") Article OpenAI · 37w Scaling PostgreSQL to power 800 million ChatGPT users OpenAI scaled PostgreSQL to handle millions of queries per second for 800 million ChatGPT users using a single primary Azure PostgreSQL instance with nearly 50 read replicas across multiple regions. Key optimizations included offloading reads to replicas, migrating write-heavy workloads to sharded systems like CosmosDB, implementing PgBouncer for connection pooling, deploying cache locking to prevent cache-miss storms, isolating workloads to prevent noisy neighbor issues, and enforcing strict rate limiting. The architecture achieved five-nines availability with low double-digit millisecond p99 latency despite PostgreSQL's MVCC limitations for write-heavy workloads. 297 11 4. 4 [](/posts/open-source-mysql-repository-has-no-commits-in-more-than-three-months-devclass-hd9isuidj "Open source MySQL repository has no commits in more than three months • DEVCLASS") Article DEVCLASS · 39w Open source MySQL repository has no commits in more than three months • DEVCLASS MySQL's GitHub repository has seen no commits since September 2025, coinciding with reported Oracle layoffs in the MySQL team. Commit activity has declined yearly since 2019, reaching its lowest point in 2025 since the project began. Industry experts suggest Oracle is focusing on proprietary MySQL versions (Enterprise, Cluster, Heatwave) while neglecting the open source community edition. Despite concerns, MySQL remains the second most popular database among professional developers according to Stack Overflow surveys, though PostgreSQL now leads. Experts recommend migrating to alternatives like MariaDB or PostgreSQL, though migration can be challenging due to SQL dialect differences. 108 12 5. 5 [](/posts/stop-using-mysql-in-2026-it-is-not-true-open-source-wleltp3iy "Stop using MySQL in 2026, it is not true open source") Article Lobsters · 38w Stop using MySQL in 2026, it is not true open source MySQL's development has significantly declined under Oracle's stewardship, with commit activity dropping sharply in 2025 and staff reductions announced. Oracle conducts all development behind closed doors, rejecting community contributions and treating MySQL as open source only by license, not practice. Technical issues have plagued recent releases, including data corruption bugs, performance regressions of 15%, and difficult upgrade paths. Oracle published 123 CVEs in 2025 with minimal transparency compared to MariaDB's 8\. Migration to MariaDB is straightforward for most applications, offering true open source development with active community participation. Major platforms like Wikipedia and 57% of WordPress sites already use MariaDB. 95 8 6. 6 [](/posts/openeverest-open-source-platform-for-database-automation-hnifcvjen "OpenEverest: Open Source Platform for Database Automation") Article InfoQ · 36w OpenEverest: Open Source Platform for Database Automation Percona announced OpenEverest, an open-source platform for automated database provisioning and management on Kubernetes. Built on Kubernetes operators, it supports MySQL, PostgreSQL, and MongoDB, offering features like automated backups, scaling, and disaster recovery while avoiding vendor lock-in. The platform provides both a web UI and REST API for managing database clusters. Originally launched as Percona Everest, it's transitioning to independent open governance with plans to donate to the CNCF. The latest version adds PostgreSQL 18.1 support and NodePort networking, with future plans to support ClickHouse, Vitess, and observability integrations. 89 1 7. 7 [](/posts/full-stack-engineering-course-build-and-deploy-a-full-stack-pern-admin-dashboard-in-2026-s7kjrtte4 "Full Stack Engineering Course | Build and Deploy a Full Stack PERN Admin Dashboard in 2026") Article Reinier · 39w Full Stack Engineering Course | Build and Deploy a Full Stack PERN Admin Dashboard in 2026 This comprehensive PERN stack course teaches you to build a production-ready University Management Dashboard from scratch. The tutorial covers PostgreSQL, Express, React, and Node fundamentals, then guides you through implementing multi-role authentication, secure join codes, and Cloudinary media uploads. The course also explores using AI agents for rapid development by attempting to rebuild the entire Google Classroom-style project and comparing human versus automated approaches. 86 4 8. 8 [](/posts/replacing-protobuf-with-rust-to-go-5-times-faster-mya0hcqzb "Replacing Protobuf with Rust to go 5 times faster") Article Hacker News · 37w Replacing Protobuf with Rust to go 5 times faster PgDog replaced Protobuf serialization with direct C-to-Rust bindings in their PostgreSQL proxy, achieving 5x faster query parsing and 10x faster deparsing. The team forked pg\_query.rs and used bindgen with AI-assisted code generation to create 6,000 lines of recursive conversion code that maps C structs directly to Rust. Profiling revealed Protobuf deserialization as the bottleneck, not the Postgres parser itself. The new implementation uses unsafe Rust with recursive algorithms for better CPU cache locality and zero additional memory allocation, resulting in 25% overall performance improvement in pgbench benchmarks. 74 1 9. 9 [](/posts/portabase-a-lightweight-self-hosted-database-backup-solution-5hnbhzxb9 "Portabase: A Lightweight Self-Hosted Database Backup Solution") Article Noted · 38w Portabase: A Lightweight Self-Hosted Database Backup Solution Portabase is a self-hosted database backup and restore tool supporting PostgreSQL, MySQL, and MariaDB. It uses a central server for management and lightweight agents that operate in outbound pull mode, eliminating the need to expose databases to the internet. The platform features three retention strategies (fixed count, time-based, GFS rotation), supports S3-compatible storage backends, and integrates with notification platforms like Slack and Discord. The central server is built with Next.js 16 and PostgreSQL, while agents have been refactored from Python to Rust for better performance and a 4x smaller Docker image. 64 2 10. 10 [](/posts/dev-picks-the-wrong-database-takes-down-company-vsxqsfg2u "Dev Picks the Wrong Database, Takes Down Company") Video Kevin Fang · 40w Dev Picks the Wrong Database, Takes Down Company Element Creations experienced a 24-hour outage of the matrix.org home server after an engineer accidentally deleted the production database while attempting to restore a failed server. The incident began with a hardware failure requiring database migration, but confusion over which server was primary led to running a destructive command on the wrong machine. Recovery took over a day due to slow backup restoration (51TB), a bug in their backup tool that wasn't patched in production, and slow write-ahead log replay. The postmortem emphasizes faster backup restoration strategies, including local snapshots using copy-on-write filesystems like ZFS, and highlights how operational errors during high-pressure situations are nearly inevitable. 59 5 11. 11 [](/posts/the-neon-vs-code-extension-just-got-a-big-update-ycbbnwcdp "The Neon VS Code Extension Just Got a Big Update") Article Neon · 37w The Neon VS Code Extension Just Got a Big Update Neon's VS Code extension has been rebuilt to provide native database management directly in the editor. The update removes the Docker-based local proxy, automatically detects Neon connection strings in projects, and enables developers to browse schemas, manage tables, run queries, and switch between Neon branches without leaving VS Code. The extension now includes built-in MCP server support and offers a streamlined authentication flow with automatic project detection. 58 1 12. 12 [](/posts/fast-scalable-enterprise-grade-postgres-natively-integrated-with-clickhouse-whtgalabx "Fast, scalable, enterprise-grade Postgres natively integrated with ClickHouse") Article ClickHouse · 37w Fast, scalable, enterprise-grade Postgres natively integrated with ClickHouse ClickHouse announces a managed Postgres service backed by NVMe storage, delivering up to 10X faster performance for disk-bound workloads. The service integrates natively with ClickHouse through CDC capabilities and the pg\_clickhouse extension, enabling a unified data stack that combines transactional (Postgres) and analytical (ClickHouse) workloads. Built in partnership with Ubicloud, it offers enterprise-grade features including high availability, automatic backups, and point-in-time recovery, with all integration components being open source. 56 1 13. 13 [](/posts/postgresql-18-returning-enhancements-a-game-changer-for-modern-applications-xrqrjxjua "PostgreSQL 18 RETURNING Enhancements: A Game Changer for Modern Applications") Article Lobsters · 40w PostgreSQL 18 RETURNING Enhancements: A Game Changer for Modern Applications PostgreSQL 18 introduces enhanced RETURNING clause capabilities with OLD and NEW aliases, allowing developers to capture both before and after states of data in INSERT, UPDATE, DELETE, and MERGE operations within a single atomic statement. This eliminates the need for separate SELECT queries, complex triggers, or application-level change tracking. The feature is particularly powerful for MERGE operations, enabling sophisticated upsert patterns with complete visibility into what changed. Practical examples demonstrate building audit trails, tracking inventory changes, and comparing values without additional database round trips or trigger overhead. 51 1 14. 14 [](/posts/building-tanstack-com-with-neon-and-tanstack-duh--tksag8mp6 "Building TanStack.com with Neon and TanStack (duh)") Article Neon · 38w Building TanStack.com with Neon and TanStack (duh) TanStack.com runs on its own stack: TanStack Start as the full-stack framework, TanStack Query for data fetching, and Neon with Drizzle for Postgres persistence. The setup powers documentation and community features serving millions of visitors. Neon integrates seamlessly through the TanStack Start CLI, offering instant database provisioning with a claim-later workflow, automatic compute autoscaling, and branching for development. The architecture uses a serverless runtime with React frontend and Postgres backend, requiring minimal configuration. 50 15. 15 [](/posts/introducing-pgpm-a-package-manager-for-modular-postgresql-2ssbhy4zq "Introducing pgpm: A Package Manager for Modular PostgreSQL") Article PostgreSQL · 40w Introducing pgpm: A Package Manager for Modular PostgreSQL pgpm is a new package manager for PostgreSQL that enables developers to share and reuse application-level database logic (schemas, tables, functions, policies, triggers) as modular, versioned packages. Unlike traditional PostgreSQL extensions that operate at the system level, pgpm works at the application layer using pure SQL, requiring no superuser access or compilation. It organizes code into workspaces with explicit dependency management, automatic resolution, and deterministic deployment order. The tool supports test-driven development with ephemeral databases and CI/CD integration, drawing inspiration from Sqitch while adding recursive composition and modular packaging capabilities. 49 1 16. 16 [](/posts/debug-postgresql-query-latency-faster-with-explain-analyze-in-datadog-database-monitoring-kwcnveyee "Debug PostgreSQL query latency faster with EXPLAIN ANALYZE in Datadog Database Monitoring") Article Datadog · 36w Debug PostgreSQL query latency faster with EXPLAIN ANALYZE in Datadog Database Monitoring Datadog Database Monitoring now automatically collects PostgreSQL EXPLAIN ANALYZE execution plans to help troubleshoot slow queries. The feature processes plans captured by PostgreSQL's auto\_explain extension, correlates them with APM traces, and provides interactive visualizations. Key use cases include identifying incorrect row estimates that cause inefficient join strategies, and analyzing cache hits versus disk reads to determine whether performance issues stem from I/O bottlenecks or query optimization needs. 40 17. 17 [](/posts/waiting-for-postgresql-19-implement-alter-table-merge-gaf8od7xq "Waiting for PostgreSQL 19 – Implement ALTER TABLE … MERGE") Article depesz · 40w Waiting for PostgreSQL 19 – Implement ALTER TABLE … MERGE PostgreSQL 19 introduces ALTER TABLE commands for merging and splitting partitions. The new MERGE PARTITIONS command combines multiple partitions into one, while SPLIT PARTITION divides a single partition into several. Both operations currently hold ACCESS EXCLUSIVE locks during execution, making them unsuitable for large tables under high load, but they provide a foundation for future optimizations with reduced locking and potential parallelism. These features were previously attempted in PostgreSQL 17 but were rolled back due to issues. 39 1 18. 18 [](/posts/postgresql-pgmoneta-0-20-gzhkq1one "PostgreSQL: pgmoneta 0.20") Article PostgreSQL · 38w PostgreSQL: pgmoneta 0.20 pgmoneta 0.20.0 has been released with several improvements including redesigned locking for backup repositories, enhanced S3 support, and Grafana 12 compatibility. New features include a configuration file for pgmoneta-cli, interactive mode for pgmoneta-walinfo, WAL stream filtering support via pgmoneta-walfilter, and an initial Model Context Protocol server. pgmoneta is an open-source backup and restore solution for PostgreSQL 14+ that supports full and incremental backups, multiple compression formats, encryption, WAL shipping, and remote management. 35 19. 19 [](/posts/supabase-privatelink-is-now-available-bgvnt4bf8 "Supabase PrivateLink is now available") Article Supabase · 37w Supabase PrivateLink is now available Supabase PrivateLink enables database connections through AWS private networks without public internet exposure. Using AWS VPC Lattice, it allows applications to connect to Supabase databases as if they're inside your own VPC. This addresses compliance requirements for regulated industries and reduces attack surface by eliminating public endpoints. Currently in Beta, it supports AWS VPCs in the same region, covers Postgres and PgBouncer connections (but not other Supabase services), and requires Team or Enterprise plans. Setup involves sharing AWS account details, accepting resource shares, creating VPC endpoints, and updating connection strings. 27 1 20. 20 [](/posts/your-rag-system-has-a-hidden-ux-problem-oytm7rbu2 "Your RAG System Has a Hidden UX Problem") Article Daily Dose of Data Science | Avi Chawla | Substack · 37w Your RAG System Has a Hidden UX Problem RAG systems often use semantic retrieval but fall back to keyword-based highlighting, creating a UX disconnect where users can't see why documents are relevant. Zilliz released an open-source semantic highlighting model that identifies semantically relevant text spans instead of just keyword matches. The bilingual model (English/Chinese) handles 8K context windows, runs fast enough for production use, and outperforms existing solutions on both in-domain and out-of-domain benchmarks. It's being integrated into Milvus as a native API and is available on Hugging Face under MIT license. 26 21. 21 [](/posts/pgmetrics-1-19-released-5gimzm76n "pgmetrics 1.19 released") Article PostgreSQL · 38w pgmetrics 1.19 released pgmetrics version 1.19 has been released. This open-source tool collects 350+ metrics from PostgreSQL servers and displays them in text format or exports as JSON/CSV. It supports managed PostgreSQL services (AWS, Azure, GCP) and works with Citus, PgBouncer, and Pgpool. The tool is zero-dependency and comes as a single binary. 22 [See all PostgreSQL archives](/tags/postgresql/best-of) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@graph":[{"@type":"CollectionPage","@id":"https://daily.dev/tags/postgresql/best-of/2026/01#page","url":"https://daily.dev/tags/postgresql/best-of/2026/01","name":"Best PostgreSQL Posts — January 2026","description":"The most upvoted PostgreSQL posts from January 2026, curated by the daily.dev community.","isPartOf":{"@type":"WebSite","url":"https://daily.dev"}},{"@type":"ItemList","@id":"https://daily.dev/tags/postgresql/best-of/2026/01#items","numberOfItems":21,"itemListElement":[{"@type":"ListItem","position":1,"url":"https://daily.dev/posts/i-replaced-redis-with-postgresql-and-it-s-faster--x7d3o8vu2","name":"I Replaced Redis with PostgreSQL (And It's Faster)"},{"@type":"ListItem","position":2,"url":"https://daily.dev/posts/introducing-postgres-best-practices-oieboe2rs","name":"Introducing: Postgres Best Practices"},{"@type":"ListItem","position":3,"url":"https://daily.dev/posts/scaling-postgresql-to-power-800-million-chatgpt-users-3mbfuagbd","name":"Scaling PostgreSQL to power 800 million ChatGPT users"},{"@type":"ListItem","position":4,"url":"https://daily.dev/posts/open-source-mysql-repository-has-no-commits-in-more-than-three-months-devclass-hd9isuidj","name":"Open source MySQL repository has no commits in more than three months • DEVCLASS"},{"@type":"ListItem","position":5,"url":"https://daily.dev/posts/stop-using-mysql-in-2026-it-is-not-true-open-source-wleltp3iy","name":"Stop using MySQL in 2026, it is not true open source"},{"@type":"ListItem","position":6,"url":"https://daily.dev/posts/openeverest-open-source-platform-for-database-automation-hnifcvjen","name":"OpenEverest: Open Source Platform for Database Automation"},{"@type":"ListItem","position":7,"url":"https://daily.dev/posts/full-stack-engineering-course-build-and-deploy-a-full-stack-pern-admin-dashboard-in-2026-s7kjrtte4","name":"Full Stack Engineering Course | Build and Deploy a Full Stack PERN Admin Dashboard in 2026"},{"@type":"ListItem","position":8,"url":"https://daily.dev/posts/replacing-protobuf-with-rust-to-go-5-times-faster-mya0hcqzb","name":"Replacing Protobuf with Rust to go 5 times faster"},{"@type":"ListItem","position":9,"url":"https://daily.dev/posts/portabase-a-lightweight-self-hosted-database-backup-solution-5hnbhzxb9","name":"Portabase: A Lightweight Self-Hosted Database Backup Solution"},{"@type":"ListItem","position":10,"url":"https://daily.dev/posts/dev-picks-the-wrong-database-takes-down-company-vsxqsfg2u","name":"Dev Picks the Wrong Database, Takes Down Company"},{"@type":"ListItem","position":11,"url":"https://daily.dev/posts/the-neon-vs-code-extension-just-got-a-big-update-ycbbnwcdp","name":"The Neon VS Code Extension Just Got a Big Update"},{"@type":"ListItem","position":12,"url":"https://daily.dev/posts/fast-scalable-enterprise-grade-postgres-natively-integrated-with-clickhouse-whtgalabx","name":"Fast, scalable, enterprise-grade Postgres natively integrated with ClickHouse"},{"@type":"ListItem","position":13,"url":"https://daily.dev/posts/postgresql-18-returning-enhancements-a-game-changer-for-modern-applications-xrqrjxjua","name":"PostgreSQL 18 RETURNING Enhancements: A Game Changer for Modern Applications"},{"@type":"ListItem","position":14,"url":"https://daily.dev/posts/building-tanstack-com-with-neon-and-tanstack-duh--tksag8mp6","name":"Building TanStack.com with Neon and TanStack (duh)"},{"@type":"ListItem","position":15,"url":"https://daily.dev/posts/introducing-pgpm-a-package-manager-for-modular-postgresql-2ssbhy4zq","name":"Introducing pgpm: A Package Manager for Modular PostgreSQL"},{"@type":"ListItem","position":16,"url":"https://daily.dev/posts/debug-postgresql-query-latency-faster-with-explain-analyze-in-datadog-database-monitoring-kwcnveyee","name":"Debug PostgreSQL query latency faster with EXPLAIN ANALYZE in Datadog Database Monitoring"},{"@type":"ListItem","position":17,"url":"https://daily.dev/posts/waiting-for-postgresql-19-implement-alter-table-merge-gaf8od7xq","name":"Waiting for PostgreSQL 19 – Implement ALTER TABLE … MERGE"},{"@type":"ListItem","position":18,"url":"https://daily.dev/posts/postgresql-pgmoneta-0-20-gzhkq1one","name":"PostgreSQL: pgmoneta 0.20"},{"@type":"ListItem","position":19,"url":"https://daily.dev/posts/supabase-privatelink-is-now-available-bgvnt4bf8","name":"Supabase PrivateLink is now available"},{"@type":"ListItem","position":20,"url":"https://daily.dev/posts/your-rag-system-has-a-hidden-ux-problem-oytm7rbu2","name":"Your RAG System Has a Hidden UX Problem"},{"@type":"ListItem","position":21,"url":"https://daily.dev/posts/pgmetrics-1-19-released-5gimzm76n","name":"pgmetrics 1.19 released"}]},{"@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Tags","item":"https://daily.dev/tags"},{"@type":"ListItem","position":3,"name":"PostgreSQL","item":"https://daily.dev/tags/postgresql"},{"@type":"ListItem","position":4,"name":"Best of","item":"https://daily.dev/tags/postgresql/best-of"},{"@type":"ListItem","position":5,"name":"January 2026"}]}]} ```