SQLite's user_version pragma for schema versioning

This site does not allow itself to be embedded. You can still read it on the original site — the toolbar below keeps your place in the directory.

While reading through SQLite's PRAGMA statements page I stumbled upon the user_version pragma. The description says this: The user-version is an integer that is available to applications to use however they want. SQLite makes no use of the user-version itself. I immediately thought about using it to store the database's current schema version and wasn't surprised to discover I'm not alone ! // get…

Read on gluer.org ↗