Using SQLite

What Hacker News says

1. at_a_removeJan 2020
   They are The Definitive Guide to SQLite by Mike Owens and Using SQLite by Jay A. Kreibich. I am quite sure they are more book than I needed, I only plumbed a fraction of SQLite's immense capabilities.
   thread
2. tester457Aug 2023
   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.

   > 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

   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?

   [1] https://www.oreilly.com/library/view/using-sqlite/9781449394592/apas08.html

   Show morethread