include a migration routine for databases

[aeneasr]

No description provided.

[janekolszak]

I think all database code should be in a separate folder, in separate sql scripts. All tables in one place.
First script would be 001-create-db.sql. When there's an update we add a script 002-some-update.sql
In order to create the database hydra would:

• create transaction
• run scripts in order
• commit

In order to update the database schema hydra would:

• create transaction
• run scripts from the updated version to the latest
• commit

If hydra does this automatically we get rid of the problematic (for user) schema updates.

[aeneasr]

a list of sql migration tools:

• https://github.com/DavidHuie/gomigrate
• https://github.com/rubenv/sql-migrate
• https://github.com/mattes/migrate

[meyerzinn]

I highly recommend migrate--you can see a great usage of it here.

[aeneasr]

awesome, thanks!

[aeneasr]

see 070520d