Hello Liviu, SQLite is the way to go if you want something standard. But having the ability to just use a text editor to add/remove/modify records in db_text is golden for me. I used db_text a lot on embedded platforms. I would vote against obsolete-ing db_text. For me, it's easier to use db_text instead of sqlite. For others, it might be the other way around.
Regards, Ovidiu Sas On Wed, Sep 23, 2020 at 1:55 AM Liviu Chircu <li...@opensips.org> wrote: > > 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@lists.opensips.org > http://lists.opensips.org/cgi-bin/mailman/listinfo/users -- VoIP Embedded, Inc. http://www.voipembedded.com _______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users