Kevin Tung·Oct 19We Widened the Sequence to BIGINT. Inserts Still Failed.When a serial primary key hits 2,147,483,647, the sequence, the column and every foreign key all need widening. What each fix misses on…
Brian Mills·Sep 4Hypergraphs as an intermediate representation for schema translationA hypergraph is a graph whose edges may join any number of vertices, not only two. An intermediate representation is the form a compiler…
Remo·Jul 29I Used to Dread Opening the Database Console — Here’s How Claude Became My Query PartnerClaude helped with all of these Schema design, Slow queries, Migrations, Indexing…
Soham Mandaviya·Jun 24Engineering a Clinical Rule Engine: Low-Level Design, Data Modeling, and Scalability ChallengesModern healthcare platforms process a continuous stream of patient-generated data from Electronic Health Record (EHR) systems.
Tarun Wadhwa·Jun 14SQL vs NoSQL: The Difference Was Never About SchemaBeyond Schema: A Practical Guide to SQL, NoSQL, and Database Design
Viraj Lakshitha Bandara·Jun 5Schema Evolution in the Age of AI-Generated Data: When Machines Write Your Database
InAlgorithmic and Quantitative TradingbyBhaskar Das·May 21DuckDB Schema Design Best Practices for Financial Data: A Beginner-Friendly Guide for Traders and…Whether you are:
Zeinab Dashti·Apr 23From Inheritance to Contracts: What Avro Forces You to ChangeHow Avro’s constraints shape data modeling, replace inheritance, and force explicit contracts at system boundaries
Son Tran·Apr 10Design Data Model for Multi-Tenant RBAC. Part 1: Identity FoundationRBAC is a well-known concept that most software engineers have encountered. For me, it is an interesting topic worth sharing, especially in…
