[asterisk-users] Open Source Asterisk Polling Solution

[Josh Metzger]

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 <support at drdos.info> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20140423/7327c208/attachment.html>