sqlite3-regex.so

Hi Rick,

I found I needed to do this command. “db enable_load_extension 1” before calling the load extension. Hope this works for you.

Not that I found.  You have the ability to create a .sqliterc in the users home directory, I added
.load “sqlite3-regex.so”
To the file so its there when I need it from the command line.

• This reply was modified 3 months, 1 week ago by John Mercogliano.

No, only for the unix command line tool.  You will still need to do enable load extension to use regexp in tcl.

As far as the rc file, that one line I listed above is the only statement in the file.

fwiw, in tcl, we use the following to enable regexp within tcl proc:

DBCMD function regexp regexp