![]() Once I get hold of him it should be easy enough to diagnose and fix as he's comfortable with Terminal and the sqlite3 CLI. I expect that some column I want to add is, now, already in a table. Unfortunately it seems I broke my update procedure for his set of databases and now he can't update to the next released version. However, recently a user had an unrelated problem and I gave him an unreleased version to test. This is all done in the app startup, and normally works without issue. ![]() ![]() So far I've been doing that by checking a value stored as a data-version-number in a globals table in a database, and when necessary I bump that number and execute a number of ALTER TABLE ADD COLUMN statements as required. From time to time, as I add new features, I need to add columns here and there to some tables. I have an app that I distribute, which uses various SQLite databases. I'm looking for a robust way to solve this.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |