“For anything related to data management or data models, move it to your database as procedures or queries.”
Don’t know if I agree here. It’s difficult to source control SQL procedures/functions when they live in the database.
Your SQL schemas should be declarative. Set them to reapply on every deploy and store them as .sql files.
We're a place where coders share, stay up-to-date and grow their careers.
We strive for transparency and don't collect excess data.