I am designing a system within which I will need to be able to search a database using a file or string SHA3-256 hash.
For example the hash of test is
- Which DATATYPE should I set the column that stores this value? I've heard about using BINARY instead of VARCHAR.
- How should I index this column so that searches by hash are fastest?
- Which database management system (like PostgreSQL, DB2, SQL Server), or document software (like MongoDB) should I use that most efficiently allows me to store and retrieve records by hash? I only have experience with relational database management systems like MySQL, but maybe a document store like MongoDB would be the better way to go.