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 _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
