Re:Code in Database vs. Code in Application
by skyde on Monday July 11, 2022 @01:45AM
(#32052653)
while i admit it’s doable if using traditional SQL database it’s sadly not possible with newsql and noSQL databases.
Also in my last 30 year working for different industries, it’s extremely rare that DBA write unit test or a proper deploy system to automatically rollback if anything break while changing database schema or stored procedure.
the best DBA i have met use Liquibase or something similar to treat database code like app code. But this is the exception not the norm.
Also in my last 30 year working for different industries, it’s extremely rare that DBA write unit test or a proper deploy system to automatically rollback if anything break while changing database schema or stored procedure.
the best DBA i have met use Liquibase or something similar to treat database code like app code. But this is the exception not the norm.