Please is there a way to do the equivalent of the following with ETS.
:ets.fun2ms(fn {_id, m}
when String.starts_with?(m.name, "charles")
or String.starts_with?(m.mobile, "0809133")
or String.starts_with?(m.email, "charles") ->
m end)
I know we cannot have String.starts_with, or similar functions in a when clause, but is there a way to do the equivalent of this?
iex > :ets.fun2ms(fn {_id, m} when m.name == "charles" or m.mobile == "0809133" or m.email == "charles" -> m end)
[{{:"$1", :"$2"}, [{:orelse, {:orelse, {:==, {:map_get, :name, :"$2"}, "charles"}, {:==, {:map_get, :mobile, :"$2"}, "0809133"}}, {:==, {:map_get, :email, :"$2"}, "charles"}}], [:"$2"]}]
The above attempt will only handle exact string matches, and not partial matches like the LIKE clause
Answering a âstarts withâ query like that efficiently (ie not with a full table scan) in Postgres requires a B-tree index; with ETS youâll need to construct something similar yourself.
The Efficiency Guide goes into some more detail about this approach.
If you are feeling ambitious, you could create a probabilistic datastructure like a Bloom filter or xor_filter for each entryâs possible matches, like adding ['c', 'ch', 'char', 'charl', charle', 'charles'], then iterate over each filter to check if the partial match is in the filter. This would be for very simple matching, but if your use case doesnât support complex filters or ranking matches based on the âbest matchâ then it could work. There is a small chance of false positives. Iâve used this before for very simple first + last name matches for ~2k static values and it worked well enough.