SQLite 3 cannot read edits of database

Asked Dec 04 '20 at 21:42

Active Dec 05 '20 at 08:16

Viewed 62 times

I am writing a very simple Go app that uses sqlite 3 and during testing I noticed that when I insert a new row into the database with i.e. SQLPro, while the app is running, this app won't notice the new data.

For testing purposes I tried running sqlite3 via command line and adding the data via SQLPro, and still, the select could not show the data that was added to the database after opening it.

Is there something I'm missing?

edited Dec 05 '20 at 08:16

Jonathan Hall

75,165
16
143
189

asked Dec 04 '20 at 21:42

DomeWTF

2,342
4
33
46

2

Did you remember to commit? – Mureinik Dec 04 '20 at 21:51
Yes, the save is done and if I relaunch my app, it reads it correctly. (Closing the db connection and reopening it) – DomeWTF Dec 04 '20 at 21:52
1

https://stackoverflow.com/a/23350768/4466350 – Dec 04 '20 at 22:40

SQLite 3 cannot read edits of database

0 Answers0