> On Sep 16, 2019, at 1:44 PM, Peng Yu <pengyu...@gmail.com> wrote: > > But it is not clear how to install it for sqlite3 installed by > homebrew. Does anybody how to install it? Thanks.
SQLite doesn't come with a regexp implementation; it has to be added by an extension. I searched the website; there's a simple implementation here: https://www.sqlite.org/src/raw/ext/misc/regexp.c?name=a68d25c659bd2d893cd1215667bbf75ecb9dc7d4 <https://www.sqlite.org/src/raw/ext/misc/regexp.c?name=a68d25c659bd2d893cd1215667bbf75ecb9dc7d4> And regexp is also available as part of the ICU extension: https://www.sqlite.org/src/dir?ci=ee83d8e30d6f9ca8&name=ext/icu <https://www.sqlite.org/src/dir?ci=ee83d8e30d6f9ca8&name=ext/icu> You're going to have to build these yourself, I think. —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users