I've always done my DB access via func_odbc and not with the mysql package. While we ran a MySQL db, I was more comfortable with the odbc stuff because it was part of Asterisk core and not an addon package. I can't speak to the simplicity of using the mysql stuff vs the odbc stuff, but there isn't a lot to creating your query in func_odbc and then calling it from your dialplan (and passing a few variables). I'd say it's no more difficult than calling an AGI, in my case we WERE processing a LARGE volume of calls, and importantly: It didn't require me to learn C or PHP. ;-)
Now if you want complicated, somewhere I have a very long GotoIf() that includes an ODBC call and nested Math() functions... -Josh On Wed, Apr 23, 2014 at 11:17 AM, Doug Lytle <[email protected]> wrote: > >> I tried database access in the dialplan using the mysql() application > >> years ago, just to confirm I was right and I was :) > > >> What an ugly, messy, fragile dialplan. > > With FuncODBC this is no longer an issue. All of the query logic is > handled outside of the dial plan. > > Doug > > > > -- > _____________________________________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > New to Asterisk? Join us for a live introductory webinar every Thurs: > http://www.asterisk.org/hello > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users >
-- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
