Compile and load the regexp extension (ext/misc/regexp.c in the full source distribution or the commit tracker). Or append the extension to SQLite3.c and load it, or also create a routine that does the initialization for you and aappend that to the SQLite3.c code as well, and use the SQLITE_EXTRA_INIT define so that the extra initialization routine is executed for each connection that is created.
In other words, you just define a function with the correct name and cause it to be linked and loaded, and then you will have a REGEXP function and operator. --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-----Original Message----- >From: sqlite-users [mailto:sqlite-users- >[email protected]] On Behalf Of Paul Hoffman >Sent: Thursday, 21 December, 2017 10:57 >To: [email protected] >Subject: [sqlite] Compiling / building SQLite to include regex > >Greetings. I understand that SQLite doesn't come natively with regex >support, but that it can be added. My question is how to do so when I >install. I'm building from source from ><http://www.sqlite.org/download.html>. >Is there a simple recipe for "make REGEX work after installation"? >_______________________________________________ >sqlite-users mailing list >[email protected] >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
