in reply to Re^7: Documentation of REGEXP support in DBD::SQLite?
in thread Documentation of REGEXP support in DBD::SQLite?

(For decisive answers, read the postgres code ;))

And to be sure, please use like '%ab%' again.

I can't get bigrams to respond quickly; also not when there is only one matching value; with this data it will always Seq scan (sometimes with parallel workers: just under 1 second).

In postgres, 'LIKE' doesn't allow regex (although its simple pattern search can sometimes use the trigram or btree index). Postgres uses the tilde for regex search (~ case sensitive, ~* case insensitive).

  • Comment on Re^8: Documentation of REGEXP support in DBD::SQLite?

Replies are listed 'Best First'.
Re^9: Documentation of REGEXP support in DBD::SQLite?
by LanX (Saint) on Nov 16, 2024 at 08:35 UTC
    > I can't get bigrams to respond quickly

    Hence they are not indexed.

    > although its simple pattern search can sometimes use the trigram or btree index

    That's why I wanted LIKE, to be sure the trigram optimization can be chosen

    Cheers Rolf
    (addicted to the Perl Programming Language :)
    see Wikisyntax for the Monastery