Reading Data In Wal Mode

[sahin52]

trafficstars

I created a new sqlite db with C# .Net Core EF Core.
I can add/read data without a problem. But much of the data is not shown in this extension, because the db is in WAL mode.

I can read data with sqlite3 cli (https://sqlite.org/download.html -> sqlite-tools-win32-x86-3430100.zip) But the data is old in this extension because of WAL mode

I couldnt figure out how to disable wal mode either

[sahin52]

I found a solution, but the issue still continues. For the people with the same problem, go to sqlite cli tool, or any other tool that you can write sql commands Run this command: PRAGMA journal_mode=DELETE; The sqlite database will turn into delete mode, which will disable wal and shm files, and show the data in the database, which will make you see all data with this extension

[pekeler]

Same. I wish this plugin supported reading DBs with WAL.

[git-nico]

Yes, WAL support would be greatly appreciated

[dourgulf]

Yes, want WAL support!

[qwtel]

I wish this plugin supported reading DBs with WAL.

~I wish it did too lol. Unfortunately it's not a simple fix~. I've written down what I know in a Discussion in case someone wants to get into the technical nitty-gritty: https://github.com/qwtel/sqlite-viewer-vscode/discussions/55

[qwtel]

I found a mostly simple fix after all. You can try it out using the v0.5.0 pre-release. You'll have to go to extensions, find SQLite Viewer and click "Switch to Pre-Release Version".

Please let me know if you encounter any issues. If it works as expected, please give this post a thumbs up or let me know some other way.

Getting this to work required quite a bit of restructuring as well as a custom SQLite VFS. There's potential for some unforeseen breakage.

[qwtel]

Shipped on main channel in v0.5.5