[Freeswitch-users] sqlite3 and regex

[Michael Collins]

That's how it's done, people! FYI, Anthony added this today in these two
commits:
http://fisheye.freeswitch.org/changelog/freeswitch.git/?cs=081e261
http://fisheye.freeswitch.org/changelog/freeswitch.git/?cs=bce107b

You can also see the flow of the conversation between the person submitting
the patch and the devs who had suggestions/information to make the process
go more smoothly:

http://jira.freeswitch.org/browse/FS-4883

*THAT* is why we need Jira for bugs/features/patches and not merely the
mailing list.

Kudos to all who got this feature added!
-MC

On Thu, Nov 29, 2012 at 1:28 AM, Antonio <asilva at wirelessmundi.com> wrote:

> **
> Hi,
>
> Last night came up with this patch:
>
> http://jira.freeswitch.org/browse/FS-4883
>
> Is working in my fs, this way i can use REGEXP in my lua scripts :)
>
>
>
>
>
> On Thu, 2012-11-29 at 01:19 -0500, S. Scott wrote:
>
> That's EXACTLY what I'm hunting for!  My freeswitch build doesn't have a
> pcre.so anywhere on the disk.  The .../freeswitch/libs/pcre/ exists with
> many files but no .so.
>
>
> What does one need to do to get the sqlite3 and the pcre.so rolled (from
> the git ingredients)?  make() and stuff not my strong suit.
>
> Thanks,
> —————
> iThing:  Big thumbs & little keys. Please excuse typo, spelling and
> grammar errors • Last night I played a blank CD at full blast. The Mime
> next door went nuts.
>
>
>
> On 2012-11-28, at 23:53, Antonio <asilva at wirelessmundi.com> wrote:
>
>
>
>  Hi,
>
> Coudn't we load just an external extension to sqlite?
>
> for example, to have regular expression support you could load an external
> library like "sqlite3-pcre" (available for unbuntu), you can load from
> the console interface or directly in sql.
>
> console:
> sqlite> .load '/usr/lib/sqlite3/pcre.so
>
> sql in console:
> sqlite> select load_extension(''/usr/lib/sqlite3/pcre.so');
>
>
> In fs is not possible, when i try to do it from my lua script i have the
> following error:
>
> 2012-11-28 17:21:34.196304 [ERR] switch_core_sqldb.c:572 NATIVE SQL ERR
> [no such function: load_extension]
> select load_extension('/usr/lib/sqlite3/pcre.so');
>
>
> Since you have already a switch type of db ( core, odbc or pgsql) could be
> nice when using core, be able to use a few more functions available in
> sqlite?
>
>
> Thanks,
> António
>
>
>
>
>
>
> On Fri, 2012-11-02 at 18:03 -0500, Ken Rice wrote:
>
> No and this wont happen anytime soon... The SQL interfaces for FreeSwitch
> are kept generic as we support more then just sqlite from common code and
> if we did it for sqlite we would have to make sure its implemented equally
> well for postgresql and mysql and mssql and any other database someone
> might want to use via ODBC
>
> K
>
>
> On 11/2/12 3:34 PM, "Scott" <8f27e956 at gmail.com> wrote:
>
>  "LIKE" notwithstanding, sqlite3 does not have a built-in true regex
> function; it does allow for a a c-language hook to one.  Given fs extensive
> use of the regex engine and of sqlite3, we're wondering if the hook is
> already written and rolled.  If so, can the rest of us hook it to our
> sqlite3 uses (e.g. from dial plan lua sqlite3).
>
> With thanks,
>
>
> ------------------------------
>
>
>
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> 
> 
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
>
> --
> Ken
> *http://www.FreeSWITCH.org*
> *http://www.ClueCon.com*
> *http://www.OSTAG.org*
> irc.freenode.net #freeswitch
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:consulting at freeswitch.orghttp://www.freeswitchsolutions.com
>
> FreeSWITCH-powered IP PBX: The CudaTel Communication Server
>
> Official FreeSWITCH Siteshttp://www.freeswitch.orghttp://wiki.freeswitch.orghttp://www.cluecon.com
>
> FreeSWITCH-users mailing listFreeSWITCH-users at lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://www.freeswitch.org
>
>
>   --
>
> Un cordial saludo / Best regards,
>
>  _________________________
>
> António Silva
>
> E-mail:asilva at wirelessmundi.com
>
>  _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> 
> 
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
>  _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:consulting at freeswitch.orghttp://www.freeswitchsolutions.com
>
> FreeSWITCH-powered IP PBX: The CudaTel Communication Server
>
> Official FreeSWITCH Siteshttp://www.freeswitch.orghttp://wiki.freeswitch.orghttp://www.cluecon.com
>
> FreeSWITCH-users mailing listFreeSWITCH-users at lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://www.freeswitch.org
>
>
>   --
>
> Un cordial saludo / Best regards,
>
>  _________________________
>
> António Silva
>
> E-mail:asilva at wirelessmundi.com
>
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> 
> 
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
>


-- 
Michael S Collins
Twitter: @mercutioviz
http://www.FreeSWITCH.org
http://www.ClueCon.com
http://www.OSTAG.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20121129/f09de4e5/attachment-0001.html