SELECT LOAD_EXTENSION('regexp');
assuming that the regexp dynamic library is located where it can be found.
>-----Original Message-----
>From: sqlite-users <sqlite-users-boun...@mailinglists.sqlite.org> On
>Behalf Of Peng Yu
>Sent: Thursday, 19 September, 2019 20:20
>To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org>
>Subject: Re: [sqlite] How to install REGEXP support?
>
>My question is `But it is not clear how to install it for sqlite3
>installed by
>homebrew.`
>
>On 9/19/19, Warren Young <war...@etr-usa.com> wrote:
>> On Sep 18, 2019, at 8:33 AM, Peng Yu <pengyu...@gmail.com> wrote:
>>>
>>> But I don't want to always specify a full path. I am asking where is
>>> the standard place to put the library file so that I don't have to
>>> always specify the whole path.
>>
>> You’re verging into “How do I program my computer?” or even “How do I
>use my
>> computer?” territory here. Put it in a directory where your OS’s
>dynamic
>> loader will find it. For macOS:
>>
>>
>>
>https://developer.apple.com/library/archive/documentation/DeveloperTools/
>Conceptual/DynamicLibraries/100-
>Articles/UsingDynamicLibraries.html#//apple_ref/doc/uid/TP40002182-SW10
>>
>> _______________________________________________
>> sqlite-users mailing list
>> sqlite-users@mailinglists.sqlite.org
>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>>
>
>
>--
>Regards,
>Peng
>_______________________________________________
>sqlite-users mailing list
>sqlite-users@mailinglists.sqlite.org
>http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
