Document databases such as MongoDB garnered rapid and strong support from application developers for multiple reasons. But clearly, one of those reasons is the support for flexible schemas. In the ...

You are creating a database from scratch for an application This application will have multiple siloed environments (PROD, TST, INT, DEV) Data from PROD will nightly be moved to the other environments ...

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.

For example, the default option is to create a database initializer class that inherits from CreateDatabaseIfNotExists. With this option the first line of code that accesses the database triggers the ...