4 ms·
Further, it's a SQLite database. It's not like it's hard to check this behavior, or instrument the database file to see exactly what it's doing. It was really
by banana_giraffe 6y ago
Further, it's a SQLite database. It's not like it's hard to check this behavior, or instrument the database file to see exactly what it's doing.
It was really odd they didn't bother.
https://imgur.com/a/jBaW7RL https://imgur.com/a/jBaW7RL
- nostoc 6y agoWhat tools would you use to instrument a sqlite file in order to monitor reads?
- TeMPOraL 6y agoWhen Julia Evans wanted to learn what SQLite does, she just stuffed some printf calls into the code and rebuilt it :). https://jvns.ca/blog/2014/09/27/how-does-sqlite-work-part-1-pages/ https://jvns.ca/blog/2014/09/27/how-does-sqlite-work-part-1-... You could do similar at API entry points. Or, if you're after writes, it would be simpler to attach an "on insert/update" trigger that just records the changes in another table. See https://www.sqlite.org/undoredo.html https://www.sqlite.org/undoredo.html for an example of using triggers this way.