[OpenSIPS-Users] store data locally

Johan De Clercq Johan at democon.be
Wed Sep 23 07:06:19 EST 2020


I tend to agree with Liviu.  Therefore Ovidiu, please convince us of the
advantages of db_text :-)

Op wo 23 sep. 2020 om 07:58 schreef Liviu Chircu <liviu at opensips.org>:

> On 22.09.2020 18:42, Ovidiu Sas wrote:
> > 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].
>
> Hi, Ovidiu!
>
> May I segue into discussing some questions that have been puzzling me
> for a while now?
>
>      "In 2020, why should developers choose DB TEXT over DB SQLITE?
> Shouldn't DB TEXT be obsoleted?"
>
> As far as history goes, it seems DB TEXT was created by Daniel in 2003.
> Which, in my opinion, even for that time, it seems like a "reinvent the
> wheel" kind of effort, since SQLite had already been GA'ed for almost 3
> years [1].
>
> In order to come up with an answer, we can break down my original
> questions:
>
> * DB TEXT and SQLite both aim to be lightweight, serverless, file-based
> SQL databases with RAM caching.  True or false?
> * does DB TEXT have any features that SQLite doesn't?
> * does DB TEXT support a richer SQL syntax than SQLite?
> * does DB TEXT have less bugs than SQLite?
> * does DB TEXT handle in-memory caching better than SQLite?
> * does DB TEXT handle disk files better than SQLite?
>
> Thank you in advance for the discussion!
>
> Best regards,
>
> [1]: https://sqlite.org/changes.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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20200923/c33fd324/attachment.html>


More information about the Users mailing list