A key feature of datasette is that the API it provides is very deliberately read-only. This provides a number of interesting benefits:
- It lets us use SQLite in production in high traffic scenarios. SQLite is an incredible piece of technology, but it is rarely used in web application contexts due to its limitations with respect to concurrent writes. Datasette opens SQLite files using the immutable option, eliminating any concurrency concerns and allowing SQLite to go even faster for reads.
- Since the database is read-only, we can accept abritrary SQL queries from our users!