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 functi…

I found this on the mailing list, [erlang-questions] Binary pattern matching on ETS It doesn’t look like ETS supports binary pattern matching. It’s a bit dense, but you can also review the match spec, Match Specifications in Erlang — OTP 29.0.2 (erts 17.0.2)

it’s dynamic. think of a report page where users can select a bunch of filters to apply

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 …

Elixir Programming Language Forum

Partial matching ETS data

Questions & Help Questions

LostKobrakai December 16, 2021, 4:58pm 3

Can you split out the part of the value you want to match on insert or is it dynamic?