upgrade my preloaded database for app update about grdb.swift HOT 8 CLOSED

There are similar but but not identical concepts in GRDB. The similarities are about running upgrading code when needed, in order to upgrade the database to its latest scheme version. The differences are in the support for database assets: GRDB has none, or more specifically: it lets the resources/documents management to the application developer.

So.

If your application has a bundled database that may be modified by the user or later versions of your application, you need to know the difference between an application resource (immutable), and other mutable files. Check how to copy a database resource into the documents folder, and understand what this sentence means.

Next, versioning. SQLite comes with the user_version pragma, which you can simply query with let version = Int.fetchOne(db, "PRAGMA user_version")!, and set with db.execute("PRAGMA user_version 42").

GRDB also comes with another versioning tool that has my personal preference over user_version, called migrations. Check them out, you may like it.

OK now. I hope this first answer has some food for you!

from grdb.swift.

Looks like db.execute("PRAGMA user_version = 42) is working instead of db.execute("PRAGMA user_version 42")

from grdb.swift.

Hello @gitton. I'm not sure I understand the scope of your question. Is it about GRDB, about SQLite, or about the architecture of your application?

from grdb.swift.

This is about GRDB. I am new to swift, from android background. In android there is library called android-sqlite-asset-helper (https://github.com/jgilfelt/android-sqlite-asset-helper) in that there is a concept called database upgrade version (https://github.com/jgilfelt/android-sqlite-asset-helper#database-upgrades) i am looking to do similar in GRDB.
Thanks for this library so far this is really cool 👍

from grdb.swift.

Hello @gitton. Did you find your way in this maze?

from grdb.swift.

OK. I'm closing this issue since it does not look like it is still relevant to you. Please open a new one if you have another question.

from grdb.swift.

Sorry for the late response .it Works
Thank you 👍

from grdb.swift.

Great! Happy GRDB!

from grdb.swift.