3 ms·

Those are awesome tips. I didn't even think of using "user_version" for storing a migration version. I'm definitely stealing that trick.

• jitl 6y ago
  This is how we manage SQLite migrations in Notion’s native apps.
• lrossi 6y ago
  This blog post gives a nice example of how that could be implemented: https://levlaz.org/sqlite-db-migrations-with-pragma-user_version/ https://levlaz.org/sqlite-db-migrations-with-pragma-user_ver...