4 ms·
What tools would you use to instrument a sqlite file in order to monitor reads?
by nostoc 6y ago
What 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.