Best of PostgreSQL — January 2024

1. 1
   Article

   freeCodeCamp·2y

   How to Build an Admin Dashboard with React

   Learn how to build a stunning admin dashboard with React and Next.js. Discover important Next.js concepts and powerful tools like Prisma, PostgreSQL, Tremor, NextAuth, and TailwindCSS.

   194

   1
2. 2
   Article

   Supabase·2y

   The Open Source Firebase Alternative

   FerretDB is an open source document database that adds MongoDB compatibility to other database backends like Postgres and SQLite. This post explains how to run FerretDB locally via Docker, test it with mongosh, and deploy it on Fly.io for production.

   175

   10
3. 3
   Article

   Community Picks·2y

   1 billion rows challenge in PostgreSQL and ClickHouse

   This post discusses the process of ordering 1 billion rows in Java using PostgreSQL and ClickHouse. It covers generating the data, setting up local databases, loading the data, running queries, and comparing the results. The post highlights the faster performance of ClickHouse compared to PostgreSQL for querying directly from a CSV file.

   30
4. 4
   Article

   Supabase·2y

   Getting started with Laravel and Postgres

   Learn how to get started with Laravel and Postgres using Supabase as an alternative to Heroku. Set up a new Laravel application, install the authentication template, configure the Postgres connection details, run database migrations, and start the app.

   24
5. 5
   Article

   DEV·2y

   Building a Local Development Environment: Running a Next.js Full-Stack App with PostgreSQL and Minio S3 Using Docker

   Learn how to build a local development environment for a full-stack Next.js application with PostgreSQL and Minio S3 using Docker-Compose.

   21

   1
6. 6
   Article

   TigerData (Creators of TimescaleDB)·2y

   PostgreSQL vs MySQL: Which to Choose and When

   Comparison of PostgreSQL and MySQL as relational databases. Explore their similarities, strengths, and weaknesses. Learn about their features and decide the right database solution based on your project requirements, scale, and data operations.

   20
7. 7
   Article

   Community Picks·2y

   How Cloudflare Was Able to Support 55 Million Requests per Second With Only 15 Postgres Clusters

   Cloudflare achieved the ability to support 55 million requests per second using only 15 Postgres clusters. They utilized PgBouncer as a connection pooler to manage Postgres connections, avoided the thundering herd problem, employed high-performance bare metal servers instead of cloud infrastructure, used the TCP Vegas congestion avoidance algorithm for concurrency management, ordered queries at the PgBouncer layer, and ensured high availability with the Stolon cluster manager.

   14

   2
8. 8
   Article

   Community Picks·2y

   How the PostgreSQL optimizer works to speed up queries

   This post explains how the PostgreSQL optimizer works and highlights some important techniques it uses to speed up queries, such as constant folding, function inlining, join optimization, join order determination, join pruning, and optimized sorting for ORDER BY.

   14
9. 9
   Article

   Adam Johnson·2y

   PostgreSQL: Full text search with the “websearch” syntax

   PostgreSQL's powerful full text search feature supports the websearch syntax, which is forgiving and user-friendly. It allows individual word matching, double-quoted phrase matching, OR conditions, and negating matching. This post explains the syntax and how to use it in queries. It also mentions the integration of websearch in Django.

   14

   1
10. 10
    Article

    Collections·2y

    pgroll: Zero-Downtime Schema Migrations for PostgreSQL

    pgroll is a powerful tool for zero-downtime, reversible schema migrations in PostgreSQL. It ensures data integrity, allows coexistence of old and new schema versions, and is widely praised for its ease of use and reliability.

    12

    1