<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<div class="moz-cite-prefix">On 03.12.2020 17:05, Saint Michael
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAC9cSOCXCvv7GuMZ3so8bdGgoMt+70mQ5dwoj+kppcimzBmjrQ@mail.gmail.com">
<div class="gmail_default" style="font-size:small">Some engines
like RocksDB, open-source, should be part of Opensips and run in
the same process space. This would be a first for any softswitch
technology.</div>
<div class="gmail_default" style="font-size:small">We need full
SQL technology, with tables, views, stored procedures,
functions, timers, etc.</div>
</blockquote>
<p><font face="monospace">Hi, Saint Michael!</font></p>
<p><font face="monospace">So with embed-able K/V databases such as
LevelDB (Google) or RocksDB (Facebook, basically a fork of
LevelDB), the only gain over the current, simplistic approach of
"cachedb_local" could only be in terms of performance. Right or
wrong?</font></p>
<p><font face="monospace">Regarding your other suggestion: that SQL
"access" doesn't seem to have much to do with RocksDB anymore.
And AFAIK, you can use avp_db_query() [1] to send any SQL query,
regardless of how complex it is (SELECT, INSERT, UPDATE, DELETE,
CALL PROCEDURE, CALL FUNCTION, CRATE TABLE, etc.). Can you
elaborate as to what you are missing here? :-)</font></p>
<p><font face="monospace">[1]:
<a class="moz-txt-link-freetext" href="https://opensips.org/docs/modules/3.3.x/avpops.html#func_avp_db_query">https://opensips.org/docs/modules/3.3.x/avpops.html#func_avp_db_query</a><br>
</font></p>
<p><font face="monospace">Cheers,</font><br>
</p>
<pre class="moz-signature" cols="72">--
Liviu Chircu
<a class="moz-txt-link-abbreviated" href="http://www.twitter.com/liviuchircu">www.twitter.com/liviuchircu</a> | <a class="moz-txt-link-abbreviated" href="http://www.opensips-solutions.com">www.opensips-solutions.com</a></pre>
</body>
</html>