2 ms·
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 serve
by faangguyindia 3mo ago
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
- fsuts 3mo agoHow are lobster.rs handling writes? Are they queuing them synchronously?
- Cthulhu_ 3mo agohttps://sqlite.org/wal.html https://sqlite.org/wal.html presumably.
- fsuts 3mo agoBut 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
- scrlk 3mo agoSQLite with WAL on a standard NVMe drive will easily do thousand of writes per second.