2 ms·
mvSQLite looks great, though I’m curious how you’d implement a schema migration given the locking properties of SQLite combined with the transaction limits of f
by endisneigh 4y ago
mvSQLite looks great, though I’m curious how you’d implement a schema migration given the locking properties of SQLite combined with the transaction limits of fdb.
I imagine you’d get an FDB transaction time limit error preventing any schema migrations with non trivial amounts of data.
- losfair 4y agoWe found a way around FDB transaction time limit. A mvSQLite transaction is not directly mapped to a FDB transaction (details in readme and wiki)
- endisneigh 4y agoI’ve read it - there’s still a time limit and so long schema migrations still would be an issue. Even without FoundationDB long schema migrations are problems.
- losfair 4y agoOnline DDL is now a WIP feature. This will allow to convert DB into read-only mode & run arbitrarily large schema migration concurrently (first stage), and eventually fully concurrent DDL by replaying logs.
- endisneigh 4y agoThat sounds very promising. Excellent work with the project!