Best of PostgreSQL — October 2025

1. 1
   Article

   CrateDB·33w

   New Release: CrateDB 6.0

   CrateDB 6.0 upgrades to Lucene 10.2, delivering faster query performance through optimized COUNT operations, mixed joins, and improved NUMERIC type handling. The release strengthens PostgreSQL compatibility with aligned scalar functions and metadata improvements, while introducing new monitoring tools like cluster_health and expanded segments table. Dynamic column policy now supports nested arrays for easier JSON and IoT data ingestion. The Lucene upgrade requires reindexing from older versions but establishes groundwork for future AI features including vector search and k-means clustering.

   64
2. 2
   Article

   Suraj Shetty·29w

   Every Developer Should Know What Their DBA Knows

   A comprehensive roadmap covering essential PostgreSQL database administration knowledge that developers should understand. Topics include database fundamentals, PostgreSQL architecture, query optimization, indexing strategies, replication, backup and recovery, security, monitoring, and performance tuning. The guide bridges the gap between development and database administration, helping developers write better queries and understand database behavior.

   59

   9
3. 3
   Video

   Dreams of Code·32w

   Why I decided to migrate away from Stripe

   A developer shares their experience migrating from Stripe to Polar.sh, a merchant of record payment provider. The primary motivation was eliminating the burden of sales tax compliance, registration, and remittance across multiple jurisdictions. While Stripe excels at payment processing, it doesn't handle tax remittance, requiring manual quarterly filings that became increasingly time-consuming. Polar.sh offers a 4% fee (vs Stripe's 2.9%) but assumes legal responsibility for sales, handling all tax compliance automatically. The migration involved database schema changes, adapting to differences in product/price models and customer references, and implementing the Polar SDK alongside existing Stripe infrastructure. The author found the tradeoff worthwhile for reclaiming time previously spent on tax paperwork.

   58

   7
4. 4
   Article

   Neon·33w

   A PostgREST-Compatible Data API, Now on Neon

   Neon launched a PostgREST-compatible Data API that allows querying Postgres databases directly over HTTPS. Built as a Rust re-implementation of PostgREST integrated into Neon's proxy fleet, it offers improved resource efficiency, multi-tenant architecture, and automatic scaling across thousands of databases. The API provides dedicated endpoints for each database branch, supports scale-to-zero compute while maintaining constant availability, and integrates with Neon Auth or external JWT providers. Designed particularly for AI agent platforms, it eliminates the need for Postgres client libraries by using standard HTTP requests with JWT authentication and Row-Level Security.

   49

   1
5. 5
   Article

   Hashrocket·29w

   PostgreSQL 18's UUIDv7: Faster and Secure Time-Ordered IDs

   PostgreSQL 18 introduces native support for UUIDv7, a new identifier format that combines the security benefits of random UUIDs with time-based ordering. Unlike UUIDv4's completely random values, UUIDv7 embeds timestamps in the first portion, enabling chronological sorting without separate created_at columns and improving index performance by reducing fragmentation. The format maintains collision resistance and security against enumeration attacks while delivering better database performance through sequential-like insertion patterns.

   42
6. 6
   Video

   The Coding Gopher·31w

   99% of Developers Don't Get PostgreSQL

   Deep dive into PostgreSQL's internal architecture, covering its ACID implementation, object-relational model, and storage mechanisms. Explains multi-version concurrency control (MVCC) for handling concurrent transactions without blocking, the TOAST system for managing oversized data, and write-ahead logging (WAL) for durability and crash recovery. Includes details on heap files, page organization, tuple versioning, vacuum processes, and checkpoint mechanisms that ensure data consistency and performance at scale.

   38
7. 7
   Article

   Deno·30w

   My highlights from the new Deno Deploy

   Deno Deploy has been rebuilt from scratch with major improvements including integrated CI/CD, simplified database management with KV and Postgres support, built-in metrics and OpenTelemetry observability, enhanced CLI tooling, local-to-production tunneling, cloud service integrations for AWS and GCP, and improved playgrounds. The platform now offers automatic framework detection, environment-specific database provisioning, and centralized configuration management while maintaining both static and dynamic hosting capabilities.

   34

   1
8. 8
   Article

   Debezium·33w

   Debezium 3.3.0.Final Released

   Debezium 3.3.0.Final introduces major enhancements including a new Quarkus extension for PostgreSQL integration, a CockroachDB connector, Apache Kafka 4.1 support, and exactly-once semantics for all core connectors. The release includes OpenLineage support for MongoDB and JDBC sink connectors, improved performance optimizations across Oracle, PostgreSQL, and MySQL connectors, and enhanced Debezium Platform features like smart editor and connection management. Breaking changes include removal of deprecated snapshot modes and updates to JDBC sink data type precision handling.

   33
9. 9
   Article

   Hacker News·30w

   How Idealist.org Replaced a $3,000/mo Heroku Bill with a $55/mo Server

   Idealist.org reduced their staging environment costs from $3,000/month on Heroku to $55/month by migrating to a single Hetzner server running 6 environments. Using Disco for deployment automation, they maintained the git-push workflow and developer experience while sharing a single Postgres instance across environments. The migration required handling DNS/CDN configuration and accepting responsibility for server maintenance, but transformed staging environments from a scarce, expensive resource into an abundant commodity that developers could spin up freely.

   30

   1
10. 10
    Article

    CYBERTEC PostgreSQL·31w

    The PostgreSQL Village

    The PostgreSQL community operates like a village where diverse contributors—developers, DBAs, marketers, organizers, and more—work together toward a common goal. Contributions extend beyond code to include documentation, event organization, content creation, and community building. Getting involved can start simply by attending conferences, joining social channels like PostgreSQL Social on Telegram, or sharing contributions with postgres-contrib.org. The strength of PostgreSQL lies not just in its technology but in the collaborative spirit of its people working together for long-term success.

    28
11. 11
    Video

    YouTube·33w

    Build and Deploy Full Stack AI Multi-Vendor E-Commerce App using Next js | PERN Stack Project 2025

    A comprehensive guide to building a multi-vendor e-commerce platform with Next.js, featuring three user roles (admin, seller, customer), premium subscriptions, payment integration via Stripe, and AI-powered product descriptions using Google Gemini. The tutorial covers authentication with Clerk, database management with Neon PostgreSQL and Prisma ORM, background job handling with Inngest, image storage with ImageKit, and deployment on Vercel. Includes complete implementation of product management, order processing, coupon systems, and seller dashboards.

    16
12. 12
    Article

    Hacker News·29w

    $5 PlanetScale — PlanetScale

    PlanetScale announces a new $5/month single-node tier for their Postgres database service, making it more accessible for developers on day one. The PS-5 node type offers a non-HA configuration suitable for development, testing, and non-critical workloads, while maintaining the ability to vertically scale. This complements their existing $30/month three-node HA setup, allowing teams to start small and scale to production without platform migrations.

    12
13. 13
    Article

    Hacker News·31w

    pglinter

    PG Linter is a PostgreSQL extension written in Rust that analyzes databases for performance issues, schema problems, and security risks. It provides a rule-based approach with four categories: base rules for database-wide checks, cluster rules for configuration, table rules for individual table analysis, and schema rules for privilege validation. The extension outputs results in SARIF format for CI/CD integration and allows developers to enable or disable specific rules based on their needs. It's designed for teams without dedicated DBAs to catch database design issues early in development.

    12