@larry0x
In our experiments, sqlite had significantly worse performance than rocksdb, leveldb and pebbledb. Rocksdb had the best performance, but the convenience of being able to write sql queries is nice.
If querying historical data is not on critical path then a query server