Add DB migrations support to 0x API

Open fabioberger opened this issue 5 years ago • 2 comments

We currently do not have a way to perform graceful DB migrations. This led to us having to drop the SignedOrderEntity table when updating the expiration_time_seconds column to varchar, instead of gracefully migrating the values over to the new type.

Feb 04 '20 10:02 fabioberger

Thanks for making this! Maybe a migration is a bit much for now because all the data is available in Mesh (DB just a cache / query layer), but we do want to avoid having to connect to the prod database and running manual queries etc... as the staking data is valuable and stateful (the events-pipeline image does do migrations for that).

Feb 04 '20 18:02 fragosti

Hello guys sorry haven't responded in time to complete this project do to some personal information issues, but as the correct owner and holder I will love to move on with the project with this team so please contact me and let get the project going thanks.

Jun 17 '22 07:06 GeneralWiszy