Best of PostgreSQL — February 2024

1. 1
   Article

   Hacker News·2y

   Postgres is Enough

   This post discusses various use cases and libraries for working with PostgreSQL, including background jobs, message queues, GIS/mapping, audit logs, access control, search, foreign data integration, and HTTP.

   120

   7
2. 2
   Article

   Vlad Mihalcea·2y

   PostgreSQL Performance Tuning Settings

   Explore various PostgreSQL performance tuning settings and why Aiven uses different values compared to the default ones.

   34
3. 3
   Article

   Python in Plain English·2y

   Setting up PostgreSQL and PgAdmin4 using Docker: A Simplified Approach.

   This post provides a simplified approach to setting up PostgreSQL and PgAdmin4 using Docker. It explains the benefits of containerization and guides readers through the process of installing Docker, running the Hello World container, and setting up PostgreSQL and PgAdmin4 containers. The post emphasizes the ease and efficiency of managing databases with containerization.

   25

   2
4. 4
   Article

   Lobsters·2y

   electric-sql/pglite: Lightweight Postgres packaged as WASM into a TypeScript library for the browser, Node.js, Bun and Deno

   PGlite is a lightweight Postgres packaged as WASM into a TypeScript library. It allows you to run Postgres in the browser, Node.js, and Bun without any additional dependencies. It can be used as an ephemeral in-memory database or with persistence to the file system or indexedDB. Parameterized queries are not supported yet. It is being developed at ElectricSQL in collaboration with Neon.

   24

   2
5. 5
   Article

   EverSQL·2y

   SQL Optimization: a comprehensive developer’s guide

   This post provides a comprehensive guide on optimizing SQL queries. It covers topics such as optimizing SELECT, INSERT, and DELETE SQL queries and provides tips on using indexes, improving joins, filtering, and more. The post also introduces EverSQL by Aiven, a tool that can provide performance insights and SQL optimization suggestions.

   23
6. 6
   Article

   TigerData (Creators of TimescaleDB)·2y

   Psycopg2 vs Psycopg3 Performance Benchmark

   The performance benchmark compares Psycopg2 and Psycopg3, highlighting the significant improvements in efficiency and asynchronous support introduced by the latter.

   19

   2
7. 7
   Article

   Community Picks·2y

   How to Migrate Data From Sheets to Postgresql

   Learn how to migrate data from Google Sheets to PostgreSQL using Appsmith. Connect to your data sources, write migration logic, and display the data in the UI.

   18
8. 8
   Article

   DEV·2y

   Building scalable apps with serverless PostgreSQL & Django

   Learn how to use serverless PostgreSQL with Django to build scalable and efficient web applications.

   17
9. 9
   Article

   Hacker News·2y

   Form to database, instantly

   Build forms on top of your Postgres, MySQL or MSSQL database without using custom React forms or messy ETL from spreadsheets.

   11
10. 10
    Article

    Hacker News·2y

    readysettech/readyset: Readyset is a MySQL and Postgres wire-compatible caching layer that sits in front of existing databases to speed up queries and horizontally scale read throughput. Under the hoo

    ReadySet is a transparent database cache for Postgres & MySQL that improves performance and scalability without requiring app rewriting or manual cache invalidation. It is wire-compatible with Postgres and MySQL and can be used with existing ORMs or database clients.

    11
11. 11
    Article

    DEV·2y

    🏁🐘Winning Race Conditions With PostgreSQL

    This post discusses race conditions in databases, particularly in PostgreSQL, and provides solutions for avoiding them. It covers cases of simple uniqueness, compound uniqueness, compound multiple uniqueness, and compound referential uniqueness. The article also mentions the use of transactions, advisory locks, and the SERIALIZABLE transaction isolation level. Overall, it offers techniques to handle and prevent race conditions in database operations.

    11
12. 12
    Article

    Hacker News·2y

    Revolutionizing PostgreSQL Schema Changes with pg_osc

    pg_osc is an open-source tool that revolutionizes PostgreSQL schema changes by minimizing downtime, avoiding blocking, and ensuring data consistency.

    10
13. 13
    Article

    JOOQ·2y

    What's faster, COUNT(*) or COUNT(*) with LIMIT in SQL? Let's check

    Learn the recommended way to check for the existence of values in SQL and the difference between using LIMIT and COUNT(*) for checking the number of rows.

    10