Re: Nuts to them all. MongoDB is web scale.
I’m old, so I used SQLite with bash, C, and Python. I found it particularly useful when "tidying up" CSV data that I generated from luser Excel "databases". A dirty secret is that most (95+%?) of the data driven websites out there could probably use it (sqlite.org):-
Generally speaking, any site that gets fewer than 100K hits/day should work fine with SQLite. The 100K hits/day figure is a conservative estimate, not a hard upper bound. SQLite has been demonstrated to work with 10 times that amount of traffic.The SQLite website (https://www.sqlite.org/) uses SQLite itself, of course, and as of this writing (2015) it handles about 400K to 500K HTTP requests per day, about 15-20% of which are dynamic pages touching the database. Dynamic content uses about 200 SQL statements per webpage. This setup runs on a single VM that shares a physical server with 23 others and yet still keeps the load average below 0.1 most of the time.
Biting the hand that feeds IT
