Reverse Engineering Project - Download Old Versions

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Reverse Engineering Project - Download Old Versions

Matt Brooks
Hello,

I'm working on a project to aid in reversing binaries that contain various
versions of the sqlite DLL statically-linked. I'm trying to find a way to
download the precompiled Windows binaries for all 3.* versions. I've
scripted a test to see that some are hosted at the URI
http://www.sqlite.org/sqlitedll-<VERSION>. I'm sure the rest are hosted
somewhere. I'm trying to save time from having to download and compile the
source for every major release.

Can someone help?

Cheers,

Matt
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Reverse Engineering Project - Download Old Versions

Richard Hipp-3
On 8/25/17, Matt Brooks <[hidden email]> wrote:

> Hello,
>
> I'm working on a project to aid in reversing binaries that contain various
> versions of the sqlite DLL statically-linked. I'm trying to find a way to
> download the precompiled Windows binaries for all 3.* versions. I've
> scripted a test to see that some are hosted at the URI
> http://www.sqlite.org/sqlitedll-<VERSION>. I'm sure the rest are hosted
> somewhere. I'm trying to save time from having to download and compile the
> source for every major release.
>

Others are hosted at
https://sqlite.org/<YEAR>/sqlite3-dll-win32-x86-<VERSION>.zip or
https://sqlite.org/<YEAR>/sqlite3-dll-win64-x64-<VERSION>.zip where
<YEAR> is 2013, 2014, 2015, 2016, or 2017.

--
D. Richard Hipp
[hidden email]
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Reverse Engineering Project - Download Old Versions

Matt Brooks
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
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users