[Freeswitch-users] sqlite3 and regex

[Antonio]

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
> > >         
> > >         FreeSWITCH-powered IP PBX: The CudaTel Communication
> > >         Server
> > >         
> > >         
> > >         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.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
> > 
> > 
> > -- 
> > 
> > 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.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


-- 

Un cordial saludo / Best regards, 

 _________________________

António Silva

E-mail:asilva at wirelessmundi.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20121129/661677b8/attachment.html