<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style>
</head>
<body lang="EN-US" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">We use db_text and I agree with Ovidiu. We use it mostly for built-in datastores on our instances. So we build the DB and then bake it onto our AMIs before launch. The data is never modified during runtime, so we don’t need full SQL functionality.
Using db_text removes dependencies on sqlite in both the build and runtime environments. We use Ansible/Jinja2 to template the db_text databases from text files. It’s very straightforward.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">So if you need SQL features then sqlite is great, but db_text is a very fast, easy way to get a DB running with no overhead.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal"><span style="color:black">Ben Newlin </span><o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal" style="margin-bottom:12.0pt"><b><span style="font-size:12.0pt;color:black">From:
</span></b><span style="font-size:12.0pt;color:black">Users <users-bounces@lists.opensips.org><br>
<b>Date: </b>Wednesday, September 23, 2020 at 9:50 AM<br>
<b>To: </b>OpenSIPS users mailling list <users@lists.opensips.org><br>
<b>Subject: </b>Re: [OpenSIPS-Users] store data locally<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">Hello Liviu,<br>
<br>
SQLite is the way to go if you want something standard.<br>
But having the ability to just use a text editor to add/remove/modify<br>
records in db_text is golden for me.<br>
I used db_text a lot on embedded platforms.<br>
I would vote against obsolete-ing db_text.<br>
For me, it's easier to use db_text instead of sqlite. For others, it<br>
might be the other way around.<br>
<br>
Regards,<br>
Ovidiu Sas<br>
<br>
On Wed, Sep 23, 2020 at 1:55 AM Liviu Chircu <liviu@opensips.org> wrote:<br>
><br>
> On 22.09.2020 18:42, Ovidiu Sas wrote:<br>
> > If you don't want to run a full blown db, then you can use db_text<br>
> > without cacheDB.<br>
> > The data is cached into memory at startup. If you update the text<br>
> > file, you can re-cache the data [1].<br>
><br>
> Hi, Ovidiu!<br>
><br>
> May I segue into discussing some questions that have been puzzling me<br>
> for a while now?<br>
><br>
> "In 2020, why should developers choose DB TEXT over DB SQLITE?<br>
> Shouldn't DB TEXT be obsoleted?"<br>
><br>
> As far as history goes, it seems DB TEXT was created by Daniel in 2003.<br>
> Which, in my opinion, even for that time, it seems like a "reinvent the<br>
> wheel" kind of effort, since SQLite had already been GA'ed for almost 3<br>
> years [1].<br>
><br>
> In order to come up with an answer, we can break down my original questions:<br>
><br>
> * DB TEXT and SQLite both aim to be lightweight, serverless, file-based<br>
> SQL databases with RAM caching. True or false?<br>
> * does DB TEXT have any features that SQLite doesn't?<br>
> * does DB TEXT support a richer SQL syntax than SQLite?<br>
> * does DB TEXT have less bugs than SQLite?<br>
> * does DB TEXT handle in-memory caching better than SQLite?<br>
> * does DB TEXT handle disk files better than SQLite?<br>
><br>
> Thank you in advance for the discussion!<br>
><br>
> Best regards,<br>
><br>
> [1]: <a href="https://sqlite.org/changes.html">
https://protect-us.mimecast.com/s/hqFICG6Q9Nir8YGJTKiBEi?domain=sqlite.org</a><br>
><br>
> --<br>
> Liviu Chircu<br>
> <a href="http://www.twitter.com/liviuchircu">www.twitter.com/liviuchircu</a> | <a href="http://www.opensips-solutions.com">
www.opensips-solutions.com</a><br>
><br>
><br>
> _______________________________________________<br>
> Users mailing list<br>
> Users@lists.opensips.org<br>
> <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">
https://protect-us.mimecast.com/s/QQVvCJ67Pkiknr58cGCME1?domain=lists.opensips.org</a><br>
<br>
<br>
<br>
-- <br>
VoIP Embedded, Inc.<br>
<a href="http://www.voipembedded.com">http://www.voipembedded.com</a><br>
<br>
_______________________________________________<br>
Users mailing list<br>
Users@lists.opensips.org<br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><o:p></o:p></p>
</div>
</div>
</body>
</html>