[OpenSIPS-Users] Sqlops in opensips ?

[Alex Balashov]

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 
> <abalashov at evaristesys.com <mailto:abalashov at evaristesys.com>> 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
>         Users at lists.opensips.org <mailto:Users at lists.opensips.org>
>         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