SHA1 hashing in SQLite: how?

by

There is no such function built into SQLite3.

But you could define a user function e.g. with sqlite3_create_function if you’re using the C interface, and implement SHA-1 with that. (But if you’re having a programmable interface perhaps you could just SHA-1 the password outside of the SQL engine.)

You could also try to find / create an extension and load with the load_extension function, but I don’t have experience on that.

Edit:

More Related Contents:

  1. Which cryptographic hash function should I choose?
  2. C# SHA-1 vs. PHP SHA-1…Different Results?
  3. Compute a hash from a stream of unknown length in C#
  4. Hashing with SHA1 Algorithm in C#
  5. In sqlite I would do, But how in mongodb c#
  6. Encrypt and decrypt a string in C#? [closed]
  7. What ‘additional configuration’ is necessary to reference a .NET 2.0 mixed mode assembly in a .NET 4.0 project?
  8. Padding is invalid and cannot be removed?
  9. Is SHA-1 secure for password storage?
  10. How does native implementation of ValueType.GetHashCode work?
  11. How can I sign a file using RSA and SHA256 with .NET?
  12. Hashing passwords with MD5 or sha-256 C#
  13. Is there an IDictionary implementation that, on missing key, returns the default value instead of throwing?
  14. How do I get around the “‘” problem in sqlite and c#?
  15. How can I generate a cryptographically secure pseudorandom number in C#?
  16. Getting hash of a list of strings regardless of order
  17. Is it possible to get identical SHA1 hash? [duplicate]
  18. Is calculating an MD5 hash less CPU intensive than SHA family functions?
  19. Best hashing algorithm in terms of hash collisions and performance for strings
  20. Problems using Entity Framework 6 and SQLite
  21. Password encryption/decryption code in .NET
  22. SQLite .NET performance, how to speed up things?
  23. Why do I need to use the Rfc2898DeriveBytes class (in .NET) instead of directly using the password as a key or IV?
  24. Can I depend on the values of GetHashCode() to be consistent?
  25. Obtain SHA-256 string of a string
  26. How to auto create database on first run?
  27. Visual Studio C# – SQLite.Interop.dll not found
  28. Compare password hashes between C# and ColdFusion (CFMX_COMPAT)
  29. Hashing a string with SHA256
  30. Import a Public key from somewhere else to CngKey?

Leave a Comment