Thanks Richard. After figuring out the version number, I could automate the
download of most versions back to 3.6.22.
Since mailing lists are archived and this might come up in the future,
there was some confusion with the <VERSION>. I located these two
explanations for sqlite versioning:
https://sqlite.org/versionnumbers.html
https://sqlite.org/c3ref/c_source_id.html
Looking at the latter, the most recent data at time of lookup read as:
#define SQLITE_VERSION "3.20.1"
#define SQLITE_VERSION_NUMBER 3020001
Which was supposedly calculated as (X*1000000 + Y*1000 + Z) where X, Y, and
Z are the same numbers used in SQLITE_VERSION. However, the most recent
download link was actually https://www.sqlite.org/2017/sqlite-dll-win32-x86-
3200100.zip. This was different than what I expected.
Here are the URLs I successfully downloaded:
https://sqlite.org/2017/sqlite-dll-win32-x86-3200100.zip: Data is returned!
https://sqlite.org/2017/sqlite-dll-win32-x86-3200000.zip: Data is returned!
https://sqlite.org/2017/sqlite-dll-win32-x86-3180200.zip failed with error
code: 404
https://sqlite.org/2017/sqlite-dll-win32-x86-3180100.zip failed with error
code: 404
https://sqlite.org/2017/sqlite-dll-win32-x86-3190300.zip: Data is returned!
https://sqlite.org/2017/sqlite-dll-win32-x86-3190200.zip: Data is returned!
https://sqlite.org/2017/sqlite-dll-win32-x86-3190100.zip: Data is returned!
https://sqlite.org/2017/sqlite-dll-win32-x86-3190000.zip: Data is returned!
https://sqlite.org/2017/sqlite-dll-win32-x86-3180000.zip: Data is returned!
https://sqlite.org/2017/sqlite-dll-win32-x86-3170000.zip: Data is returned!
https://sqlite.org/2017/sqlite-dll-win32-x86-3160200.zip: Data is returned!
https://sqlite.org/2017/sqlite-dll-win32-x86-3160100.zip: Data is returned!
https://sqlite.org/2017/sqlite-dll-win32-x86-3160000.zip: Data is returned!
https://sqlite.org/2016/sqlite-dll-win32-x86-3150200.zip: Data is returned!
https://sqlite.org/2016/sqlite-dll-win32-x86-3150100.zip: Data is returned!
https://sqlite.org/2016/sqlite-dll-win32-x86-3150000.zip: Data is returned!
https://sqlite.org/2016/sqlite-dll-win32-x86-3140200.zip: Data is returned!
https://sqlite.org/2016/sqlite-dll-win32-x86-3140100.zip: Data is returned!
https://sqlite.org/2016/sqlite-dll-win32-x86-3140000.zip: Data is returned!
https://sqlite.org/2016/sqlite-dll-win32-x86-3130000.zip: Data is returned!
https://sqlite.org/2016/sqlite-dll-win32-x86-3120200.zip: Data is returned!
https://sqlite.org/2016/sqlite-dll-win32-x86-3120100.zip failed with error
code: 404
https://sqlite.org/2016/sqlite-dll-win32-x86-3090300.zip failed with error
code: 404
https://sqlite.org/2016/sqlite-dll-win32-x86-3120000.zip failed with error
code: 404
https://sqlite.org/2016/sqlite-dll-win32-x86-3110100.zip: Data is returned!
https://sqlite.org/2016/sqlite-dll-win32-x86-3110000.zip: Data is returned!
https://sqlite.org/2016/sqlite-dll-win32-x86-3100200.zip: Data is returned!
https://sqlite.org/2016/sqlite-dll-win32-x86-3100100.zip: Data is returned!
https://sqlite.org/2016/sqlite-dll-win32-x86-3100000.zip: Data is returned!
https://sqlite.org/2015/sqlite-dll-win32-x86-3090200.zip: Data is returned!
https://sqlite.org/2015/sqlite-dll-win32-x86-3090100.zip: Data is returned!
https://sqlite.org/2015/sqlite-dll-win32-x86-3090000.zip: Data is returned!
https://sqlite.org/2015/sqlite-dll-win32-x86-3081101.zip: Data is returned!
https://sqlite.org/2015/sqlite-dll-win32-x86-3081100.zip: Data is returned!
https://sqlite.org/2015/sqlite-dll-win32-x86-3081002.zip: Data is returned!
https://sqlite.org/2015/sqlite-dll-win32-x86-3081001.zip: Data is returned!
https://sqlite.org/2015/sqlite-dll-win32-x86-3081000.zip: Data is returned!
https://sqlite.org/2015/sqlite-dll-win32-x86-3080900.zip: Data is returned!
https://sqlite.org/2015/sqlite-dll-win32-x86-3080803.zip: Data is returned!
https://sqlite.org/2015/sqlite-dll-win32-x86-3080802.zip: Data is returned
https://sqlite.org/2015/sqlite-dll-win32-x86-3080801.zip: Data is returned!
https://sqlite.org/2015/sqlite-dll-win32-x86-3080800.zip: Data is returned!
https://sqlite.org/2014/sqlite-dll-win32-x86-3080704.zip: Data is returned!
https://sqlite.org/2014/sqlite-dll-win32-x86-3080703.zip: Data is returned!
https://sqlite.org/2014/sqlite-dll-win32-x86-3080702.zip: Data is returned!
https://sqlite.org/2014/sqlite-dll-win32-x86-3080701.zip: Data is returned!
https://sqlite.org/2014/sqlite-dll-win32-x86-3080601.zip failed with error
code: 404
https://sqlite.org/2014/sqlite-dll-win32-x86-3080700.zip: Data is returned!
https://sqlite.org/2014/sqlite-dll-win32-x86-3080600.zip: Data is returned!
https://sqlite.org/2014/sqlite-dll-win32-x86-3080500.zip: Data is returned!
https://sqlite.org/2014/sqlite-dll-win32-x86-3080403.zip: Data is returned!
https://sqlite.org/2014/sqlite-dll-win32-x86-3080402.zip: Data is returned!
https://sqlite.org/2014/sqlite-dll-win32-x86-3080401.zip: Data is returned!
https://sqlite.org/2014/sqlite-dll-win32-x86-3080400.zip: Data is returned!
https://sqlite.org/2014/sqlite-dll-win32-x86-3080301.zip: Data is returned!
https://sqlite.org/2014/sqlite-dll-win32-x86-3080300.zip: Data is returned!
https://sqlite.org/2013/sqlite-dll-win32-x86-3080200.zip: Data is returned!
https://sqlite.org/2013/sqlite-dll-win32-x86-3080100.zip: Data is returned!
https://sqlite.org/2013/sqlite-dll-win32-x86-3080002.zip: Data is returned!
https://sqlite.org/2013/sqlite-dll-win32-x86-3080001.zip: Data is returned!
https://sqlite.org/2013/sqlite-dll-win32-x86-3080000.zip: Data is returned!
https://sqlite.org/2013/sqlite-dll-win32-x86-3071700.zip: Data is returned!
https://sqlite.org/2013/sqlite-dll-win32-x86-3071602.zip: Data is returned!
https://sqlite.org/2013/sqlite-dll-win32-x86-3071601.zip: Data is returned!
https://sqlite.org/2013/sqlite-dll-win32-x86-3071600.zip: Data is returned!
Cheers,
Matt