Had no idea about joining across multiple databases! Hot tip! Yeah, you can drastically increase write throughput by just having extra SQLite databases.. Examp

Had no idea about joining across multiple databases! Hot tip! Yeah, you can drastically increase write throughput by just having extra SQLite databases.. Example pattern: * main.db * sessions.db * analytics.db * cache.db Will 4x your writes. Combined with a modern nvme drive, you begin reaching crazy fast write throughput which you'd require far more traditional database nodes to achieve, but on a single machine.