<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.30.3">
<TITLE>Re: [Freeswitch-users] sqlite3 and regex</TITLE>
</HEAD>
<BODY>
Hi,<BR>
<BR>
Coudn't we load just an external extension to sqlite?<BR>
<BR>
for example, to have regular expression support you could load an external library like "<TT>sqlite3-pcre</TT>" (available for unbuntu), you can load from the console interface or directly in sql.<BR>
<BR>
console:<BR>
sqlite> .load '/usr/lib/sqlite3/pcre.so<BR>
<BR>
sql in console:<BR>
sqlite> select load_extension(''/usr/lib/sqlite3/pcre.so'); <BR>
<BR>
<BR>
In fs is not possible, when i try to do it from my lua script i have the following error:<BR>
<BR>
2012-11-28 17:21:34.196304 [ERR] switch_core_sqldb.c:572 NATIVE SQL ERR [no such function: load_extension]<BR>
select load_extension('/usr/lib/sqlite3/pcre.so');<BR>
<BR>
<BR>
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?<BR>
<BR>
<BR>
Thanks,<BR>
António<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
On Fri, 2012-11-02 at 18:03 -0500, Ken Rice wrote:<BR>
<BLOCKQUOTE TYPE=CITE>
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<BR>
<BR>
K<BR>
<BR>
<BR>
On 11/2/12 3:34 PM, "Scott" <<A HREF="8f27e956@gmail.com">8f27e956@gmail.com</A>> wrote:<BR>
<BR>
<BLOCKQUOTE>
"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).<BR>
<BR>
With thanks,<BR>
<BR>
<BR>
<HR SIZE="3">
<BR>
<BR>
<FONT SIZE="2">_________________________________________________________________________</FONT><BR>
<FONT SIZE="2">Professional FreeSWITCH Consulting Services:</FONT><BR>
<FONT SIZE="2"><A HREF="consulting@freeswitch.org">consulting@freeswitch.org</A></FONT><BR>
<FONT SIZE="2"><A HREF="http://www.freeswitchsolutions.com">http://www.freeswitchsolutions.com</A></FONT><BR>
<BR>
<FONT SIZE="2">FreeSWITCH-powered IP PBX: The CudaTel Communication Server</FONT><BR>
<FONT SIZE="2"><A HREF="http://www.cudatel.com">http://www.cudatel.com</A></FONT><BR>
<BR>
<FONT SIZE="2">Official FreeSWITCH Sites</FONT><BR>
<FONT SIZE="2"><A HREF="http://www.freeswitch.org">http://www.freeswitch.org</A></FONT><BR>
<FONT SIZE="2"><A HREF="http://wiki.freeswitch.org">http://wiki.freeswitch.org</A></FONT><BR>
<FONT SIZE="2"><A HREF="http://www.cluecon.com">http://www.cluecon.com</A></FONT><BR>
<BR>
<FONT SIZE="2">FreeSWITCH-users mailing list</FONT><BR>
<FONT SIZE="2"><A HREF="FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</A></FONT><BR>
<FONT SIZE="2"><A HREF="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</A></FONT><BR>
<FONT SIZE="2">UNSUBSCRIBE:<A HREF="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</A></FONT><BR>
<FONT SIZE="2"><A HREF="http://www.freeswitch.org">http://www.freeswitch.org</A></FONT><BR>
</BLOCKQUOTE>
<BR>
-- <BR>
Ken<BR>
<U><FONT COLOR="#0000ff"><A HREF="http://www.FreeSWITCH.org">http://www.FreeSWITCH.org</A></FONT></U><BR>
<U><FONT COLOR="#0000ff"><A HREF="http://www.ClueCon.com">http://www.ClueCon.com</A></FONT></U><BR>
<U><FONT COLOR="#0000ff"><A HREF="http://www.OSTAG.org">http://www.OSTAG.org</A></FONT></U><BR>
irc.freenode.net #freeswitch
<PRE>
_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
<A HREF="mailto:consulting@freeswitch.org">consulting@freeswitch.org</A>
<A HREF="http://www.freeswitchsolutions.com">http://www.freeswitchsolutions.com</A>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server
<A HREF="http://www.cudatel.com">http://www.cudatel.com</A>
Official FreeSWITCH Sites
<A HREF="http://www.freeswitch.org">http://www.freeswitch.org</A>
<A HREF="http://wiki.freeswitch.org">http://wiki.freeswitch.org</A>
<A HREF="http://www.cluecon.com">http://www.cluecon.com</A>
FreeSWITCH-users mailing list
<A HREF="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</A>
<A HREF="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</A>
UNSUBSCRIBE:<A HREF="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</A>
<A HREF="http://www.freeswitch.org">http://www.freeswitch.org</A>
</PRE>
</BLOCKQUOTE>
<BR>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
<PRE>
--
Un cordial saludo / Best regards,
_________________________
António Silva
E-mail:<A HREF="mailto:asilva@wirelessmundi.com">asilva@wirelessmundi.com</A>
</PRE>
</TD>
</TR>
</TABLE>
</BODY>
</HTML>