I wish there were different recommended configurations for SQLite when used as the backend of a web site versus the storage format for an embedded system. The d

I wish there were different recommended configurations for SQLite when used as the backend of a web site versus the storage format for an embedded system. The defaults are really not suitable for concurrency or for tables with millions of rows. Also I wish I didn't have to recompile to enable sqlite_stat4 histograms. SQLite doesn't have materialized views.