datum-cloud / datum

Datum's central server
https://datum.net
Apache License 2.0
51 stars 7 forks source link

[Feature Request] Manage migrations to `n` databases #797

Open golanglemonade opened 5 months ago

golanglemonade commented 5 months ago

Tenant databases need to have their database schema up to date with the main datum database. We recently moved to goose migrations, which runs the migrations on the container startup of the datum service; We have a few options to keep those up to date - either doing a similar thing across all database connections; or using the parent schema functionality within turso

golanglemonade commented 1 month ago

We are no longer targeting Turso/sqlite for our main database. Instead we need to confirm this with Postgres