Best of PostgreSQL — May 2025

1. 1
   Article

   Supabase·51w

   Open Data Standards: Postgres, OTel, and Iceberg

   The post discusses emerging open data standards in the data world including Postgres, Open Telemetry (OTel), and Iceberg. These standards are underpinned by important open source tenets: OSI-approved licensing, the feasibility of self-hosting, and vendor neutrality. Postgres has become a standard due to its compatibility across platforms and non-ownership by any single entity. OTel is gaining traction among major cloud providers for its telemetry capabilities, while Iceberg is leading in OLAP standards. The emphasis is on achieving portability and interoperability, particularly with AWS's S3, enhancing data management and reducing vendor lock-in.

   78

   1
2. 2
   Article

   Neon·1y

   Postgres 18 Beta Is Out: 7 Features You Should Know About

   Postgres 18 Beta introduces asynchronous I/O for improved performance and throughput, enhanced major version upgrade features, and more detailed EXPLAIN outputs. Additionally, it includes new statistics for vacuum and analyze operations, UUIDv7 generation, parallelizable GIN index builds, and OAuth authentication support. Postgres 18 promises significant performance improvements and operational enhancements for database users.

   74

   2
3. 3
   Article

   Community Picks·1y

   The fastest Postgres inserts

   This post outlines strategies to enhance PostgreSQL insert operations, sharing benchmarks and optimizations for better throughput and reduced latency. Key takeaways include reducing network latency, using connection pooling efficiently, leveraging batched inserts, and utilizing COPY FROM optimally. The importance of tuning batch sizes for ideal performance is stressed, with further advanced techniques to be explored in upcoming content.

   71

   1
4. 4
   Article

   SingleStore·52w

   MySQL vs PostgreSQL vs SingleStore Performance in Docker

   The post compares MySQL, PostgreSQL, and SingleStore using a benchmark with over 100 million transactions in Docker containers. The results show SingleStore has superior performance in handling complex queries involving heavy joins and analytics, while MySQL struggles and PostgreSQL performs better than MySQL but not as well as SingleStore. A full benchmarking setup is shared for readers to try on their own systems.

   64

   1
5. 5
   Article

   Community Picks·1y

   PostgreSQL Optimizer

   EverSQL provides automated optimization for PostgreSQL and MySQL databases using AI-powered algorithms to enhance query performance. It offers ongoing performance monitoring without accessing sensitive data, claiming to significantly improve query speed and helping users save time and costs by optimizing database performance.

   41
6. 6
   Article

   Collections·52w

   Enhancing PostgreSQL Development with Microsoft's VS Code Extension

   Microsoft has launched a PostgreSQL extension for Visual Studio Code that aims to improve database management and development workflows. Features include GitHub Copilot integration, schema visualization, Docker container management, and Entra ID for secure connections. This extension provides tools for efficient, secure, and productive database interactions, particularly for those using Azure Database for PostgreSQL.

   36

   4
7. 7
   Article

   freeCodeCamp·1y

   Code a Dropbox Clone with NextJS

   Learn to build 'Droply,' a Dropbox-inspired file management app using Next.js, Clerk, Neon, Drizzle ORM, and other modern tools. Gain hands-on experience in full-stack development with user authentication, database management, file processing, and UI design. Complete assignments to reinforce learning and create production-grade software.

   30
8. 8
   Article

   The New Stack·51w

   PostgreSQL 18 Delivers Significant Performance Gains for OLTP and Analytics

   PostgreSQL 18 introduces substantial performance enhancements for OLTP and analytics, with asynchronous inputs and advanced query optimization. The edition supports external indices as extensions, expedites parallel index building, and strengthens the database's capabilities in data warehousing and cloud environments. These advancements mark a pivotal improvement for high-volume deployments and analytic applications.

   27
9. 9
   Article

   Database Daily·51w

   PostgreSQL Maximalism

   A new YouTube series explores the various extensions of PostgreSQL and their versatile use cases. Part 1 is already available, and viewers can access detailed unedited research notes on the creator's website. Engagement through comments and social media is encouraged for questions or ideas.

   25

   6
10. 10
    Video

    Web Dev Cody·51w

    My current tech stack

    The post discusses the author's current tech stack choices for two side projects. It highlights the use of Tanstack start for easier onboarding compared to Next.js, Drizzle OM over Prisma for simpler integration in serverless environments, and Convex for backend tasks with built-in features for complex applications. The author prefers PostgreSQL for memory efficiency, Tailwind CSS for styling, and chooses minimal libraries for authentication to simplify maintenance.

    18
11. 11
    Article

    SingleStore·52w

    5 Signs Your PostgreSQL Database Is Hitting Its Performance Limits

    PostgreSQL is a powerful relational database system, but can face performance issues as workloads increase. Common signs include slow query performance, lock contention, data ingestion struggles, the need to frequently archive data, and diminishing hardware upgrade returns. SingleStore offers a modern, distributed architecture that enhances real-time analytics, reduces lock contention, supports high-throughput data ingestion, handles large data volumes efficiently, and scales horizontally for better performance and cost efficiency.

    18
12. 12
    Article

    Supabase·1y

    PostgreSQL Event Triggers without superuser access

    Event triggers in PostgreSQL traditionally require superuser access, which is often not feasible in cloud environments. Using the Supautils extension, regular users can create event triggers through a privileged role that temporarily escalates privileges. Utility and Function Manager Hooks are employed to safely manage privilege escalation and execution, circumventing issues with malicious user actions. Discussion is ongoing for core integration in PostgreSQL.

    18
13. 13
    Article

    Neon·51w

    The Difference Between Postgres Logging and PGAudit

    Postgres has strong internal logging features for monitoring and troubleshooting, but it doesn't meet compliance auditing needs. PGAudit offers specialized logging for compliance, including session and object auditing, which provides detailed control over logged information. It helps meet standards like HIPAA by ensuring sensitive data is properly tracked and redacted in logs. Using both Postgres logging and PGAudit ensures operational insights and compliance readiness.

    15

    1
14. 14
    Article

    Instacart·51w

    How Instacart Built a Modern Search Infrastructure on Postgres

    Instacart has developed a modern search infrastructure using Postgres to combine traditional full-text search with semantic retrieval, leveraging pgvector for improved performance and precision. This new system unifies retrieval mechanisms, reduces operational overhead, and enhances search relevance, accommodating dynamic inventory and complex user preferences efficiently.

    12
15. 15
    Article

    .NET Escapades·51w

    Converting a docker-compose file to .NET Aspire

    This post details the conversion of a docker-compose.yml file for the mailing-list manager listmonk into a .NET Aspire app host project. The transition aims to simplify local development and artifact generation for deployment. The author provides a step-by-step guide to model the services in .NET Aspire, install prerequisites, and utilize Aspire integrations and parameters for configuration. The post concludes with exporting the Aspire app host back to a docker-compose.yml file to compare results.

    12

    3
16. 16
    Article

    freeCodeCamp·52w

    How to Deploy Your FastAPI + PostgreSQL App on Render: A Beginner's Guide

    This guide offers a step-by-step process to deploy a FastAPI app connected to PostgreSQL using Render. It covers essential preparation steps, setting up local and Render databases, project structuring, and deployment. The process includes configuring database connections and creating required files like 'requirements.txt'. Tips for local development workflow, best practices, and resolving common issues are shared. It highlights the simplicity of using Render, while noting potential limitations of the free tier.

    12
17. 17
    Article

    Supabase·52w

    Simplifying back-end complexity with Supabase Data APIs

    Supabase simplifies backend complexity by auto-generating secure REST and GraphQL APIs for Postgres databases, reducing infrastructure overhead and maintenance. It exposes APIs instantly for tables, views, and procedures without requiring custom CRUD endpoints. Supabase enables easy integration with features like pagination, filtering, and edge functions, enhancing flexibility and control, while row-level security and authentication ensure robust protection.

    11
18. 18
    Article

    Neon·51w

    Recreating S3 in Postgres using PostgREST

    The post explores creating a simple file server within Postgres using PostgREST, highlighting its capabilities in turning Postgres into a webserver for API operations. It covers setting up the database, serving files, and implementing row-level security (RLS) for access control. The concept provides a practical API scenario, though dedicated object storage solutions are often recommended for scalability and cost-effectiveness.

    10

    1