Jasmin Fluri

@jasminfluri.bsky.social

Database DevOps Engineer / Consultant - schaltstelle.ch Oracle ACE - @oracleace.bsky.social Sym42 Member - @sym42.bsky.social Cyclist and Mountaineer 📍🇨🇭

Giving your app direct access to database tables means Increased risks for schema changes A heavy maintenance burden @jasminfluri.bsky.social discusses how accessing views & stored procedures instead gives Encapsulated schema changes Security & governance Improved versioning

What is an Anti-Corruption Layer in the Database and When Do You Need It?

Without an Anti-Corruption-Layer (ACL), direct database table access leads to tight coupling, increased risk of breakage on schema changes…

buff.ly

Database management is more than persistence. Beyond persistence, a DBMS also provides access rights (GRANT), schema enforcement (types, constaints), schema evolution (ALTER), concurrency control (TX isolation, deferred constraints), a query language… Persistence is simple, DB managemant is hard.

Database deployments can fail But rolling back schema changes is tricky - so plan them @jasminfluri.bsky.social runs through options Versioned Migrations with Reversible Scripts Backups before Changes Immutable Migrations & Forward Fixes Restore Points & Flashbacks

Database Rollbacks in CI/CD: Strategies and Pitfalls

Database rollbacks would be incredibly valuable and essential if we want quick fixes for failed deployments. But they are rarely feasible.

buff.ly