Databases: Beyond SQL
Ever pushed code to production and immediately regretted it? Yeah, me too. The difference between a hobby project and a real application isn't just adding users, it's designing your database like your reputation (and wallet) depends on it. Because they do. This post walks through my mental shift from "just make it work" to "make it work at scale without bankrupting me or getting sued." Spoiler: it starts with asking the right questions before writing a single line of SQL. Databases, our trusty data store. My first experience with databases came through working on Farmsah (Farm Management Platform). For Farmsah, I needed a place to store farms, crops and other relevant values. I came across SQL vs NoSQL, I chose Postgres, installed it and started with my SQL. "CREATE DATABASE farmsah;" A similar approach was taken for tables, and so on. Looking back, I'm still proud of that approach. It works for personal projects and is an e...
