[OpenSIPS-Users] Sqlops in opensips ?

[Bogdan-Andrei Iancu]

Hi Sharath,

if you use a a combination of avp_db_query() and memcache, you can load 
from DB when you first need the value and cache it for later usage. A 
tutorial about memcache is available under 
http://www.opensips.org/Resources/DocsTutMemcache

Soon, a "on_start" route will be available for this kind of ops.

Regards,
Bogdan

Sharath wrote:
> Is it possible to load *custom values from a database from a custom 
> table during init time. Am I correct in assuming the AVPops module is 
> scoped only for a call within a transaction ? Can the perl module be 
> used to make a db query at init time ?
>
> thanks for answering.
> -Sharath
>
> On Wed, May 27, 2009 at 7:46 AM, Alex Massover <alex at jajah.com 
> <mailto:alex at jajah.com>> wrote:
>
>      
>
>     I think perl module is most practical for you.
>
>      
>
>     --
>
>     Best Regards,
>
>     Alex Massover
>
>     VoIP R&D TL
>
>     Jajah Inc.
>
>     *From:* users-bounces at lists.opensips.org
>     <mailto:users-bounces at lists.opensips.org>
>     [mailto:users-bounces at lists.opensips.org
>     <mailto:users-bounces at lists.opensips.org>] *On Behalf Of *Sharath
>     *Sent:* Wednesday, May 27, 2009 12:42 AM
>     *To:* users at lists.opensips.org <mailto:users at lists.opensips.org>
>     *Subject:* [OpenSIPS-Users] Sqlops in opensips ?
>
>      
>
>     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
>
>     This mail was received via Mail-SeCure System.
>
>
>     This mail was sent via Mail-SeCure System.
>
>     _______________________________________________
>     Users mailing list
>     Users at lists.opensips.org <mailto:Users at lists.opensips.org>
>     http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>