![]() It is an integer at a fixed offset in the database file. ![]() SQLite offers the user_version pragma, to keep track of these versions. The migration from version 1 to version 2 add the bicycle table. In our example, version 1 would have only the car table and version 2, also the bicycle table. To keep track of the different versions of the schema, some libraries maintain an internal table with a single row with a version number. Your application could start with a car table to represent a car but later on, you realize you want to represent bicycles, so you add a bicycle table. The database’s schema can evolve over time. Note that the OS cache is already keeping parts of the database file in RAM, so this might end up wasting memory.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |