Repository navigation
After updating a row changes not reflected in browser. #998
Description
After updating the row in my database with my own script, and despite my database actually is updated with the correct data, when I view the database in sqlite browser the changes are not reflected. I deleted the original database from everywhere and restarted and I get the same results.
If I uninstall sqlite browser and reinstall, then the changes appear, tried to uninstall again and this time it didnt even work the changes do not appear.
Activity
justinclift commentedon Apr 22, 2017
Interesting. A couple of questions, just to get a better idea of things... 😄
The answers to those should help us figure out what's going on. 😄
nextdimension commentedon Apr 22, 2017
Result is always the same: DB4S is not showing the updated data.
Does it not work like this? Can I not pull the database to local storage and view updates?
justinclift commentedon Apr 22, 2017
In theory (!) it should work. But for some unknown reason, Android devices are occasionally reported to not copy database files correctly. (not just for us, but in general)
It's been going on for a few years now, so there's a decent chance someone has worked out a solution or fix to the problem. I don't use Android, so it's not something I've ever really come across myself. (sorry)
Someone else here might have some ideas though... 😄
chrisjlocke commentedon Apr 23, 2017
What's ADB?
On what platform are you using DB4S? (not that that makes a huge difference, but just in case...)
If you amend the database, does the file have an updated modified date?
justinclift commentedon Apr 23, 2017
ADB → Android Debug Bridge: https://developer.android.com/studio/command-line/adb.html
justinclift commentedon Apr 23, 2017
This may be the problem:
https://stackoverflow.com/questions/9058169/sqlite-database-disk-image-is-malformed-on-windows-but-fine-on-android
As pointed out by @MKleusberg last year.
nextdimension commentedon Apr 23, 2017
nextdimension commentedon Apr 23, 2017
Yep it because of WAL mode. When disabling WAL mode everything works great, all updates are reflected just fine when exporting the database from my device. Thanks for the help.
So DB4S does not support WAL mode?
justinclift commentedon Apr 23, 2017
DB4S itself definitely uses WAL.
That being said, it's sounding like there's a bad interaction with DB4S + WAL + ADB. We might be the culprit, or we might not (no idea). At least there's a workaround for now though. 😁
quantuminformation commentedon Nov 17, 2023
I'm not seeing any updates when clicking refresh
chrisjlocke commentedon Nov 17, 2023
@quantuminformation - how did you update the data - via another process? An external program?
Do you mean data updates or schema updates?
If another program has updated the data, sometimes changing tabs can help. Or changing table to a different table and back again.
quantuminformation commentedon Nov 17, 2023
I have a node process that updated the db
data only updates if i reconnect to the db:
https://youtu.be/HN1zJzhr7wY?t=83
chrisjlocke commentedon Nov 17, 2023
Well, that kind of makes sense - sqlite isn't a multi-user system, so it caches bits in memory. If you go to the 'execute sql' tab and issue a statement, that would be up to date when you press F5 (or re-execute) the statement as that physically pulls the data back from the database. The 'browse data' tab caches data in the grid so probably isn't what you're after.
quantuminformation commentedon Nov 17, 2023
ok thx