Best of PostgreSQL — August 2025

1. 1
   Article

   freeCodeCamp·40w

   How to Design Structured Database Systems Using SQL [Full Book]

   A comprehensive guide covering database fundamentals, from basic data concepts to designing structured database systems. Explores the DIKW pyramid (Data, Information, Knowledge, Wisdom), database management systems architecture, ACID properties, and various data models including relational databases, NoSQL systems, and Big Data approaches. Includes practical examples using PostgreSQL and covers essential topics like data types, domains, database design principles, and the differences between structured, semi-structured, and unstructured data.

   251

   2
2. 2
   Article

   Neon·41w

   the future of real-time UI

   TanStack DB paired with ElectricSQL enables developers to build real-time, reactive UIs with minimal complexity. ElectricSQL uses Postgres logical replication to detect database changes and push updates to clients, while TanStack DB handles optimistic mutations and client-side state management. This combination eliminates the need for custom WebSocket logic and allows Postgres to serve as the single source of truth for real-time updates, making collaborative and multi-device applications more accessible to developers.

   155

   5
3. 3
   Article

   The Miners·41w

   How To Solve Every Programming Problem

   A systematic approach to solving programming problems using a four-step methodology: understand the problem, devise a plan, carry out the plan, and look back. The article demonstrates this process through a practical example of implementing parking reservation validation with capacity limits, showing how to break down complex problems into manageable steps and validate each solution component.

   122

   1
4. 4
   Article

   Fermyon·38w

   Announcing Spin 3.4

   Spin 3.4 introduces HTTP/2 support for outgoing requests, enabling seamless integration with gRPC-based backends and improving performance through multiplexed connections. The release adds PostgreSQL connection pooling for better database performance and expands supported data types including UUID, JSONB, and array types. Additionally, Spin templates now include schema directives in spin.toml files for automatic validation and code completion in editors.

   91

   1
5. 5
   Video

   Awesome·40w

   Postgres 18 just dropped. Now is the best time to learn it...

   PostgreSQL 18 introduces significant performance improvements through asynchronous I/O support, delivering 2-3x better performance in read-heavy applications. Key features include smarter query optimization for OR/IN clauses, enhanced hash joins, virtual generated columns as default, UUID version 7 support with timestamp ordering, improved RETURNING clause functionality, and temporal constraints with WITHOUT OVERLAPS. The upgrade process is now smoother with preserved statistics, eliminating the need to rebuild planner statistics after major version upgrades.

   85

   5
6. 6
   Article

   Neon·38w

   Why we built app.build

   Neon built app.build as an open-source reference architecture for AI agents that generate complete, production-ready applications rather than just code snippets. Unlike typical AI coding tools that focus on frontend components and compilation, app.build creates full-stack applications with proper backends, databases, testing, authentication, and automated deployments. The platform addresses common issues in AI code generation like demo-driven development and frontend bias by providing comprehensive scaffolding including GitHub repositories, Postgres databases, type-safe APIs, test suites, and CI/CD pipelines. Starting with a constrained TypeScript/React stack for reliability, it now supports multiple languages and frameworks through modular architecture using finite state machines and template-based generation.

   56

   1
7. 7
   Article

   PlanetScale·40w

   Announcing Neki — PlanetScale

   PlanetScale announces Neki, a new sharded Postgres solution built from first principles by the team behind Vitess. Unlike Vitess which leverages MySQL, Neki is designed specifically for Postgres workloads and will be released as open source when ready. The project aims to bring the same extreme scale capabilities that Vitess provides for MySQL to the Postgres ecosystem.

   51
8. 8
   Article

   Reinier·39w

   Build and Deploy Nike’s $100B Full Stack eCommerce App | Next.js, PostgreSQL, Tailwind, Devin AI

   A comprehensive tutorial demonstrating how to build a Nike-inspired eCommerce application using modern web technologies. The project combines Next.js 15 with TypeScript for the frontend, TailwindCSS for styling, and a robust backend featuring Neon PostgreSQL with Drizzle ORM. The tutorial explores using Devin AI for development assistance, implements Better Auth for authentication, and uses Zustand for state management, all structured in a modular architecture designed for scalability and maintainability.

   49

   3
9. 9
   Article

   TestDriven.io·38w

   Developing a Real-time Dashboard with Flask, Postgres, and Socket.IO

   A comprehensive tutorial demonstrating how to build a real-time inventory tracking dashboard using Flask, PostgreSQL, and Socket.IO. The guide covers implementing PostgreSQL LISTEN/NOTIFY triggers for database change detection, creating a threaded notification listener, building RESTful API endpoints for inventory management, and developing a responsive frontend with live WebSocket updates. Key features include automatic real-time synchronization across multiple clients, proper error handling, and a complete working dashboard interface.

   40
10. 10
    Article

    Awesome Go·41w

    Inside the Tech Stack of dblayer - Go, Next.js 15, Express & Beyond

    A detailed breakdown of dblayer's modular architecture, which transforms PostgreSQL databases into secure APIs and applications. The platform uses Go with Fiber for the core API server, Express.js with TypeScript for dashboard management, Next.js 15 for the frontend, and separate background workers for async tasks. The tech stack emphasizes performance, type safety, and maintainability across multiple loosely coupled services.

    37

    1
11. 11
    Article

    Crunchy Data·40w

    Indexing JSONB in Postgres

    PostgreSQL's JSONB datatype offers powerful querying capabilities, but requires proper indexing for optimal performance. GIN (Generalized Inverted Index) indexes are ideal for containment queries, key existence checks, and JSONB operators like @>, ?, ?|, and ?&. However, GIN indexes don't help with path-based navigation, comparisons, or pattern matching within JSONB values. For these cases, expression indexes using B-tree structures work better. GIN indexes have higher write overhead and can suffer from bloat, requiring periodic maintenance with REINDEX CONCURRENTLY. Best practices include using GIN for containment-style lookups, expression indexes for specific key queries, and combining both approaches for comprehensive JSONB performance optimization.

    34
12. 12
    Article

    ByteByteGo·40w

    How Atlassian Migrated 4 Million Jira Databases to AWS Aurora

    Atlassian successfully migrated 4 million Jira databases from AWS RDS PostgreSQL to Aurora PostgreSQL across 3,000 server instances in 13 regions. The migration faced a critical challenge when Aurora's file count limitations prevented startup with 20+ million files per cluster. They solved this by developing a "drain-convert-refill" strategy that reduced tenant density during conversion, then repopulated clusters afterward. The project achieved 99.99% uptime SLA, better cost efficiency through auto-scaling, and maintained under 3 minutes downtime per tenant while processing up to 90,000 daily migrations at peak.

    29
13. 13
    Article

    Supabase·40w

    Supabase Auth: Build vs. Buy

    Supabase Auth offers a Postgres-native authentication solution that significantly reduces development time and costs compared to building custom auth systems. The service provides JWT-based authentication with Row Level Security integration, supporting multiple providers and security features. Building authentication from scratch typically requires 320-680 hours in the first year, while Supabase Auth can be implemented in 4-24 hours, representing potential savings of $47,400-$98,700. The comparison with Auth0 shows Supabase's advantages in cost predictability, database integration, and open-source flexibility, though Auth0 excels in enterprise features. Teams should only build custom auth for specialized compliance requirements, legacy system integration, or unique authentication flows.

    29
14. 14
    Article

    Neon·38w

    Databuddy Is Open-Sourcing Privacy-First Analytics, Built on Neon

    Databuddy launches as an open-source, privacy-first analytics platform that balances simplicity with powerful features. Built on Neon's serverless Postgres, it uses a composable architecture with Next.js frontend, ClickHouse for analytics data, and Drizzle ORM. The founder chose Neon over alternatives like Supabase for its performance, simplicity, and composable approach, finding it faster than self-hosted setups without maintenance overhead.

    27
15. 15
    Article

    Last9·38w

    What is Database Monitoring

    Database monitoring involves tracking query execution times, resource utilization, and connection patterns to proactively identify performance issues before they impact users. The guide covers native database tools versus unified observability platforms, monitoring strategies for different database architectures (relational vs NoSQL), and implementation approaches including metrics collection, alerting, and correlation with application performance. It emphasizes the importance of real-time observability in distributed systems and provides practical examples for PostgreSQL, MySQL, SQL Server, and Oracle monitoring setups.

    21
16. 16
    Article

    Product Hunt·38w

    Dreambase.ai: Fully Integrated Analytics from Supabase

    Dreambase.ai is a new analytics platform that connects directly to Supabase and PostgreSQL databases to provide instant insights and dashboards. The tool eliminates the need for third-party tracking libraries and complex data pipelines by working directly with your database as the source of truth. It features AI-powered analysis, real-time data visualization, and combines analytics, operations, and internal tooling in one platform. The founders, with backgrounds at major tech companies, created this solution to address frustrations with traditional BI tools that require extensive setup and data engineering resources.

    20

    1
17. 17
    Article

    freeCodeCamp·39w

    How to Deploy a Next.js API with PostgreSQL and Sevalla

    A comprehensive guide to building REST APIs with Next.js and PostgreSQL, covering project setup, database connection, CRUD operations, and deployment to Sevalla's PaaS platform. The tutorial demonstrates creating user management endpoints, connecting to a cloud-hosted PostgreSQL database, and deploying the complete application with automatic deployment features.

    19
18. 18
    Article

    SingleStore·40w

    Scaling PostgreSQL vs. SingleStore: Overcoming Performance & Complexity Limits

    PostgreSQL faces significant scaling challenges as applications grow, requiring complex workarounds like read replicas, manual partitioning, and additional tools for caching and analytics. These solutions create operational overhead and architectural complexity. The database's row-based storage struggles with analytical workloads, while lock contention limits write throughput. AI workloads with vector embeddings further strain the system. SingleStore is presented as an alternative that combines transactional and analytical capabilities in a unified, horizontally scalable SQL engine with built-in vector search and hybrid storage formats.

    14

    1
19. 19
    Article

    Crunchy Data·39w

    Postgres Logging for Performance Optimization

    PostgreSQL provides comprehensive logging capabilities for performance optimization and troubleshooting. Key configurations include setting up log collectors, choosing appropriate log formats (stderr, csvlog, jsonlog), and configuring severity levels. For performance monitoring, enable logging of slow queries with log_min_duration_statement, lock waits with log_lock_waits, and temporary file usage with log_temp_files. The auto_explain extension automatically logs query execution plans for analysis. Proper log rotation prevents disk space issues, while tools like pgBadger can parse logs into visual reports. Additional audit logging is available through the pgAudit extension for tracking user actions and data changes.

    13
20. 20
    Video

    Jack Herrington·40w

    TanStack DB In 15 Minutes! ORM or State Manager?

    TanStack DB is a state management library based on synced collections and live SQL-style queries, not a traditional ORM. It enables real-time data synchronization between client and server through streaming connections, with support for various collection types including in-memory, local storage, TanStack Query, and ElectricSQL collections. The library provides a pub-sub mechanism for automatic data consistency and offers a new approach to client-side state management through live queries on collections.

    10

    1
21. 21
    Article

    Neon·41w

    Anything: The New AI Agent for Building Mobile and Web Apps

    Anything (formerly Create.xyz) is a new AI agent platform that generates complete full-stack applications from simple prompts. It creates production-ready mobile and web apps with built-in backend infrastructure, authentication, payments, and database support powered by Neon's serverless Postgres. The platform offers one-click app store deployment, automatic error recovery, and custom UI designs trained on real-world examples.

    10