3 ms·
Then you have to keep your database and those files in sync. There are tools that help with this, but it's no longer as simple as redeploying your code.
by astine 12y ago
Then you have to keep your database and those files in sync. There are tools that help with this, but it's no longer as simple as redeploying your code.
- knodi123 12y agoit's certainly that simple in my deploy script.
- thirsteh 12y agoNot really. The program can define the stored procedures on startup.
- NickNameNick 12y agoThat tends to hurt a lot when you have multiple front ends, and in general, I don't like the front end to have that much access to the database.
- spacemanmatt 12y agoOrganizations I've been with have always preferred to keep the revenue app out of the schema-maintenance business.
- brlewis 12y agoYou keep them in sync by only deploying from those files, exactly the same best practice for deploying any software.
- NoMoreNicksLeft 12y agoA couple of weeks ago I asked the Sequelize people why they couldn't also copy their validators into the database. The validation would still happen on the node app side of things, but when it generates the create table query (as it must) it could easily also put in the equivalent check constraint. Waiting on an official answer.