On Mon, 2020-05-04 at 13:03 -0600, Grant Taylor wrote: > Which is why I have not. It's also why I asked if there was a way to > compare hashed text. To quote: > > "Is there any way to compare hashed strings of text?" > > I'll note that my question hasn't been answered. Instead, people > have > focused on something not germane to my question. > Encrypt them and put them in a single column database table that's also the prime key for the table?
Lookup by encrypting the item being checked before looking for an SQL hit count: select count(*) where log.key = key; 0=miss, 1=hit, 2+ = error. Should run fast. Of course, that would need an SA plugin, but Perl SQL interface code isn't hard and is fairly compact. For added protection, keep the database on an encrypted partition. Any database should do: MariaDB, SQLite, PostgreSQL,... You get points for added security by obscurity it you can stick it in a corner of an existing, unrelated database. Martin
