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 <[email protected]> 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 > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users -- VoIP Embedded, Inc. http://www.voipembedded.com _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
