OK. LuaSQL provides direct access to postgresql but does not support connection pooling. ""FreeSWITCH Database Handler" looks like a way to go but I have to go through using ODBC to postgresql right? Can there be any downside of using ODBC?

On Tue, Jan 13, 2015 at 3:30 AM, Ítalo Rossi <italorossib@gmail.com> wrote:

Hi John,

Give Lua a try:

https://freeswitch.org/confluence/display/FREESWITCH/Lua+with+Database

On Mon, Jan 12, 2015 at 5:27 PM, John Nash <john.nash778@gmail.com> wrote:

I need to run a  DB query (Postgresql) from dialplan and store results in variables. I came across this link https://wiki.freeswitch.org/wiki/Mod_odbc_query and looks like this is what I need.

But I was wondering if I can use direct (without odbc) query to postgresql. Is there any such application available?

P.S. I read some posts about postgresql native support but have not been able to figure out what do I need to do to run a postgresql query from dialplan and store results with out odbc

_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting@freeswitch.org
http://www.freeswitchsolutions.com

Official FreeSWITCH Sites
http://www.freeswitch.org
http://confluence.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

--

Ítalo Rossi

_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting@freeswitch.org
http://www.freeswitchsolutions.com

Official FreeSWITCH Sites
http://www.freeswitch.org
http://confluence.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

Official FreeSWITCH Sites
http://www.freeswitch.org
http://confluence.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