Jump to content
xavixp94

Offline version of the MSDN Hash Database

Recommended Posts

Hello,

I think it will be a good idea to provide an offline version of the entire "Microsoft SHA1 Hash Archive from my.visualstudio.com". It could be a simple SQL dump file packed in ZIP archive - just to be able to recreate offline version of this database. It would really help in keeping this important database available for a long time.

Greetings

Share this post


Link to post
Share on other sites

I've already started researching database handling in Visual Studio some time ago to be able to provide offline access through the ISO downloader. It's not as straightforward as it sounds...

Version 9.0 will feature a complete re-design of the application. Maybe I'll include the database with a very basic search interface, similar to the new downloads database.

A downloadable SQL dump is not an option. I do see the benefit of having mirrors and clones of important data, however, I had several weeks effort of reverse engineering and collecting the data. Fact is, my livelihood relies 90 to 95% on advertising revenue, and providing the tools to clone a web interface to the data would be counterproductive.

Instead, I will create a secondary backup of the data in the cloud, to make sure that in a worst case scenario it will not be lost.

Share this post


Link to post
Share on other sites

I see. Sure, you should have revenue from your work (which is amazing by the way). On the other hand, we know that web is very fragile to many factors - maybe you will be forced to take down the database because of DMCA or simple lack of resources. I personally would pay you for such dump in SQL or CSV or any other reasonable format, so maybe you could offer such download possibility for donators? Please think about it. I saw many valuable content on the web took down overtime and I would really miss your fantastic project - which has real impact on general public's computer security.

Edited by xavixp94

Share this post


Link to post
Share on other sites

In case MS requests a DMCA takedown, the SQL dump will surely somehow mysteriously make its way to a code sharing platform...

In the unlikely case of a lack of resources, I'm sure I'll find a way to either copy the project onto some free webspace, or make the database available for download.

But as I said, I'll integrate an offline version into the ISO downloader, so the database will never be lost for good.

Share this post


Link to post
Share on other sites

I would like to politely second the request.

My gratitude in advance.

 

Please create a 'MSDN SHA1 Hash Archive' cvs/xlsx/xml for distribution.

Ex:

{FileID,ProductID,SHA1,File,Type,Size,Arch,Lang,Date,Title,MSDN-Alpha-Directory}
...
6507,469,c6de908d7c7320d15b3d59fd45bb1f026e26ec4c,en_net_cf_1.0_sp2_developer_redist.exe,EXE,12 MBytes,x86,English,2004-07-28 21:12:00,MSDN/#/.NET Compact Framework 1.0/.NET Compact Framework 1.0 Developer Redistributable

 

Share this post


Link to post
Share on other sites

This would really help a lot of people. I'm sure lot's of them would even make a donation for such database.

Above example is OK, but I would go for:

  • "bytes" as file size (if such value is provided by MyVisualStudio);
  • saving date/time in ISO 8601 format (so, taking the above, it would be "2004-07-28T21:12:00");
  • maybe use some other delimiter than comma (",") - for example "|". Just to prevent cases where comma is used in product name/description.
Edited by xavixp94

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...