{"repo":"mgramin/database-as-code","free":true,"listed":false,"github":"https://github.com/mgramin/database-as-code","clone":"git clone https://github.com/mgramin/database-as-code.git","description":"Treat your database as Code","language":null,"stars":118,"topics":["database","sql"],"license":"CC0-1.0","category":"databases-storage","readme_excerpt":"The \"Database as Code\" Manifesto We believe that we can interact with our databases and storage (including queries, administration and the entire DB lifecycle) as if they were plain code. And we call it - \"Database as Code\" (such as \"infrastructure as code\", \"configuration as code\", \"pipeline as code\" and so on). Base principles: - All changes and operations with the database and all queries (ideally) against the database should be expressed as a plain old code - Git (or anything else VCS) is a single source of truth for database code - SQL actually is a main database language supported by almost all DBMS - SQL is not a bytecode for your data and your database, it's a normal human-oriented program language (why) - SQL is designed not only for data, but also for metadata - Database code is not only DDL and other migration scripts, DML and all kinds of SQL scripts too - Database code is a normal code, and it also needs static analysis, code review (especially by DBA, analysts and business people) , tests and automation of it all - DBAs and data people should be integrated with Dev and Ops - Ability to release on demand. Resources: - Database as Code: a Novel Concept - Database as Code - the Good, the Bad and the Ugly - The Database Inside Your Codebase - Database as Code. Not only migrations Talks: - Aren't we forgetting someone? (slides) - Database as Code. Not only migrations (video, slides) Tools: - Liquibase - database schema change management solution and standard realizat","default_branch":null,"files":null,"tree":[],"storefront":"/r/mgramin","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/mgramin/database-as-code/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}