Best of PostgreSQL — March 2025

  1. 1
    Video
    Avatar of fireshipFireship·1y

    I replaced my entire tech stack with Postgres...

    Modern web development often involves using multiple tools, leading to high costs and complexity. However, PostgreSQL, a powerful relational database, can handle many tasks typically outsourced to other services. It offers advanced data types, support for unstructured data, extensions for cron jobs, in-memory caching, vector storage, GraphQL, real-time syncing, authentication, analytics, and more. The post emphasizes critically choosing the right tools and showcases how PostgreSQL can simplify full stack application development.

  2. 2
    Video
    Avatar of codingwithlewisCoding with Lewis·1y

    How Notion Handles 200 BILLION Notes (Without Crashing)

    Notion has managed its rapid growth by adopting sharding to distribute its data across many smaller databases. Initially using a single Postgres database, they experienced slowdowns and shifted to sharding their block model. They later built their own data lake using AWS S3, Apache Spark, and other open-source tools to handle their data processing needs effectively. By reorganizing and scaling up their infrastructure, Notion maintained performance and avoided service interruptions for users.

  3. 3
    Article
    Avatar of communityCommunity Picks·1y

    You can make Postgres scale

    PostgreSQL can be scaled effectively by using sharding to distribute the write workload across multiple databases. This process involves significant engineering effort, including ensuring data integrity during replication, setting up multiple replicas, and configuring the application to handle sharded databases. The story highlights the challenges faced and solutions implemented by a dedicated team to achieve this scalability with PostgreSQL.

  4. 4
    Article
    Avatar of newstackThe New Stack·1y

    FerretDB 2.0: Open Source MongoDB With PostgreSQL Power

    FerretDB, an open-source MongoDB proxy running on PostgreSQL, has released version 2.0 with significant performance improvements using the DocumentDB extension from Microsoft. This extension enables SQL queries for BSON data, making FerretDB a flexible on-premises alternative to MongoDB-compatible cloud services. FerretDB seeks to provide an open-source solution for MongoDB users, emphasizing vendor-neutrality and community-driven development through the OpenDocDB initiative.

  5. 5
    Article
    Avatar of neontechNeon·1y

    Building RagRabbit, An Open Source RAG Search with Postgres as the Vector Store

    RagRabbit is an open-source tool designed to simplify Retrieval-Augmented Generation (RAG) workflows by using Postgres with pgVector for handling vector embeddings. It can crawl websites, convert pages to Markdown, generate embeddings, and use MCP servers to integrate with development tools. RagRabbit supports secure user authentication and can be deployed effortlessly using Vercel.

  6. 6
    Article
    Avatar of communityCommunity Picks·1y

    xataio/agent: AI agent expert in PostgreSQL

    Xata Agent is an open-source AI tool designed to monitor PostgreSQL databases, identify issues, and suggest fixes. It proactively tunes configurations, troubleshoots performance, and notifies users via Slack. The agent is extensible with tools, playbooks, and integrations, and supports multiple cloud providers and models from OpenAI, Anthropic, and Deepseek. Available as a Docker image, it can be easily deployed locally or on an EC2 instance.

  7. 7
    Article
    Avatar of crunchydataCrunchy Data·1y

    Citus: The Misunderstood Postgres Extension

    Citus is an advanced Postgres extension that transforms Postgres into a sharded, distributed, horizontally scalable database suited for specific use cases. It excels in sharding multitenant applications and handling high data volume analytics with minimal user interaction. However, it is not ideal for scenarios with loose query controls or geographic residency requirements. Proper planning of shard keys and design considerations are crucial for success with Citus.

  8. 8
    Video
    Avatar of laraveldailyLaravel Daily·1y

    PostgreSQL in Laravel: Faster/Better than MySQL?

    PostgreSQL is increasingly being used by Laravel developers due to its advanced features and performance improvements over MySQL. Despite its relatively lower popularity, PostgreSQL is preferred for new projects, with noted benefits in handling complex queries and data types. However, migrating existing projects from MySQL to PostgreSQL can be challenging and is only recommended if the specific features of PostgreSQL are needed.

  9. 9
    Article
    Avatar of supabaseSupabase·1y

    Dedicated Poolers

    Supabase has announced Dedicated Poolers, a dedicated PgBouncer instance co-located with your Postgres database for enhanced performance and reliability. This is available for Enterprise customers and will be generally available by March 18, 2025. Users can choose between direct connections, shared poolers, and dedicated poolers, depending on their needs and plans.

See all PostgreSQL archives