In my experience, SQLite has excellent performance if you use it correctly. It can easily do 10k to 500k inserts/second, depending on the workload. SQLite only

In my experience, SQLite has excellent performance if you use it correctly. It can easily do 10k to 500k inserts/second, depending on the workload. SQLite only supports a single writer at a time, but does support concurrent reads. There is also an experimental branch that supports concurrent writes.