OP here. This is a collection of app-level and library-level SQLite optimizations I've come across over the years, working with SQLite on various platforms. SQLite itself is great, but there is often a lot overhead added by higher-level libraries/bindings. This post discusses both performance optimizations ideally implemented in libraries, as well as options like JSON1 operations that could be used to make operations efficient even when the library is not.