[OpenSIPS-Users] store data locally

[Ovidiu Sas]

Hello Alain,

If you don't want to run a full blown db, then you can use db_text
without cacheDB.
The data is cached into memory at startup. If you update the text
file, you can re-cache the data [1].
You can also manipulate the data using the avpops module [2].
Or, you can use cacheDB on top of the text db :)

[1]: https://opensips.org/docs/modules/3.1.x/db_text.html#mi_dbt_reload
[2]: https://opensips.org/docs/modules/3.1.x/avpops.html

Regards,
Ovidiu Sas

On Tue, Sep 22, 2020 at 9:36 AM Liviu Chircu <liviu at opensips.org> wrote:
>
> On 22.09.2020 16:09, Alain Bieuzent wrote:
>
> I need to store some data locally but accessible by opensips.
>
> the data is almost 20 records made up of a couple IP: name
>
> From opensips script I want to retrieve the name associated with the IP (to put in place profiling).
>
> how do you set up this kind of solution without accessing each call to an external database?
>
> Hi, Alain!
>
> One way would be to use the local cacheDB [1] module through the generic cacheDB scripting functions [2].
>
> Alternatively, if you specifically need to load this data from an SQL DB, for example, the sql_cacher [3] module would be a perfect fit.
>
> Fun Fact:  if you decide to use any of these two modules, you will have to buy a guy named Vlad a beer, and they are not the same Vlad.
>
> Best regards,
>
> [1]: https://opensips.org/docs/modules/3.2.x/cachedb_local.html
> [2]: https://www.opensips.org/Documentation/Script-CoreFunctions-3-2#toc4
> [3]: https://opensips.org/docs/modules/3.2.x/sql_cacher.html
>
> --
> Liviu Chircu
> www.twitter.com/liviuchircu | www.opensips-solutions.com
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users



-- 
VoIP Embedded, Inc.
http://www.voipembedded.com