Hacker News Reader

Is the CGI process opening up the SQLite database for every request...? That would have the most insane contention ever.

Would it? The file handle doesn’t contend for a lock IIRC; just writes.

I mean sure, you could still win if almost no requests are opening the database in write mode

Does it lock if the DB is opened in write mode, or only when a write query is issued?

If the latter, then it’ll only contend on simultaneous writes, which mutex anyway.

I think you severely underestimate the speed of sqlite + nvme.

These things usually get 1 visitor per month and it’s Googlebot

fortunately AI (scrapers) have solved this problem so now you'll have no end of traffic