Re:What ORMs have taught me: just learn SQL (2014)
by sitharus on Sunday June 26, 2016 @05:44PM
(#11982899)
Yes, there are tools to do this. It varies by database server and may need custom integration with your deployment system but they definitely exist.
The alternative is the old StoredProc_v1, StoredProc_v2 etc in the database and have the application check what's available. This allows you to roll the parts independently.
The big advantage with stored procedures is they can benefit from the DBMS caching and applying additional optimisations (depending on the DBMS of course).
The alternative is the old StoredProc_v1, StoredProc_v2 etc in the database and have the application check what's available. This allows you to roll the parts independently.
The big advantage with stored procedures is they can benefit from the DBMS caching and applying additional optimisations (depending on the DBMS of course).