Comment on SQLite Is All You NeedComments−faangguyindia1molobster.rs also started using sqlite, i've been using exclusively using sqlite for most of my projects.apps appear much faster because db is on the same server−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
lobster.rs also started using sqlite, i've been using exclusively using sqlite for most of my projects.
apps appear much faster because db is on the same server
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.