How do I get the latest version of SQLite?

[IliaPreston]

A couple of years ago, I got vbRichClient5.dll (that manages SQLite for VB6) from the following link:
http://www.vbrichclient.com/#/en/About/
Ever since then, this dll has not changed.
However, I know that SQLite has released many new updates since then. Currently it is version 3.23
But, when I run this query:

select sqlite_version()

on my SQLite database (which is managed by vbRichClient5.dll, it returns version 3.8.11.1
So, how do I get the latest version of SQLite?
Please advise.
Thanks.

[wqweto]

A couple of years ago, I got vbRichClient5.dll (that manages SQLite for VB6) from the following link:
http://www.vbrichclient.com/#/en/About/
Ever since then, this dll has not changed.

You cannot download RC5 from it's about page, better try from it's download page at http://www.vbrichclient.com/#/en/Downloads.htm

On the download page it says "current version: 5.0.66, last update: 2018-02-04" -- this is more recent that couple of year ago.

Note, vbRichClient5.dll is not going to auto-update -- you have to manually download the .zip, extract, register and subsequently distribute the required dlls with your solution.

Also note, that cConnection class has Version property (actually a function) that basicly does what your query is returning.

cheers,
</wqw>

[Schmidt]

"current version: 5.0.66, last update: 2018-02-04" -- this is more recent that couple of year ago.

Yep...

@IliaPreston
...also note that not only vbRichClient5.dll (a COM-binary containing the wrapper-classes) is available in newer versions,
but also that the "flat" vb_cairo_sqlite.dll (which the sqlite-sources are compiled into) is usually updated along with it -
(currently at SQLite version 3.21, which is only two months or so behind the recent SQLite-version 3.23.1 -
...I read along in the SQLite-mailinglist and timeline-change-logs, and often skip one or two versions, depending on
"how much new stuff" was introduced into the SQLite-sources, and how fast the "dust settles" for that after introducion).

For example, new in 3.22 was a new "virtual-table for ZIP-files" - and in 3.23 there were a few "corner-case-fixes"
for that Zip-Table-feature (my plan is, to make a new release, as soon as 3.24 comes out - including that Zip-Table-feature).

Olaf

[Wolfgang Enzinger]

(my plan is, to make a new release, as soon as 3.24 comes out - including that Zip-Table-feature).

Hi Olaf, regarding that new release, I just posted a small wishlist to our good ole' newsgroup, see https://groups.google.com/forum/#!to...ic/3SCZNrVKEdY

Sorry folks, that's in German - but actually most of it is in VB6 so it's international. ;-)

Cheers Wolfgang