I recently came across a section in the book "Using SQLite" by Jay A. Kreibich where he mentions[1] the `SQLITE_OMIT_*` compile-time directives.<p>> Using the default configuration, the compiled SQLite library is less than 700 KB on most platforms, and requires less than 4 MB of memory to operate. By omitting the more advanced features, the library can often be trimmed to 300 KB or less. With minor configuration changes, the library can be made to function on less than 256 KB of memory, making its total footprint not much more than half a megabyte<p>While this sounds promising, I'm struggling to find any discussions or blog posts on the use of these directives. Has anyone here tried them?<p>[1] https://www.oreilly.com/library/view/using-sqlite/9781449394592/apas08.html
Yes, I've used them quite extensively. They work. There's not really much that I found in terms of gotchas about them, as long as you are aware of whether or not you actually need something you're wanting to omit. Sometimes you do when you don't think you do.