"Sqlite is finally a database product that values performance and minimal footprint (disk and memory) above a trashcan strategy that would add whatever feature to make so-called 'feature rich' result a bloated piece of software."
YES! This comment, from the wiki "sqlite - Unsupported Sql" page, slightly reworded for clarity, says EVERYTHING about what I'm coming to like about the product. /Thank you/, DRH, for your work on this product, for generously giving it to the rest of us. Not only have you produced what seems to be a fine product (I'm only in the initial stages of exploring it), but your documentation is a model of complete- ness and clarity. I use Delphi, not C, but I have to say that had I been exposed to more examples of such well-structured and thoroughly commented C code I may have been using C as well. I've been unable to find a Delphi interface to SQLite which easily and simply does what I want without misbehaving, either in operation or upon attempted compilation. As is so often the case, under these circumstances the Do It Yourself notion will arise. Usually one look at the product in question is enough to disabuse us, as the product is so bloated and poorly documented that writing something from scratch in native Delphi would not be much harder. SQLite is exceptional! The more one looks at the copious code comments and accompanying documentation, the simpler it looks. There oughta be a rule: If your documentation is not longer that your code, the project is underdocumented. This would ensure quantity even if not quality, but it would be a start. Fortunately, SQLite has both. Thanks again, DRH.
