Comment on SQLite Is All You NeedparentComments−fsuts1moHow are lobster.rs handling writes? Are they queuing them synchronously?−Cthulhu_1mohttps://sqlite.org/wal.html presumably.−fsuts1moBut like any message board it will get peak time hitsSo lunchtime in America there will be multiple people posting comments at the same timeAnd Sqllite only allows one writer, so what happens if multiple people send their comments at onceSo are they using ultra fast storage on the host or queues or other−scrlk1moSQLite with WAL on a standard NVMe drive will easily do thousand of writes per second.
Comments
How are lobster.rs handling writes? Are they queuing them synchronously?
https://sqlite.org/wal.html presumably.
But like any message board it will get peak time hits
So lunchtime in America there will be multiple people posting comments at the same time
And Sqllite only allows one writer, so what happens if multiple people send their comments at once
So are they using ultra fast storage on the host or queues or other
SQLite with WAL on a standard NVMe drive will easily do thousand of writes per second.