Home

SQLite

Schema describes a SQL schema for libbitcoin's wallet database use case.

Queries goes over the various queries we'll need to provide for libbitcoin-node to work with a SQLite database.

My conclusion is that without a hash index in SQLite and with the large output/prevout tables, a SQL database will be a bit problematic to scale for user machines.

We can try a partial index on inputs to limit the size of the index. But the association table between outputs and inputs will simply be too large. Unless we purge that table too. So that only unspent outputs are tracked in the association table.