ios7 sqlite database with WAL never syncs the main database file
To move the WAL data to the database file, open the database file and execute the SQL statement PRAGMA wal_checkpoint(RESTART).
$ sqlite3 yourFile.sqliteSQLite version 3.7.12 2012-04-03 19:43:07Enter ".help" for instructionsEnter SQL statements terminated with a ";"sqlite> PRAGMA wal_checkpoint(RESTART);0|20|20sqlite> .exit$