"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,
No, That is not implemented. On Nov 2, 2012 5:27 PM, "Scott" <8f27e956@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@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
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@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@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@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
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@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@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@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@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@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@wirelessmundi.com
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@wirelessmundi.com> wrote: Re: [Freeswitch-users] sqlite3 and regex 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@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@freeswitch.org http://www.freeswitchsolutions.com FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com FreeSWITCH-users mailing list FreeSWITCH-users@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@freeswitch.orghttp://www.freeswitchsolutions.com FreeSWITCH-powered IP PBX: The CudaTel Communication Serverhttp://www.cudatel.com Official FreeSWITCH Siteshttp://www.freeswitch.orghttp://wiki.freeswitch.orghttp://www.cluecon.com FreeSWITCH-users mailing listFreeSWITCH-users@lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://www.frees... -- Un cordial saludo / Best regards, _________________________ António Silva E-mail:asilva@wirelessmundi.com _________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
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@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@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@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@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@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@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@wirelessmundi.com _________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@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@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@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@wirelessmundi.com
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@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@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@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@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@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@freeswitch.orghttp://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Serverhttp://www.cudatel.com
Official FreeSWITCH Siteshttp://www.freeswitch.orghttp://wiki.freeswitch.orghttp://www.cluecon.com
FreeSWITCH-users mailing listFreeSWITCH-users@lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://www.frees...
--
Un cordial saludo / Best regards,
_________________________
António Silva
E-mail:asilva@wirelessmundi.com
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@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@freeswitch.orghttp://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Serverhttp://www.cudatel.com
Official FreeSWITCH Siteshttp://www.freeswitch.orghttp://wiki.freeswitch.orghttp://www.cluecon.com
FreeSWITCH-users mailing listFreeSWITCH-users@lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://www.frees...
--
Un cordial saludo / Best regards,
_________________________
António Silva
E-mail:asilva@wirelessmundi.com
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@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
participants (6)
-
Anthony Minessale
-
Antonio
-
Ken Rice
-
Michael Collins
-
S. Scott
-
Scott