DevOps - Databases

DevOps - Databases, DB

Types of databases

https://www.prisma.io/dataguide/intro/comparing-database-types

Database schemas - growth, NOT breakage

https://blog.datomic.com/2017/01/the-ten-rules-of-schema-growth.html

1. Prod is not like dev.
2. Grow your schema, and never break it.
3. The database is the source of truth.
4. Growing is adding.
5. Never remove a name.
6. Never reuse a name.
7. Use aliases.
8. Namespace all names
9. Annotate your schema
10. Plan for accretion

Database schemas

• why
• design considerations

https://www.prisma.io/dataguide/intro/intro-to-schemas

Relational vs NoSQL

• ACID, BASE
• consider tradeoffs / drawbacks, not just benefits https://www.simplethread.com/relational-databases-arent-dinosaurs-theyre-sharks/

Dbmate - framework-agnostic DB migration tool

https://github.com/amacneil/dbmate