Johni Douglas Marangon·6h agoDatabase Sharding Explained: A Hands-On Guide with Python, FastAPI, and SQLiteLearn how sharding works, how to pick a shard key, and build a working sharded to-do API from scratch
jbook·9h agoWhen a Book Is Deleted, Its Translation Goes With ItDelete a book from the shelf and the row in `books_meta` disappears. The translation lives somewhere else: five tables keyed by the same…
Benjamin Bennett Alexander·10h ago5 SQL Patterns You Must Master to Answer 90% of Data Analysis ChallengesMy SQL course for Data Analysis is now available on YouTube.
Tinguyen·1d agoA Web App in C, One Request at a TimeWhat a small C application reveals about request lifetimes, shared state, and the work a framework usually carries.
InSystem Design & Architecture Deep DivesbyNavya Devadiga·2d agoSQLite in Production: 11 Things That Decide Whether It Survives Real Traffic, MeasuredFrom 467 to 45,000 commits a second with two pragmas, no ‘database is locked’ errors, and the backup that copied no tables.
InAlt.byBharat Chandera·4d agoWhy I’m Switching My .NET App to SQLite (and You Might Too)When an embedded database beats SQL Server or Postgres, where it breaks, and how to set it up properly with EF Core.A response icon1A response icon1
Mirdadoeva Orasta·4d agoSQLite Foreign Keys: Turn the Check On for Every ConnectionA relationship in the schema still needs an enforcement boundary at runtime.
Carlos Crespo·5d agoAn Anonymous AI Demo Still Needs an Accounting SystemReservations, settlement and expiry in the processing budget behind Small Cuts
Roni Das·5d agoOne Database Node Was Left Alive. It Said 420 Rows. The Real Number Was 421.We built a 3-node rqlite cluster, killed its leader, then killed one more node. What a Raft cluster does in the seconds after a crash…
Andrei Kazialetski·6d agoBuilding an AWStats-Style Log Analyzer in RustAt first glance, a web log analyzer sounds like a weekend project. Read a line, parse an IP address and a URL, increment a counter, and put…
