Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Reading Data In Wal Mode #35

Closed
sahin52 opened this issue Sep 14, 2023 · 7 comments
Closed

Reading Data In Wal Mode #35

sahin52 opened this issue Sep 14, 2023 · 7 comments

Comments

@sahin52
Copy link

sahin52 commented Sep 14, 2023

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.
image

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

I couldnt figure out how to disable wal mode either

@sahin52
Copy link
Author

sahin52 commented Sep 14, 2023

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
Copy link

pekeler commented Mar 14, 2024

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

@git-nico
Copy link

git-nico commented May 1, 2024

Yes, WAL support would be greatly appreciated

@dourgulf
Copy link

Yes, want WAL support!

@qwtel
Copy link
Owner

qwtel commented May 11, 2024

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: #55

@qwtel
Copy link
Owner

qwtel commented May 18, 2024

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.

Screenshot 2024-05-18 at 23 59 59

@qwtel
Copy link
Owner

qwtel commented Jun 2, 2024

Shipped on main channel in v0.5.5

@qwtel qwtel closed this as completed Jun 2, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

5 participants