[wormlord]

I don't know how it works exactly, but I believe you can have a fully in-memory SQLite database. Bun's sqlite library and SqlAlchemy both let you operate on in-memory SQLite db's which you can then write to disk.

Edit: reading the docs it looks like it operates the same way, just reading sections of the db from memory instead of disk

https://www.sqlite.org/atomiccommit.html

[gwbas1c]

You can, but that's not the point. I basically asked if they should (gasp) write code that did the lookup.

See the other response from the article's author.