3 ms·
Worth mentioning that the author speculates that this happens not for a nefarious reason, but in a binary tree search to locate your zoom cookie.
by ppezaris 6y ago
Worth mentioning that the author speculates that this happens not for a nefarious reason, but in a binary tree search to locate your zoom cookie.
- banana_giraffe 6y agoFurther, 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.