Some client sent me REQ that filtered hundreds of authors by short prefix resulting into 180KB SQL generated, wasn’t it this tool?

Reply to this note

Please Login to reply.

Discussion

Mine doesn't do hundreds. What is short prefix?

Mine doesn't do hundreds. What is short prefix?

Its

pubkey LIKE '%abc’

Instead of

pubkey = ‘full-64-char-long-author-pubkey’

According to NIP-01

(And of course searching by prefixes is more expensive)

I can see some implementations don’t support it and some act inconsistently

For example at nos.lol the dollowing works:

["REQ", "test", {"authors": ["000000000332c7831d9c5a99f183afc2813a6f69a16edda7f6fc0ed8110566e6"]}]

As well as

["REQ", "test", {"authors": ["000000000332c7831d9c5a99f183afc2813a6f69a1"]}]

But next

["REQ", "test", {"authors": ["000000000332c7831d9c5a99f183afc2813a6f6"]}]

Produces error:

["NOTICE","ERROR: bad req: uneven size input to from_hex"]

* of course its

pubkey LIKE ‘abc%’