renzume.

Database

A comprehensive technical guide explaining the internal mechanisms and subsystems of PostgreSQL database system, covering versions 17 and earlier. The document serves as an educational resource detailing process architecture, query processing, concurrency control, and other crucial database management aspects, authored by Hironobu SUZUKI.

EdgeDB is now Gel and Postgres is the Future | Gel Blog

PostgreSQL's unique position as a truly open-source, advanced relational database with extensive modularity is driving its accelerating adoption across the industry. EdgeDB announces its rebranding as Gel, introducing full SQL support and deeper ecosystem integration while maintaining its role as a PostgreSQL frontend layer enhancement. The platform aims to provide seamless database integration similar to how TypeScript enhances JavaScript.

K-12 School Shooting Database

A database tracks comprehensive K-12 school shooting incidents, including all instances of guns being fired, brandished, or bullets hitting school property. The database encompasses various scenarios like gang violence, domestic incidents, sports event shootings, and accidents, documenting the full scope of gun-related incidents on school grounds.

When Imperfect Systems are Good, Actually: Bluesky’s Lossy Timelines

Bluesky implemented a 'Lossy Timelines' system to improve performance by intentionally dropping some timeline updates for users who follow many accounts. This solution reduced fanout latency by 96% and eliminated hot shard issues in their database clusters. The approach demonstrates how embracing imperfection in system design can lead to better scalability and performance.