Appropriate Uses for SQLite

I teach SQL to non-techie students. I used to give the the option of doing either MySQL or SQLite, but not only did I underestimate how different the syntaxes were, I also underestimated how not-trivial it is for students to successfully install and run both the MySQL server and client. These are students who can't even use a spreadsheet well, not that that makes a huge difference in understanding databases. I've moved everything to SQLite and couldn't be happier. Not…

This is one of my favourite technical sites. It is very clear and to the point about its good use cases while being clear where an alternative would be a better choice. In a similar vein, VueJS has a comprehensive exploration/comparison of itself compared to other frameworks[0]. I really appreciate open source maintainers that have the humility to compare their work fairly with others within the domain while still taking pride in their own acheivements. [0]: https://vuejs.org/v2/guide/comparison.html

"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. Each dynamic page does roughly 200 SQL statements. [...]" Wait... What? They're saying that their dynamic pages are executing 200 SQL statements per request? Off-topic: I enjoyed reading this article which was posted here a while ago http://www.sqlite.org/testing.html