SQLite User Forum

Computing sha3-256 on Windows, to verify downloads?
Login

Computing sha3-256 on Windows, to verify downloads?

(1) By robnik on 2023-11-20 23:23:32 [source]

I'm trying to use sqlite in a C++ Windows program. I got a DLL from the downloads page - https://www.sqlite.org/download.html.

I'm new to Windows... I don't see how to compute a sha3-256 hash to check the file integrity. Anyone know?

I tried this in powershell...

> Get-FileHash .\sqlite-dll-win-x64-3440000.zip -Algorithm SHA3-256
Get-FileHash : Cannot validate argument on parameter 'Algorithm'. The argument "SHA3-256" does
not belong to the set "SHA1,SHA256,SHA384,SHA512,MACTripleDES,MD5,RIPEMD160" specified by [...]

Rob

(2) By Larry Brasfield (larrybr) on 2023-11-21 00:00:11 in reply to 1 [link] [source]

If you have a semi-recent version of the SQLite CLI: SELECT lower(hex(sha3(readfile('sqlite-dll-win-x64-3440000.zip'))));

(3) By Larry Brasfield (larrybr) on 2023-11-21 00:22:34 in reply to 1 [link] [source]

Keith Medcalf1 published a little Python program for computing a variety of hash functions on files.


  1. ^ Keith was a frequent contributor here until his mid-2023 demise.

(4) By robnik on 2023-11-21 02:07:23 in reply to 3 [link] [source]

Perfect, that worked. Thanks.

I'm new and flailing in Visual Studio, so I'm not sure yet how to add this to my project (C++, Windows). If there are some docs on that, please let me know.

Rob

(5) By anonymous on 2023-11-21 02:24:49 in reply to 4 [link] [source]

Where to put dll in VisualStudio? https://sqlite.org/forum/forumpost/21309141a6

(6) By anonymous on 2024-07-27 17:22:24 in reply to 1 [link] [source]

Use this python-script to verify sqlite files hashed by sha3-256

import hashlib

path = input("input path: ")

with open(path, "rb") as file:
    s = hashlib.sha3_256(file.read())

    print(s.name)

    print(s.digest_size)

    print(s.hexdigest())

(7) By Minion (DataHound) on 2024-11-05 17:10:32 in reply to 1 [link] [source]

Old user, returning to SQLite after many years...

I am seeing a lot of forum posts about hashes and have a similar issue:

https://www.sqlite.org/2024/sqlite-tools-win-x64-3470000.zip has SHA3-256: 4d74460ada4b5cc74cb74fb2320247ec8e369bbb7447a8b829a5d532824a4ee7

Using https://download.firedaemon.com/FireDaemon-OpenSSL/FireDaemon-OpenSSL-x64-3.4.0.exe gives this :

openssl.exe sha3-256 "C:UsersacfarDownloadssqlite-dll-win64-x64-3410200.zip" SHA3-256(C:UsersacfarDownloadssqlite-dll-win64-x64-3410200.zip)= a85aa4c03f394147b4a9050245fb8d5d0b00ae726d1f259e71c07055e44854cf

Is it me?

(8) By Minion (DataHound) on 2024-11-05 17:31:28 in reply to 7 [link] [source]

It is me. Typo in file name