4 ms·
from TFA: Spend the time to migrate scripts from local locations to global locations, eliminate views, materialized views, and stored procedures. Wow. So thin
by Wicher 5y ago
from TFA:
Spend the time to migrate scripts from local locations to global locations, eliminate views, materialized views, and stored procedures.
Wow. So things will be better if we don't use the modularization you can get through views? I've just finished up a tool* to make it easy to keep code for SQL views in VCS, but I must have been thoroughly misguided ;-)
*) https://pypi.org/project/DBSamizdat/ https://pypi.org/project/DBSamizdat/
- xupybd 5y agoYeah I'm with you on this one. I think they keep these in code so that they can deploy over multiple databases. But I think this should be seen as a schema change. If you make a change to a view, materialized view or procedure you need to store that change in git and deploy it out to all instances via a migration tool.