3 ms·
I think, I found a good use case for this. I'm running an gateway that uses a SQLite database to index transaction data. One instance loads all TXs and indexes
by k__ 3y ago
I think, I found a good use case for this.
I'm running an gateway that uses a SQLite database to index transaction data. One instance loads all TXs and indexes them to SQLite and LiteFS replicates the database to other instances.
Down-side: there are copies of the database on every machine.
Up-side: Saves work, since only one machine needs to index and reduces latency for reads, as every machine reads from a local SQLite replica.
Bonus: LiteFS Cloud keeps backups of the database.