Generally speaking, sqlite3 is better at reading data than writing data.
But in the recent years, sqlite3 has become good also at writing data and preserving good read speeds; However: for that the "Write Ahead Log" has to be enabled.
From what I understand, it can be enabled using a PRAGMA statement. But since PRAGMA statements are per connection, it may be necessary to e.g. adjust the build flags of better-sqlite3 for enabling WAL mode
Deliverables
Go to better-sqlite3's docs and find out how to enable WAL mode permanently
Adjust the strikedao better-sqlite3 implementation such that WAL mode is enabled
Scope
Deliverables
Time estimates
2h