Any site with real volume will have a connection pool. All of those connections might need to write, and this is where SQLite gets tricky to implement at scale

Any site with real volume will have a connection pool. All of those connections might need to write, and this is where SQLite gets tricky to implement at scale. I love SQLite! It's perfect for many use cases, but not all. Fortunately, Postgres is also excellent.