They store everything in an SQLite db :)

https://github.com/mediar-ai/screenpipe/blob/4f2391c6dfd8775...