Install sqlite-pcre on OSX

gistfile1.txt

brew install sqlite pcre

git clone https://github.com/ralight/sqlite3-pcre.git
cd sqlite3-pcre
cc -shared -o pcre.so -I/usr/local/opt/pcre/include  -fPIC -W -Werror pcre.c -L/usr/local/opt/pcre/lib -lpcre

echo ".load '`pwd`/pcre.so'" >> ~/.sqliterc

Typo in intall. Also even after this I get 'Error: no such function: REGEXP'

Thanks for the hint to the typo.

On my system it works.

When using the cc command above, I received the error ld: symbol(s) not found for architecture x86_64

Some research indicated that I also needed -lsqlite3

The following command worked

cc -shared -o pcre.so -I/usr/local/opt/pcre/include  -fPIC -W -Werror pcre.c -L/usr/local/opt/pcre/lib -lpcre -lsqlite3

on macOS 14 Sonoma you need to explicit the path for pcre after brew install (or update):

cc -shared -o pcre.so -I/usr/local/opt/pcre/include  -fPIC -W -Werror pcre.c -L/opt/homebrew/Cellar/pcre/8.45/ -lpcre -lsqlite3