Hacker News·2yMaking a Postgres query 1,000 times faster
The author shares their journey of optimizing a Postgres query to make it 1,000 times faster. They discovered that the query was taking longer and longer each time it was executed due to processing all rows in the table and the use of a filter instead of an index condition. By using row constructor comparisons, they were able to significantly improve the query performance.
Community Picks·2yCRUD App with Prisma ORM & Node.js
Learn how to create a CRUD App with Prisma ORM and Node.js using TypeScript and PostgreSQL. Prisma is a next-generation ORM tool that simplifies database management and access. Follow the steps to setup a Prisma project, create models, perform database migrations, and perform CRUD operations using Prisma Client.
Hacker News·2ytembo-io/pgmq: A lightweight message queue. Like AWS SQS and RSMQ but on Postgres.
PGMQ is a lightweight message queue built on Postgres. It guarantees exactly once delivery of messages within a visibility timeout and offers API parity with AWS SQS and RSMQ. It provides features like message archiving and tables can be partitioned for efficient management. You can try PGMQ for free using the Tembo docker image.
Community Picks·2yThe API database architecture - Stop writing HTTP-GET endpoints
The API database architecture eliminates the need for writing HTTP-GET endpoints by using PostgREST as a server to connect to a PostgreSQL database. It supports filtering, sorting, paging, and authentication out of the box.
Theo - t3․gg·2yPostgres Doesn't Scale, Unless...
Figma shares their experience in horizontally sharding their Postgres database to achieve nearly infinite scalability. They faced challenges such as inefficient query execution, loss of reliability and consistency properties, and the need for custom solutions. Figma developed a complex architecture using logical and physical sharding, views, and a custom query engine. The process of horizontally sharding a database is explained in detail, including the use of feature flags and shadow reads to ensure a safe migration. The article also highlights the need for further advancements in schema updates, global unique ID generation, atomic cross-shard transactions, ORM compatibility, and automated shard operations.
TigerData (Creators of TimescaleDB)·2yHow to Collapse Your Stack Using PostgreSQL for Everything
The post discusses the concept of collapsing your stack by using PostgreSQL for multiple use cases. It highlights the challenges of stack sprawl with multiple databases and emphasizes the benefits of simplicity and using PostgreSQL for various workload types.
Codemotion·2yOpen Source: The Awakening of PgSQL
PostgreSQL, an open-source database, has revitalized the use of SQL in 2024. It is likened to a Jedi of databases and offers flexibility, scalability, and security. PostgreSQL has become a unified solution for both OLTP and OLAP, and its support for extensions allows for versatility in data management.
Quastor Daily·2yHow Reddit built a Metadata Store that Handles 100k Reads per Second
This post discusses how Reddit built a metadata store that handles 100k reads per second. It explores the high level goals of the metadata store, the considerations for picking the database, and the scaling strategies used by Reddit.
TigerData (Creators of TimescaleDB)·2yPostgreSQL Data Cleaning vs. Python Data Cleaning
This post explores how PostgreSQL and TimescaleDB can be used for efficient data cleaning tasks, replacing the need for tools like Excel, R, or Python. By cleaning data directly within the database, tasks can be performed more efficiently, saving time in the long run.
