Here's how I built Fusionaly's internals on a single SQLite file. SQLite allows one writer at a time, so I split the connections into two pools.
The write pool has one connection. Ingestion does one tiny INSERT into a queue table and returns 202. Every write waits its turn for…
Commit
8772f27
Here https://fusionaly.com/docs/how-it-works/ you can find more details if you are interested.
Are you a SQLite perf geek like me? Help me making it faster: https://github.com/karloscodes/fusionaly-oss/
fusionalyHow It WorksHow Fusionaly keeps your analytics in one SQLite file, why most of the dashboard reads summaries instead of raw events, and what it costs in speed and disk
commit 8772f27