You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Treat your database or other storage system as a code
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