[Asterisk-Users] Looking for a SQL or ODBC Application

[David Filion]

Chris A. Icide wrote:

> Is anyone aware of an Asterisk application that allows you to read and 
> write values to multiple tables in a database.  Im not looking for an 
> app that will let me externalize asterisk's database.  I'm looking for 
> one that will let me do normal SQL like queries and inserts.  An example:
>
> exten => _XX.,1,SQL(PEER=Select peer from egress where route_id=1)
>
> ...
>
> exten => _XX.,1,SQL(update egress set technology='Zap' where route_id=1)
>
> etc.
>
> Chris
>
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>
>
>

There along the with others already mentioned, there is also 
app_sql_postgres that allows execution of any SQL against Postgresql.  
It's commented out in the apps/Makefile file by default so you will need 
to uncomment it to build it.

David