AAnandinblog.anands.dev·Apr 16 · 5 min readDesigning Scalable MongoDB Schemas: E-Commerce & Hospital SystemsIntro: Practicing Data Modeling Concept: Strategic Schema Design for Real-World Applications ✅ Model relationships, not just data: Use ObjectId references to connect independent entities (Users, Cat00
STSon Traninschemity.hashnode.dev·Apr 13 · 11 min readYou Have Been Reading ERD Notation WrongIf you have ever designed a database schema, you have probably drawn an ERD with crow's foot notation. You learned that a circle means optional, a line means mandatory, and a crow's foot means many. Y00
STSon Traninschemity.hashnode.dev·Apr 12 · 6 min readERD design with joyMost database tools treat schema design as a chore to be endured. What if the tool got out of the way - and let the thinking take center stage? There is a specific kind of friction that accumulates wh00
STSon Traninschemity.hashnode.dev·Apr 12 · 4 min readDesign Data Model for Multi-Tenant RBAC. Part 1: Identity FoundationBehavior Description Assume we are building a KPI management platform. Multiple companies can create accounts (tenants) and let their employees access the platform. A user can be assigned to one or s00
STSon Traninschemity.hashnode.dev·Apr 12 · 4 min readERD tool built for software engineers who touch a databaseIf you've worked on a team with more than two services, you've felt this pain. A feature needs a new table. You write the migration, apply it, ship the code. The ERD - if one ever existed - is now wro00
STSon Traninschemity.hashnode.dev·Apr 12 · 5 min readYour ERD is hiding your domain modelA raw column list tells you what the database stores. It doesn't tell you what the business means. Look at a status column of type TEXT. The schema says it's a string. It says nothing about whether "p00
STSon Traninschemity.hashnode.dev·Apr 12 · 6 min readYour ERD tool can't keep up with your thinkingYou are mid-flow. A schema idea is forming - three new entities, two relations, a junction table. You know exactly what you want. Then you reach for your ERD tool and the friction starts. Click to add00
STSon Traninschemity.hashnode.dev·Apr 12 · 7 min readThe ERD that lives in your Git repoYou exported a PNG. You pasted it into Confluence. Six months later, three tables have been renamed and two new ones added. The diagram is a lie. This is the default lifecycle of every ERD that lives 00
ATAnchal Tiwariinanchal-ai.hashnode.dev·Apr 10 · 4 min readWhy Your SQL is Right but Your Dashboard is Wrong: A Guide to Data GranularityThe Moment Every Analyst Dreads You’ve spent days on a SQL script. Your Power BI measures look flawless. You present the revenue dashboard to your stakeholders, only for someone to point out: "Our tot10
SGShivam Goyalinblog.shivam-goyal.site·Apr 4 · 11 min readBuilding a Production-Ready Multiplayer Chess App This blog explains the exact data and infrastructure stack used in this chess project: Redis for real-time game state PostgreSQL for relational and durable core data Cassandra/Astra DB for high-vol00
