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.
- ^ 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