SQLite with WAL on a standard NVMe drive will easily do thousand of writes per second.