I sometimes wonder how much of this objection to SQLite is purely technical, and how much is due to the fact that Dr. Richard Hipp would not exactly be a great "cultural fit" at places like the New York Times or Mozilla.
I would guess that at most 1 in 50 people familiar with SQLite even know Dr. Hipp's name, much less anything about him that might influence their perception of his work.
For every technology there are scenarios in which it is a poor fit.
You don't want to install Postgresql or Oracle on an embedded system nor would you want the extra weight of administering them for a system that has few users.
The SQLite site runs on SQLite and it has considerable traffic.
> The SQLite site runs on SQLite and it has considerable traffic.
The forum and source code trees run on sqlite (via the Fossil SCM, authored by sqlite's Richard Hipp). The main sqlite site is static HTML with a tiny sprinking of JS.