[faangguyindia]

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]

How are lobster.rs handling writes? Are they queuing them synchronously?

[Cthulhu_]

https://sqlite.org/wal.html presumably.

[fsuts]

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

[scrlk]

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