At my last job I worked on a monolith that sat on top of a NoSQL database. Our DAOs were fairly simple beasts that did mostly CRUD operations and some non-trivial finds. For the vast majority of data, ...

Excel possesses formidable database powers. Creating a relational database starts with a Master table that links it to subordinates, called (awkwardly) Slave, Child, or Detail tables. Before we dive ...

Airtable is an online platform for creating, using, and sharing small relational databases. It’s not ready for enterprise users yet (that’s coming), but right now, if you want help managing data for ...

Just as it is wise to design a house before building one, it's also prudent to plan your business database before putting it on your website. Databases can appear deceptively simple and cause you to ...

Good software habits apply to databases too. Trust in these little design tips to build a useful, rot-resistant database schema. It is a universal truth that everything in software eventually rots.