Hacker News new | ask | show | jobs
by qbasic_forever 1437 days ago
Are you sure you want to use sqlite if your workload is mostly multiple, independent writers?
1 comments

Yes because I want to do offline sync (i.e. latency between syncs anything between 1 second and 1 week), yet index and query the current local state (which includes previously synced items).

If this sounds like an append-only log that's precisely correct; I just want it to work efficiently with fixed memory and ideally as an embedded library. Thus sqlite.