Best of PostgreSQL — July 2025

1. 1
   Article

   strongdm·46w

   PostgreSQL vs. MySQL: Differences for Tech Leaders & Teams

   PostgreSQL excels at complex, write-heavy workloads with advanced SQL features, rich data types like JSONB, and strict ACID compliance, making it ideal for financial systems and analytics. MySQL prioritizes speed and simplicity for read-heavy applications, offering lightweight architecture perfect for web apps, CMSs, and MVPs. PostgreSQL provides superior extensibility, query optimization, and enterprise features, while MySQL delivers faster performance for simple queries and lower resource consumption. The choice depends on workload complexity, data consistency requirements, and scalability needs.

   260

   11
2. 2
   Article

   TestDriven.io·44w

   Developing a Real-time Dashboard with FastAPI, Postgres, and WebSockets

   A comprehensive tutorial demonstrating how to build a real-time inventory tracking dashboard using FastAPI, PostgreSQL, and WebSockets. The guide covers setting up database triggers with LISTEN/NOTIFY for automatic change detection, implementing WebSocket connections for live data streaming, creating RESTful API endpoints for inventory management, and building a responsive frontend that updates instantly when data changes occur.

   130
3. 3
   Article

   Hacker News·42w

   Making Postgres 42,000x slower because I am unemployed

   A developer systematically degrades PostgreSQL performance by 42,000x through configuration changes alone, exploring how various postgresql.conf parameters affect database speed. The experiment reduces buffer cache size, forces excessive autovacuum operations, maximizes WAL overhead, disables index usage through cost manipulation, and bottlenecks I/O to a single thread. Starting from 7,082 TPS with default settings, the final configuration achieves less than 0.1 TPS with only 11 successful transactions in 120 seconds across 100 connections.

   108

   9
4. 4
   Article

   Supabase·44w

   Supabase UI: Platform Kit

   Supabase has launched Platform Kit, a new set of UI components designed for building platforms on top of Supabase infrastructure. The kit includes database, storage, authentication, and AI components that help developers create platforms providing Postgres databases to end users. Built with shadcn/ui compatibility and Tailwind CSS, these components are fully customizable and target the growing trend of companies using Supabase as Platform-as-a-Service infrastructure, particularly AI builders who now represent 30% of Supabase signups.

   97

   1
5. 5
   Article

   Neon·43w

   Neon Now Runs in VS Code

   Neon Local Connect is a new VS Code extension that allows developers to connect to Neon database branches using a static localhost connection string. The extension eliminates the need for local PostgreSQL setup by using a Docker-based proxy to route traffic from localhost to cloud-hosted Neon branches. Key features include creating branches on-the-fly, querying databases directly from VS Code, launching ephemeral test environments, and resetting branches to clean states. This solution addresses common local development challenges like schema drift, environment synchronization, and manual database management while providing the isolation and agility of Neon's branching system.

   91

   3
6. 6
   Article

   Anton Zhiyanov·44w

   Redka: Redis re-implemented with SQL

   Redka is a Redis-compatible server and Go module that reimplements Redis functionality using SQL databases (SQLite or PostgreSQL) as the backend. It supports five core Redis data types (strings, lists, sets, sorted sets, hashes) and offers both standalone server and embedded library usage. While not matching Redis performance, Redka handles tens of thousands of operations per second and provides benefits like SQL introspection, embedded caching for Go apps, and simplified testing environments.

   90

   4
7. 7
   Article

   Laravel·43w

   From 0 to 150K Visitors in 4 Hours: Scaling a Real-Time Engagement Platform

   Redberry successfully built and scaled a real-time engagement platform for Bank of Georgia in just three weeks using Laravel Cloud. The platform handled 150,000 visitors and 63,622 form submissions in four hours during Georgia's Independence Day, allowing emigrants to light up pixels on a digital flag displayed on a giant LED screen in Tbilisi. The technical stack included Laravel Cloud for elastic scaling, PostgreSQL for data persistence, Pusher for real-time broadcasting, React with Inertia.js for the frontend, and custom Canvas animations. The project demonstrates how modern Laravel tooling enables rapid development and deployment of high-traffic applications under tight deadlines.

   78
8. 8
   Article

   Programming Digest·42w

   PostgreSQL at Scale: Database Schema Changes Without Downtime

   Braintree Payments shares their refined approach to performing PostgreSQL schema changes without downtime in production environments. The post covers essential techniques including transactional DDL management, lock acquisition strategies, and safe operations for tables, columns, indexes, and constraints. Key strategies include using concurrent operations, breaking complex changes into smaller steps, and implementing forward/backward compatibility requirements. The team also open-sourced pg_ha_migrations, a Ruby gem that enforces DDL safety in Rails applications.

   51
9. 9
   Article

   The New Stack·44w

   Kubernetes Finally Solves Its Biggest Problem: Managing Databases

   Kubernetes operators have finally solved the challenge of managing stateful workloads like databases by extending the reconciliation loop pattern to stateful resources. The article demonstrates how CloudNativePG and Atlas operators enable declarative PostgreSQL cluster management and schema migrations on Kubernetes, eliminating the need for manual scripts and bringing database operations into GitOps workflows. This approach transforms database management from imperative, error-prone processes into autonomous, self-healing systems that maintain desired state continuously.

   43

   2
10. 10
    Article

    Neon·42w

    Generate Laravel Apps from a Prompt

    app.build, an open-source AI agent, now supports generating complete Laravel applications from natural language prompts. The tool handles project scaffolding, test writing, database setup with Postgres, and deployment instructions. Users can install the CLI, describe their app in a prompt, and receive a fully structured Laravel project following best practices, complete with a private GitHub repository and deployment guidance for Laravel Cloud.

    27
11. 11
    Video

    Web Dev Cody·43w

    How to find performance issues in SQL query

    A practical guide to identifying and fixing SQL query performance issues using the EXPLAIN command and database indexing. The tutorial demonstrates how to analyze a complex query with multiple joins and subqueries, use AI tools to interpret query execution plans, and implement indexes to dramatically reduce query costs from 10,000 to 29. Key techniques include enabling ORM logging to capture raw SQL, using database tools to run EXPLAIN statements, and strategically adding indexes on foreign keys and frequently queried columns.

    21
12. 12
    Video

    ByteGrad·45w

    Next.js + Postgres Dev / Prod (VPS Coolify, Prisma, Migrations)

    A comprehensive guide showing how to set up a Next.js application with PostgreSQL database locally using Docker and Prisma ORM, then deploy it to production on a VPS using Coolify. Covers database migrations, environment variable configuration, and automated deployment workflows with GitHub integration.

    21

    1
13. 13
    Article

    Socket·43w

    Bun 1.2.19 Adds Isolated Installs for Better Monorepo Suppor...

    Bun 1.2.19 introduces isolated installs with the --linker=isolated option to improve monorepo dependency management by preventing cross-package conflicts. The release adds a new bun pm pkg command for programmatic package.json editing, improves workspace installs, and includes a bun why command for dependency tracing. Performance improvements include 5x faster PostgreSQL queries through automatic pipelining, 1ms faster startup times, and 3MB less memory usage. The update resolves 163 issues and positions Bun as a stronger competitor to pnpm for monorepo workflows.

    18
14. 14
    Article

    PostgreSQL·43w

    Autobase 2.3.0 released

    Autobase 2.3.0 introduces dark theme for the console UI, ability to import existing PostgreSQL clusters, export functionality to Ansible inventory, refactored Ansible Collection integration, and AWS Network Load Balancer support. This open-source DBaaS platform simplifies PostgreSQL cluster deployment and management with automated operations including failover, backups, and scaling.

    17

    2
15. 15
    Article

    PostgreSQL·44w

    PostgreSQL 18 Beta 2 Released!

    PostgreSQL 18 Beta 2 is now available for download, containing previews of all features planned for the final release. The PostgreSQL Global Development Group encourages community testing to identify bugs and issues before the stable release expected around September/October 2025. Key fixes in Beta 2 include improvements to pg_get_process_memory_contexts() function, pg_dump handling for complex table names, and changes to default statistics behavior. Users can upgrade using standard major version upgrade strategies like pg_upgrade or pg_dump/pg_restore, though production use is not recommended for beta versions.

    16

    1
16. 16
    Article

    Cloudflare·45w

    How TimescaleDB helped us scale analytics and reporting

    Cloudflare migrated from vanilla PostgreSQL to TimescaleDB for their Digital Experience Monitoring and Zero Trust Analytics products, achieving 5-35x query performance improvements and 33x storage compression. The team initially chose PostgreSQL over ClickHouse to maintain architectural simplicity, but as data scaled to billions of rows, they needed better performance. TimescaleDB provided automatic partitioning, continuous aggregates, columnstore compression, and sparse indexes while maintaining PostgreSQL compatibility. Key optimizations included proper index column ordering, compression policies, and segmentation strategies that dramatically improved query latency and reduced storage costs.

    15
17. 17
    Article

    Neon·46w

    Neon Joins TanStack: Instant Postgres Integration for Faster JavaScript Development

    Neon has created an official add-on for TanStack that enables instant PostgreSQL integration for JavaScript developers. The integration includes Neon Launchpad for spinning up databases without sign-up, open-source packages like NeonDB CLI and a Vite plugin, and seamless setup with a single command. This partnership aims to simplify database integration in the TanStack ecosystem and Vite-based applications.

    15
18. 18
    Article

    Neon·43w

    Postgres as Your Platform: Building Event-Driven Systems with Schema Changes

    PostgreSQL can serve as more than just a database by leveraging event triggers, LISTEN/NOTIFY, and the outbox pattern to create event-driven systems. When schema changes occur, event triggers automatically capture DDL operations as events, enabling automatic downstream processes like SDK generation, documentation updates, and data warehouse synchronization. This approach eliminates the need for external message queues and provides transactional consistency between schema changes and event processing. The pattern combines event triggers that write to an outbox table with LISTEN/NOTIFY for real-time notifications, creating a reliable system for automating infrastructure tasks based on database schema evolution.

    14
19. 19
    Video

    Theo - t3․gg·46w

    I finally switched to Postgres.

    A developer shares their experience switching from MySQL to PostgreSQL using PlanetScale's new PostgreSQL offering. The move was driven by PlanetScale's Metal infrastructure using local NVMe drives, which provides significantly better performance than traditional cloud database solutions. The article includes detailed benchmarks comparing PlanetScale PostgreSQL against competitors like Neon, Aurora, and Supabase, showing 2-20x performance improvements. The switch was particularly beneficial for Convex, which needed multi-database support per instance for their multi-tenant architecture. The performance gains come from PlanetScale's use of local NVMe storage instead of network-attached storage, combined with their Vitess-based replication and failover capabilities.

    14

    3
20. 20
    Article

    CYBERTEC PostgreSQL·44w

    PostgreSQL storage: Comparing storage options

    A comprehensive benchmark comparing PostgreSQL storage options using 144 million audit trail records. Row storage (heap) consumed 72GB but offered lightning-fast indexed queries (0.038ms). Columnar storage via Citus extension achieved 10x compression to 6.7GB, ideal for analytical workloads. CSV format required 85GB while Parquet files compressed to 5.5GB. Each storage type serves different purposes: row storage excels at OLTP operations, columnar storage optimizes analytical queries and reduces I/O, while Parquet provides excellent compression for data archiving and exchange.

    12
21. 21
    Article

    Architecture Weekly·44w

    The Order of Things: Why You Can't Have Both Speed and Ordering in Distributed Systems

    Distributed systems force a fundamental trade-off between ordering guarantees and performance. PostgreSQL prioritizes correctness through locking but suffers from contention under load. MongoDB optimizes for speed but requires handling eventual consistency at the application level. Kafka provides scalability through partitioning but only guarantees ordering within partitions. The article explores the technical mechanics behind these trade-offs, including transaction isolation, replication lag, and coordination costs, concluding that the solution is choosing appropriate guarantees for different use cases rather than seeking perfect solutions.

    10