https://www.sqlite.org/src/file?name=ext/misc/regexp.c&ci=trunk

I downloaded regexp.c from above, and compileded it like this on macOS.

gcc -I /usr/local/opt/sqlite/include -fPIC -dynamiclib /tmp/regexp.c -o /usr/local/opt/sqlite/lib/regexp.dylib

Then I got the following error when I try to load it in an sqlite3 session. Does anybody know how to load it properly?

$ LD_LIBRARY_PATH=/usr/local/opt/sqlite/lib sqlite3
SQLite version 3.36.0 2021-06-18 18:36:39
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> SELECT LOAD_EXTENSION('regexp');
Error: error during initialization:
sqlite>