Best of PostgreSQL — November 2025

  1. 1
    Article
    Avatar of vladmihalceaVlad Mihalcea·25w

    Just Use Postgres!

    A comprehensive review of Denis Magda's book covering PostgreSQL's capabilities beyond traditional relational features. The 402-page guide explores core database concepts like indexing (B+Tree, hash, partial), transactions, and modern SQL features (CTEs, window functions), then dives into non-relational capabilities including JSON storage and full-text search. The book examines PostgreSQL's extension ecosystem: pgvector for ML/GenAI embeddings, TimescaleDB for time series data, PostGIS for geospatial queries, and pgmq for message queues. Includes performance tuning guidance and discusses when PostgreSQL might not be the right choice.

  2. 2
    Video
    Avatar of kikisbytesKiki's Bytes·27w

    How Figma Scaled To 10 Million Users

    Figma scaled from a single PostgreSQL database to a horizontally sharded architecture supporting 10 million users. The journey involved three phases: immediate relief through vertical scaling, read replicas, and connection pooling; medium-term stability via logical partitioning of table groups into dedicated databases; and long-term scalability through horizontal sharding with a custom query router. Key innovations included optimized logical replication by removing indexes during migration, two-phase deployment using PG Bouncer for safe routing changes, logical sharding with PostgreSQL views for testing before physical splits, and a custom Golang DB proxy for intelligent query routing across shards.

  3. 3
    Article
    Avatar of neontechNeon·25w

    Why So Many Projects in the Neon Free Plan?

    Neon has increased its Free Plan from 10 to 60 projects due to infrastructure efficiency gains and integration with Databricks. The expansion is enabled by Neon's architecture that separates compute and storage, scales to zero when idle, and uses object storage as the source of truth. Rather than maximizing profit margins, Neon aims to make its Free Plan genuinely useful for developers building side projects, prototypes, and small apps, positioning itself as the default Postgres provider.

  4. 4
    Video
    Avatar of dreamsofcodeDreams of Code·24w

    How my tech stack has changed through 2025

    A developer reflects on their tech stack evolution throughout 2025, driven largely by AI coding tools like Claude. Key changes include adopting TypeScript for frontend development with Next.js and React, switching from Clerk to Better Auth for authentication, implementing Drizzle ORM with Postgres, migrating from Mailgun to Resend for transactional emails, and moving to Dokploy for deployment with preview environments. The stack now centers on Go for backend services, TypeScript/Next.js for frontend, Better Auth for authentication, and various integrations including Neon for Postgres hosting and Polar.sh for payment processing.

  5. 5
    Article
    Avatar of postgresPostgreSQL·25w

    pg_ai_query — AI-powered SQL generation & query analysis for PostgreSQL

    pg_ai_query is a new PostgreSQL extension that enables AI-powered SQL query generation and analysis directly within Postgres. Developers can generate SQL queries from natural language descriptions and get AI-assisted explanations of query execution plans. The extension supports PostgreSQL 14+ and aims to streamline query development by eliminating the need to switch between tools.

  6. 6
    Video
    Avatar of youtubeYouTube·25w

    Building a Production API in Golang from Scratch (Ecommerce project)

    A comprehensive walkthrough of building a production-ready e-commerce API in Go from scratch. Covers HTTP server setup with Chi router, clean layered architecture (handlers, services, repositories), dependency injection, structured logging with slog, middleware implementation, database schema design for products and orders, RESTful endpoint design, and error handling patterns. Demonstrates practical patterns like graceful configuration management, request ID tracking, and JSON response handling.

  7. 7
    Article
    Avatar of simplethreadSimple Thread·26w

    I Love You, Redis, But I’m Leaving You for SolidQueue

    Rails 8 introduces SolidQueue, SolidCache, and SolidCable as PostgreSQL-based replacements for Redis in the default stack. SolidQueue leverages PostgreSQL's FOR UPDATE SKIP LOCKED feature to handle job queuing without lock contention, eliminating the operational complexity of maintaining Redis infrastructure. The article provides a complete migration guide from Sidekiq to SolidQueue, including setup instructions, recurring job configuration, and Mission Control monitoring. While Redis remains necessary for high-throughput applications processing thousands of jobs per second, SolidQueue handles 200-300 jobs/second and is sufficient for most Rails applications, as demonstrated by 37signals processing 20 million jobs daily on PostgreSQL.

  8. 8
    Article
    Avatar of neontechNeon·28w

    Major compute price reduction on Neon

    Neon announces up to 25% compute price reductions across all paid plans, with Launch Plan dropping to $0.106 per CU-hour and Scale Plan to $0.222 per CU-hour. This follows previous cost cuts including storage reduction from $1.75 to $0.35 per GB-month and removal of the $599/month enterprise feature surcharge. Running on Databricks' infrastructure enables these lower prices while maintaining autoscaling capabilities that scale compute to zero when idle. Real-world comparisons show Neon costs 30-60% less than alternatives like Aurora Serverless v2 and Supabase across different usage scenarios.

  9. 9
    Article
    Avatar of postgresPostgreSQL·25w

    Autobase 2.5.0 released

    Autobase 2.5.0 introduces Expert Mode to its UI, enabling advanced cluster configuration options for experienced users. Key features include a YAML editor for custom parameters, updated cloud provider pricing and instance specifications (Hetzner ARM instances, 4th-gen Intel on AWS/GCP), configurable IOPS and throughput for AWS EBS volumes, and Ansible 12 compatibility. Autobase is an open-source tool for deploying and managing highly available PostgreSQL clusters, automating tasks like deployment, failover, backups, and scaling without requiring deep DBA expertise.

  10. 10
    Article
    Avatar of hashrocketHashrocket·28w

    PostgreSQL 18 - Temporal Constraints

    PostgreSQL 18 introduces temporal constraints with the WITHOUT OVERLAPS syntax, enabling enforcement of uniqueness across time periods using date or timestamp ranges. This feature prevents overlapping data in scenarios like subscription management, where users can have multiple historical records but only one active entry at a time. The implementation uses range types (daterange or timestamprange) with GIST indexes and requires the btree_gist extension for UUID compatibility.

  11. 11
    Article
    Avatar of programmingdigestProgramming Digest·25w

    Bloom filters: the niche trick behind a 16× faster API

    A detailed technical walkthrough of optimizing an API endpoint from 5s to 0.3s P95 latency using bloom filters. The post explains how bloom filters work as probabilistic data structures, compares them against GIN indexes for filtering JSONB data in Postgres, and demonstrates how combining bloom filters with time-based partitioning achieved a 16× performance improvement. Includes practical implementation details, query plans, and the engineering trade-offs considered when choosing between different optimization approaches.

  12. 12
    Article
    Avatar of muratbuffaloMetadata·27w

    Disaggregated Database Management Systems

    Explores how cloud trends are reshaping database architecture through disaggregation—separating compute, storage, and memory into independently scalable components. Examines three case studies: Google AlloyDB (PostgreSQL with compute-storage separation and HTAP support), Rockset (real-time analytics using the Aggregator-Leaf-Tailer pattern), and Nova-LSM (LSM-based storage with immutable SSTs in object stores). Discusses emerging hardware disaggregation including RDMA-based memory systems, CXL coherent memory fabrics, and DPU-based approaches. Highlights open challenges around automatic workload-driven assembly, co-design across fabrics, correctness verification, and adaptive reconfiguration.

  13. 13
    Article
    Avatar of theverdictThe Verdict·28w

    Pretty cool find - Conar, an AI that writes and optimizes SQL for you

    Conar is an open-source AI tool that converts natural language queries into optimized SQL statements. It currently supports PostgreSQL with MySQL and MongoDB support planned. The tool features end-to-end encryption for credentials and queries, and allows users to select their preferred AI model. It aims to reduce the time developers spend writing repetitive SQL queries.

  14. 14
    Article
    Avatar of postgresPostgreSQL·27w

    PostgreSQL 18.1, 17.7, 16.11, 15.15, 14.20, and 13.23 Released!

    PostgreSQL has released security updates across all supported versions (18.1, 17.7, 16.11, 15.15, 14.20, and 13.23), addressing two security vulnerabilities and over 50 bugs. The first vulnerability allows unauthorized denial of service through CREATE STATISTICS commands, while the second involves integer wraparound in libpq that can cause memory corruption. PostgreSQL 13 reaches end-of-life with this final release, and users should plan upgrades to supported versions.

  15. 15
    Article
    Avatar of selfhstselfh.st·27w

    Self-Host Weekly #145: Agentic

    A weekly newsletter covering self-hosting news and tools. Highlights include commentary on recent cloud service outages, Microsoft's announcement of Windows becoming an 'agentic OS', and research on why people choose to self-host. Features Postgresus, an automated PostgreSQL backup platform with web interface, scheduling, multiple storage destinations, and Docker deployment support.

  16. 16
    Article
    Avatar of hashrocketHashrocket·28w

    PostgreSQL 18 - VIRTUAL Generated Columns

    PostgreSQL 18 introduces VIRTUAL generated columns as the new default, computing values on-the-fly at query time instead of storing them on disk. Unlike STORED columns that existed since version 12, VIRTUAL columns save disk space but cannot be indexed. The choice between VIRTUAL and STORED depends on computation complexity, query patterns, and whether storage efficiency or query performance is prioritized. Simple concatenations work well as VIRTUAL, while complex computations or frequently filtered columns benefit from STORED with indexes.

  17. 17
    Article
    Avatar of programmingdigestProgramming Digest·24w

    PlanetScale — PlanetScale

    PlanetScale offers managed cloud databases for Postgres and MySQL/Vitess with NVMe-backed storage for high IOPS performance. The service provides automatic failover across three availability zones, database branching for development workflows, and zero-downtime migrations. Pricing starts at $5 for single-node Postgres and $40 for HA clusters. The platform includes built-in monitoring, automated backups, point-in-time recovery, and deployment options including bring-your-own-cloud. Used by companies like Cursor, Intercom, Cash App, and Dub for handling millions of queries per second on terabytes of data.

See all PostgreSQL archives