I recently made an iPhoneProgram, You need to use the database, so you are too lazy to learn core data, so you simply use the SQLite database.
I used Lita (http://www.dehats.com/drupal? Q = node/58) Create a database, and then use nsfilemanager to copy the database in the project to the document directory in the program sandbox on the device, the database in the sandbox is different from the size of my original database! In a previous post ([Android] How to import an existing external database), someone also replied that there was a problem with the size of the imported database..
So I think there may be a problem with the database, but I have spent a lot of effort to build the database. What should I do?
1. Click Export dB to export the database to an SQL statement.
2. Use sqlite3 to create a new database, and then copy and execute the SQL statement.
Sqlite3 dbname. DB
3. Try importing again. No problem. It seems that it is indeed a database problem, and it is difficult to create a manager.
However, the manager must be easier to use than the command line. In the future, use the manager and then use the command.