SQLite has excellent read performance. Insert / update performance is quite another story: https://stackoverflow.com/a/48480012 https://stackoverflow.com/a/484

SQLite has excellent read performance. Insert / update performance is quite another story: https://stackoverflow.com/a/48480012 https://stackoverflow.com/a/48480012 Even in WAL mode, one should remember to use BEGIN CONCURRENT and be ready to handle rollbacks and retries.