[jhgg]

A bit more literature on the N+1 situation in SQLite: https://www.sqlite.org/np1queryprob.html

[avolcano]

Thanks for linking this! It intuitively made some sense to me (no IPC/network overhead) but neat to see them point this out as an intentional advantage.