ByteByteGo·1yEP150: 12 Algorithms for System Design Interviews
Learn about 12 key algorithms used in system design interviews, including Bloom Filter, Geohash, and Consistent Hashing. Understand the workings of Kubernetes, an open-source container orchestration platform, and explore the architecture of PostgreSQL, the popular database system. Additionally, discover important tips for API security.
Community Picks·1y7 Crucial PostgreSQL Best Practices
PostgreSQL is a powerful relational database management system. To ensure optimal performance, security, and maintainability, follow best practices such as consistent naming conventions, appropriate schema design, efficient indexing and querying, proper access control, comprehensive backup strategies, routine maintenance and monitoring, effective database version control, and high availability configurations. Regularly review and update these practices, document deviations, and stay informed about PostgreSQL updates to build a robust database infrastructure.
The Polymathic Engineer·1yDatabase sharding case study: PostgreSQL
Notion's engineering team faced significant challenges in scaling their monolithic PostgreSQL database due to rapid user base growth. They decided to implement database sharding, with the Block table and related tables being sharded using Workspace ID as the key. The migration involved a double-write phase and verification to ensure data integrity. Despite some lessons learned, such as the importance of starting early and aiming for zero downtime, the outcome was a more scalable and faster system for Notion's users.
swizec.com·1yI was wrong about databases
The post discusses misconceptions about database performance with arrays and clarifies how PostgreSQL handles wide table rows using TOAST records and tombstones. It emphasizes the importance of measuring performance based on specific data access patterns, noting that modern SSDs make data packing less critical.
Towards AI·1yEnd-to-End Data Engineering System on Real Data with Kafka, Spark, Airflow, Postgres, and Docker
The post provides a detailed guide on building an end-to-end data engineering system using Kafka for data streaming, Spark for data transformation, Airflow for orchestration, PostgreSQL for storage, and Docker for setup and deployment. It is structured into two phases: the first focuses on constructing the data pipeline, while the second will cover creating an application to interact with the database using language models. This project is particularly suited for beginners to data engineering, aiming to deepen their practical knowledge of handling data systems.
As a Programmer·1yPERN Stack Course: Build a Product Store with Postgres & React
Learn how to build a full-stack product store with the PERN stack (Postgres, Express, React, and Node). The tutorial walks you through creating an API, connecting to a PostgreSQL database, writing SQL code, and building a responsive UI. Advanced concepts such as rate limiting, bot detection, and file structuring are also covered. The project concludes with deployment instructions.
Programming Digest·1yServing a billion web requests with boring code
Bill Mill shares his experience building a high-traffic Medicare plan comparison website for the US government using PostgreSQL, Go, and React. The system successfully managed about 5 million requests per day with excellent performance, emphasizing simplicity, reliability, and established technologies.
Supabase·1yPostgres as a Graph Database: (Ab)using pgRouting
pgRouting is a Postgres extension primarily used for geospatial routing and shortest path calculations, often in combination with PostGIS. Beyond GIS, it offers lightweight graph functionality for task scheduling, resource allocation in distributed systems, and recommendation engines. It supports key algorithms like Dijkstra and A* for solving complex routing problems in graph-based structures.
Community Picks·1yDeploy Full-Stack .NET Apps for FREE in 2025 (Azure + Postgres)
Learn how to deploy a full-stack application using React, .NET, and Postgres in the Azure cloud completely for free. The guide covers setting up the frontend with Next.js as a static web app, the backend with ASP.NET Core 9 API hosted on Azure App Service, and using a Postgres database from Superbase or Neon. It includes step-by-step instructions for deploying the application and configuring necessary services and environment variables.
Community Picks·1yA new Postgres service is here
Prisma has launched a new managed PostgreSQL service designed to provide an always-on, serverless database with pay-as-you-go pricing. Utilizing bare metal servers and innovative unic kernels and micro VMs, the service aims to eliminate cold starts and offer real-time subscriptions, caching, and query optimization out of the box. Currently in early access, the service targets non-mission-critical projects with plans to improve storage, compute, and connection options in future updates.
Hacker News·1ytcdi/plrust: A Rust procedural language handler for PostgreSQL
PL/Rust is a procedural language for PostgreSQL that allows writing functions in Rust, offering natively compiled functions for optimal performance and safety. It supports various Postgres data types and can be used to write trigger functions. PL/Rust is available as both a 'trusted' and 'untrusted' procedural language depending on the system. The post provides installation instructions, configuration settings, and additional resources for getting started.
