Quote Originally Posted by dilettante View Post
Fair enough.

But the average VBer is probably still going to be far better off using a wrapper library like yours, or one of the ODBC or OLEDB wrappers.
Yep, that's the "raw" SQLite-lib which is now contained - so, for comfortable access
(e.g. Auto-UTF8-to-VBString-conversions, or typed ResultSet-delivery in a nice Object-Container)
one will need a "translating" COM-Layer in-between... (meaning ADO/OleDB or ADO/ODBC
or for those who want to decouple entirely from MS-provided layers -> vbRichClient5, which
comes with its own "ADO-like usable replacement for Command and Recordset-Classes").

And as it seems, what ships and gets updated with Win10 will perhaps always be a few
more versions behind the most recent one.

I just find the MS-statement (commitment) remarkable and noteworthy - seems like they
have finally seen "the Lite" (not only with regards to SQLite - but also with regards to
their more open approach and policy to OpenSource-software in general).

SQLite *does* have some big advantages over the JET-engine (especially when we talk
about "interaction with Web-stuff" - which I find myself incorporating into my VB6-apps
more and more).

Olaf