Comments (5)
brycedarling
commented on August 20, 2024
1
@sveredyuk as far as I know, the hash is only useful for an exact equality lookup. a string like "this is some text" will be hashed to a value like DV5hk0ryjAsvSp3uFhhLog1tLp3/aA7/ttGFAq1yg9k= so it wouldn't be very useful to do a LIKE query on. when searching the table, the value you are looking for also gets hashed so that it can try find a row with that exact same matching hash.
from cloak_ecto.
sveredyuk
commented on August 20, 2024
1
Definitely. Using LIKE for hashed values will give you nothing. Or exact match or just use another soution
from cloak_ecto.
brycedarling
commented on August 20, 2024
Nevermind, found it in the docs after thinking to search for "hash" ;)
https://hexdocs.pm/cloak_ecto/Cloak.Ecto.PBKDF2.html#module-usage
Thank you!
from cloak_ecto.
sveredyuk
commented on August 20, 2024
Hi, I have maybe a stupid question but is it possible to search with like or like by hashed fields?
from cloak_ecto.
acrolink
commented on August 20, 2024
@sveredyuk as far as I know, the hash is only useful for an exact equality lookup. a string like
"this is some text"will be hashed to a value likeDV5hk0ryjAsvSp3uFhhLog1tLp3/aA7/ttGFAq1yg9k=so it wouldn't be very useful to do aLIKEquery on. when searching the table, the value you are looking for also gets hashed so that it can try find a row with that exact same matching hash.
I have the same suspicion. Correct, true ? only exact full string match would work?
from cloak_ecto.
Related Issues (17)
- Cloak.Ecto.Type does not conform to the Ecto.Type behavior HOT 3
- In multi-tenant setting HOT 1
- Should Ecto.Type implementations of `equal?/2` be constant time?
- Support blind indexes HOT 1
- (ArgumentError) invalid or unknown HOT 1
- Not possible to compile with Ecto 3.6.0 HOT 10
- Missing function `:crypto.block_encrypt/4 ` in Erlang 24 HOT 3
- The version `1.2.0` generates an unexpected error HOT 5
- Decrypt for postgresql's native encrypt function? HOT 1
- Remove insecure example from docs HOT 1
- Trouble loading the Cloak.Ecto.PBKDF2 library HOT 1
- Drop dependency on :pbkdf2
- Documentation: cloak.migrate.ecto mix task ignores labels and is order-dependent HOT 1
- Create unique contraint for encrypted or hashed column
- Missing ETS table on Fly.io HOT 3
- Migrator doesn't handle plaintext arrays or maps with inner types
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from cloak_ecto.