Hacker News Reader

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.

View on HN

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

What tools would you use to instrument a sqlite file in order to monitor reads?

When 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-...

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 for an example of using triggers this way.

Reply on news.ycombinator.com