Sure thing. Your question is a very good one. The difficulty of custom database interaction has always been something that struck me as a curious oddity about the OpenSER stack; it is one of the most obvious, most straightforward and commonly requested options and yet, until recently, one of the most obscure and difficult to perform.
Hardly anyone uses SER/OpenSER/Kamailio/OpenSIPS without wanting to issue their own SQL queries for some application-specific purpose, yet before 'sqlops' there was no elegant and generally well-aired way of doing this. Sure, avpops has avp_db_query(), but this has always struck me as something that was almost more of a hack - an afterthought - since it does not otherwise especially relate to the central purpose of the module or the theory behind AVPs. I find it very ironic - yet wholly plausible - to think that avp_db_query() might amount to something of a historical accident. Its wealth of modules notwithstanding, this product is largely useless without the ability to interface with databases directly. I would have thought something like sqlops would have come along before now. Sharath wrote: > Thanks a lot for the quick answer. Let me try the avp_db_query. thanks > again Alex. > > On Tue, May 26, 2009 at 2:46 PM, Alex Balashov > <[email protected] <mailto:[email protected]>> wrote: > > No generic database operations module. But you can use > avp_db_query() from avpops, which is the traditional way to go for > this problem. > > Sharath wrote: > > hello, > Is there any module equivalent to sqlops of openser in opensips > ? Basically I want to run sql queries from proprietary tables > and use them in the route script file. > > thank you > -Sharath > > > > ------------------------------------------------------------------------ > > _______________________________________________ > Users mailing list > [email protected] <mailto:[email protected]> > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > > -- > Alex Balashov > Evariste Systems > Web : http://www.evaristesys.com/ > Tel : (+1) (678) 954-0670 > Direct : (+1) (678) 954-0671 > Mobile : (+1) (678) 237-1775 > > > > > -- > --Sharath > > > > ============================== > Ping-pong & life are similar - both a quest for perfection. > ============================== -- Alex Balashov Evariste Systems Web : http://www.evaristesys.com/ Tel : (+1) (678) 954-0670 Direct : (+1) (678) 954-0671 Mobile : (+1) (678) 237-1775 _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
