Safe way to remove a WAL SHM from sqlite database

  1. 8 months ago
    Edited 8 months ago

    Hi,
    Could you please help me how can remove safely remaining -wal file and update thd database. When users close the browser instrad of normally close the app, i got -wal -shm files. Even then if i reopen the database using a sqlite manager or throug my webapp and close it, it still these 2 files are shown...

    db.MultiUser= False incorporates the WAL file into the database and deletes it.

  2. Christian S

    22 Jan 2019 Pre-Release Testers, Xojo Pro, XDC Speakers, Third Party Store Germany

    When closing database, the files should be removed automatically.
    Otherwise you can remove them, if they are old.

  3. Edited 8 months ago

    But if the -wal file exist and I want to make changes to database structure (eg add a table, delete a record etc) when then try to open the db through the app i got error (eg can’t find the new table etc).

    Also my question is that by re-opening the database through sqlite manager and immediately close it, the -wal and -shm files are still there... This is the reason for opening this conversation...

  4. Ulrich B

    23 Jan 2019 Pre-Release Testers, Xojo Pro Answer Europe (Germany, Berlin) · xo...

    db.MultiUser= False incorporates the WAL file into the database and deletes it.

  5. i have done it but did not see any difference but i will give another try to verify it

  6. Verified that this is the proper solution!
    Thanks a lot Christian & Ulrich

or Sign Up to reply!