<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><br class=""><div><blockquote type="cite" class=""><div class="">On 26 Oct 2017, at 15:20, Nir Simionovich <<a href="mailto:nir.simionovich@gmail.com" class="">nir.simionovich@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class="">Just looked into the code, this is not a simple task to put a new backend for astdb. The code isn't even designed<br class="">for something like that. Judging from what I can tell, and tell me if I'm wrong - turning this into a configurable thing<br class="">would be more or less an open-heart surgery.</div></div></blockquote>My patch wasn’t that bad, but it was before sqlite.</div><div><br class=""></div><div>/O<br class=""><blockquote type="cite" class=""><div class=""><div dir="ltr" class=""><div class=""><br class=""></div><div class=""><br class=""></div></div><br class=""><div class="gmail_quote"><div dir="ltr" class="">On Thu, Oct 26, 2017 at 4:16 PM Olle E. Johansson <<a href="mailto:oej@edvina.net" class="">oej@edvina.net</a>> wrote:<br class=""></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word" class="">Somewhere in Asterisk space, there’s an old patch where I added ASTDB over realtime, meaning you can use <div class="">any realtime storage. If I remember correctly there was a bit of chicken-and-egg problem with some astdb</div><div class="">calls happening before realtime got launched, but otherwise it worked just fine in production for a long time.</div></div><div style="word-wrap:break-word" class=""><div class=""><br class=""></div><div class="">/O</div></div><div style="word-wrap:break-word" class=""><div class=""><br class=""><div class=""><blockquote type="cite" class=""><div class="">On 26 Oct 2017, at 15:13, Nir Simionovich <<a href="mailto:nir.simionovich@gmail.com" target="_blank" class="">nir.simionovich@gmail.com</a>> wrote:</div><br class="m_3651031521499455850Apple-interchange-newline"><div class=""><div dir="ltr" class="">I'd like to +1 on that idea.<div class=""><br class=""></div><div class="">While I'm somewhat reluctant to using mySQL as the base of such a change, as mySQL is an overkill for AstDB,<br class="">having a proper AstDB configurable backend is an interesting thing. Personally speaking, I would actually prefer<br class="">something like Memcache or preferably Redis. Both are similar in function and usability to AstDB, both are fairly<br class="">scalable (Redis specifically) and both are fairly simplistic in nature. </div><div class=""><br class=""></div><div class="">I do admit that this got me intrigued... </div><div class=""><br class=""></div><div class=""><br class=""></div></div><br class=""><div class="gmail_quote"><div dir="ltr" class="">On Tue, Sep 26, 2017 at 12:45 AM Matt Fredrickson <<a href="mailto:creslin@digium.com" target="_blank" class="">creslin@digium.com</a>> wrote:<br class=""></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr" class=""><div class="gmail_extra"><div class="gmail_quote">On Fri, Sep 22, 2017 at 12:12 PM, Ryan Wagoner <span dir="ltr" class=""><<a href="mailto:rswagoner@gmail.com" target="_blank" class="">rswagoner@gmail.com</a>></span> wrote:<br class=""><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr" class="">I've been scaling out FreePBX horizontally with Kamailio and custom FreePBX modules mainly to handle call center outbound dialing (around 20k calls per day). One of the issues I ran into was FreePBX uses the AstDB extensively and will write changes to it from the dialplan or the FreePBX user control panel.<div class=""><br class=""></div><div class="">To overcome this I either needed to scrap FreePBX and build a new GUI using Asterisk realtime, heavily modify FreePBX (not an option), or rewrite AstDB to use a database like mySQL. I choose the last option and have had the code in production for just over a month. I'm backing it with a two node MariaDB Galera cluster with HAProxy providing failover for the client DB connections.</div><div class=""><br class=""></div><div class="">I realize that SQLite was chosen for AstDB for performance reasons. However mySQL seems to perform just fine in the above scenario. Right now I have a db.c file that just has the mySQL code. Does anybody else have any interest in using mySQL for the AstDB backend? I'm debating if it would make sense to have the option to select your AstDB backend.</div></div></blockquote><div class=""><br class=""></div></div></div></div><div dir="ltr" class=""><div class="gmail_extra"><div class="gmail_quote"><div class="">Hey Ryan,</div><div class=""><br class=""></div><div class=""><span style="font-size:12.8px" class="">First off, thanks for letting us know about the fun project you embarked upon. I think Josh already answered some of your questions, but with regards to the work you did - I believe that in the past there have been others who have wanted an ODBC AstDB driver as well. If your code can be made configurable, it may be a good contribution.</span></div><div class=""><span style="font-size:12.8px" class=""><br class=""></span></div><div class=""><span style="font-size:12.8px" class="">Anyways, hope you are doing well, and perhaps we'll see your code up on gerrit at some time in the future. :-)</span></div></div></div></div><div dir="ltr" class=""><div class="gmail_extra"><div class=""><br class=""></div>-- <br class=""><div class="m_3651031521499455850m_-3968396189948988291gmail_signature"><div dir="ltr" class=""><div class="">Matthew Fredrickson<br class="">Digium, Inc. | Engineering Manager<br class="">445 Jan Davis Drive NW - Huntsville, AL 35806 - USA</div></div></div>
</div></div>
--<br class="">
_____________________________________________________________________<br class="">
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com/" rel="noreferrer" target="_blank" class="">http://www.api-digital.com</a> --<br class="">
<br class="">
asterisk-dev mailing list<br class="">
To UNSUBSCRIBE or update options visit:<br class="">
<a href="http://lists.digium.com/mailman/listinfo/asterisk-dev" rel="noreferrer" target="_blank" class="">http://lists.digium.com/mailman/listinfo/asterisk-dev</a></blockquote></div><div dir="ltr" class="">-- <br class=""></div><div class="m_3651031521499455850gmail_signature" data-smartmail="gmail_signature"><div dir="ltr" class=""><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;line-height:normal;margin:0in 0in 0pt" class=""><font size="3" class=""><span style="font-family:"courier new"" class="">Kind Regards,</span><span style="color:rgb(31,73,125)" class=""></span></font></div><font size="3" face="Times New Roman" style="color:rgb(34,34,34);line-height:normal" class=""></font><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;line-height:normal;margin:0in 0in 0pt" class=""><font size="3" class=""><span style="font-family:"courier new"" class=""> Nir Simionovich</span><span style="color:rgb(31,73,125)" class=""></span></font></div><font size="3" face="Times New Roman" style="color:rgb(34,34,34);line-height:normal" class=""></font><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;line-height:normal;margin:0in 0in 0pt" class=""><font size="3" class=""><span style="font-family:"courier new"" class=""> GreenfieldTech</span><span style="color:rgb(31,73,125)" class=""></span></font></div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;line-height:normal;margin:0in 0in 0pt" class=""><font size="3" class=""><span style="font-family:"courier new"" class=""> (schedule) </span></font><font face="Courier New" size="3" class=""><a href="http://nirsimionovich.appointy.com/" style="color:rgb(17,85,204)" target="_blank" class="">http://nirsimionovich.appointy.com/</a></font></div><font size="3" face="Times New Roman" style="color:rgb(34,34,34);line-height:normal" class=""></font><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;line-height:normal;margin:0in 0in 0pt" class=""><span style="font-family:"courier new"" class=""><font size="3" class=""> (w)<span class="m_3651031521499455850inbox-inbox-inbox-inbox-Apple-converted-space"> </span></font><a href="http://www.greenfieldtech.net/" style="color:rgb(17,85,204)" target="_blank" class=""><span style="color:blue" class=""><font size="3" class="">http://www.greenfieldtech.net</font></span></a><font size="3" class=""> </font></span></div><font size="3" face="Times New Roman" style="color:rgb(34,34,34);line-height:normal" class=""></font><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;line-height:normal;margin:0in 0in 0pt" class=""><span style="font-family:"courier new"" class=""><font size="3" class=""> (p) <a href="tel:073-255-7799" value="+972732557799" target="_blank" class="">+972-73-2557799</a> <span class="m_3651031521499455850inbox-inbox-inbox-inbox-Apple-converted-space"> </span>(MSN):<span class="m_3651031521499455850inbox-inbox-inbox-inbox-Apple-converted-space"> </span></font><a href="mailto:nirs@greenfieldtech.net" style="color:rgb(17,85,204)" target="_blank" class=""><span style="color:blue" class=""><font size="3" class="">nirs@greenfieldtech.net</font></span></a></span></div><font size="3" face="Times New Roman" style="color:rgb(34,34,34);line-height:normal" class=""></font><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;line-height:normal;margin:0in 0in 0pt" class=""><span style="font-family:"courier new"" class=""><font size="3" class=""> (m) <a href="tel:054-698-2826" value="+972546982826" target="_blank" class="">+972-54-6982826</a> <span class="m_3651031521499455850inbox-inbox-inbox-inbox-Apple-converted-space"> </span>(GTALK):<span class="m_3651031521499455850inbox-inbox-inbox-inbox-Apple-converted-space"> </span></font><a href="mailto:nir.simionovich@gmail.com" style="color:rgb(17,85,204)" target="_blank" class=""><span style="color:blue" class=""><font size="3" class="">nir.simionovich@gmail.com</font></span></a><span style="color:rgb(31,73,125)" class=""></span></span></div><font size="3" face="Times New Roman" style="color:rgb(34,34,34);line-height:normal" class=""></font><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;line-height:normal;margin:0in 0in 0pt" class=""><span style="font-family:"courier new"" class=""><font size="3" class=""> (f) <a href="tel:073-255-7202" value="+972732557202" target="_blank" class="">+972-73-2557202</a> <span class="m_3651031521499455850inbox-inbox-inbox-inbox-Apple-converted-space"> </span>(SKYPE): greenfieldtech.nir</font></span></div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;line-height:normal;margin:0in 0in 0pt" class=""><br class=""></div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;line-height:normal;margin:0in 0in 0pt" class=""><span style="font-family:"courier new"" class=""><font size="3" class="">----------------------------------------------------------</font></span></div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;line-height:normal;margin:0in 0in 0pt" class=""><span style="font-family:"courier new"" class=""><font size="3" class=""> <a href="https://mailstrom.co/referral/ARZJE" style="color:rgb(17,85,204)" target="_blank" class="">Zero Your Inbox</a> | <a href="https://www.digitalocean.com/?refcode=97eeea09917a" style="color:rgb(17,85,204)" target="_blank" class="">Cloud Servers</a></font></span></div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;line-height:normal;margin:0in 0in 0pt" class=""><span style="font-family:"courier new"" class=""><font size="3" class="">----------------------------------------------------------</font></span><span style="font-family:calibri;font-size:14px;line-height:0px" class=""> </span></div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;margin:7.5pt 0in 0pt;line-height:0px" class=""><span style="font-family:"courier new"" class=""></span><br class="m_3651031521499455850webkit-block-placeholder"></div><font size="3" face="Times New Roman" style="color:rgb(34,34,34);line-height:normal" class=""></font><font face="Times New Roman" style="color:rgb(34,34,34);font-size:small;line-height:normal" class=""></font><table border="0" cellspacing="3" cellpadding="0" style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;line-height:normal" class=""><tbody class=""><tr class=""><td style="margin:0px" class=""><font face="Times New Roman" class=""></font></td></tr></tbody><tbody class=""><tr class=""><td style="margin:0px;padding:0.75pt;border:rgb(0,0,0);background-image:initial;background-size:initial;background-origin:initial;background-clip:initial;background-position:initial;background-repeat:initial" class=""><font face="Times New Roman" class=""></font><div style="margin:0in 0in 0pt" class=""><b class=""><span style="font-family:"courier new"" class="">Disclaimer:</span></b><br class=""></div><div style="margin:0in 0in 0pt" class=""><span style="font-family:"courier new"" class="">This e-mail is intended solely for the person to whom it is addressed and may contain confidential or legally privileged information. Access to this e-mail by anyone else is unauthorized. If an addressing or transmission error has misdirected this e-mail, please notify the author by replying to this e-mail and destroy this e-mail and any attachments.<span class="m_3651031521499455850inbox-inbox-inbox-inbox-Apple-converted-space"> </span><br class="">E-mail may be susceptible to data corruption, interception, unauthorized amendment, viruses and delays or the consequences thereof. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing or copying of this email is strictly prohibited.</span></div></td></tr></tbody></table></div></div>
-- <br class="">_____________________________________________________________________<br class="">-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com/" target="_blank" class="">http://www.api-digital.com</a> --<br class=""><br class="">asterisk-dev mailing list<br class="">To UNSUBSCRIBE or update options visit:<br class=""> <a href="http://lists.digium.com/mailman/listinfo/asterisk-dev" target="_blank" class="">http://lists.digium.com/mailman/listinfo/asterisk-dev</a></div></blockquote></div><br class=""></div></div>--<br class="">
_____________________________________________________________________<br class="">
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com/" rel="noreferrer" target="_blank" class="">http://www.api-digital.com</a> --<br class="">
<br class="">
asterisk-dev mailing list<br class="">
To UNSUBSCRIBE or update options visit:<br class="">
<a href="http://lists.digium.com/mailman/listinfo/asterisk-dev" rel="noreferrer" target="_blank" class="">http://lists.digium.com/mailman/listinfo/asterisk-dev</a></blockquote></div><div dir="ltr" class="">-- <br class=""></div><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr" class=""><div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: small; line-height: normal; margin: 0in 0in 0pt;" class=""><font size="3" class=""><span style="font-family:"courier new"" class="">Kind Regards,</span><span style="color:rgb(31,73,125)" class=""></span></font></div><font size="3" face="Times New Roman" style="color:rgb(34,34,34);line-height:normal" class=""></font><div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: small; line-height: normal; margin: 0in 0in 0pt;" class=""><font size="3" class=""><span style="font-family:"courier new"" class=""> Nir Simionovich</span><span style="color:rgb(31,73,125)" class=""></span></font></div><font size="3" face="Times New Roman" style="color:rgb(34,34,34);line-height:normal" class=""></font><div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: small; line-height: normal; margin: 0in 0in 0pt;" class=""><font size="3" class=""><span style="font-family:"courier new"" class=""> GreenfieldTech</span><span style="color:rgb(31,73,125)" class=""></span></font></div><div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: small; line-height: normal; margin: 0in 0in 0pt;" class=""><font size="3" class=""><span style="font-family:"courier new"" class=""> (schedule) </span></font><font face="Courier New" size="3" class=""><a href="http://nirsimionovich.appointy.com/" target="_blank" style="color:rgb(17,85,204)" class="">http://nirsimionovich.appointy.com/</a></font></div><font size="3" face="Times New Roman" style="color:rgb(34,34,34);line-height:normal" class=""></font><div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: small; line-height: normal; margin: 0in 0in 0pt;" class=""><span style="font-family:"courier new"" class=""><font size="3" class=""> (w)<span class="inbox-inbox-inbox-inbox-Apple-converted-space"> </span></font><a href="http://www.greenfieldtech.net/" target="_blank" style="color:rgb(17,85,204)" class=""><span style="color:blue" class=""><font size="3" class="">http://www.greenfieldtech.net</font></span></a><font size="3" class=""> </font></span></div><font size="3" face="Times New Roman" style="color:rgb(34,34,34);line-height:normal" class=""></font><div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: small; line-height: normal; margin: 0in 0in 0pt;" class=""><span style="font-family:"courier new"" class=""><font size="3" class=""> (p) +972-73-2557799 <span class="inbox-inbox-inbox-inbox-Apple-converted-space"> </span>(MSN):<span class="inbox-inbox-inbox-inbox-Apple-converted-space"> </span></font><a href="mailto:nirs@greenfieldtech.net" target="_blank" style="color:rgb(17,85,204)" class=""><span style="color:blue" class=""><font size="3" class="">nirs@greenfieldtech.net</font></span></a></span></div><font size="3" face="Times New Roman" style="color:rgb(34,34,34);line-height:normal" class=""></font><div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: small; line-height: normal; margin: 0in 0in 0pt;" class=""><span style="font-family:"courier new"" class=""><font size="3" class=""> (m) +972-54-6982826 <span class="inbox-inbox-inbox-inbox-Apple-converted-space"> </span>(GTALK):<span class="inbox-inbox-inbox-inbox-Apple-converted-space"> </span></font><a href="mailto:nir.simionovich@gmail.com" target="_blank" style="color:rgb(17,85,204)" class=""><span style="color:blue" class=""><font size="3" class="">nir.simionovich@gmail.com</font></span></a><span style="color:rgb(31,73,125)" class=""></span></span></div><font size="3" face="Times New Roman" style="color:rgb(34,34,34);line-height:normal" class=""></font><div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: small; line-height: normal; margin: 0in 0in 0pt;" class=""><span style="font-family:"courier new"" class=""><font size="3" class=""> (f) +972-73-2557202 <span class="inbox-inbox-inbox-inbox-Apple-converted-space"> </span>(SKYPE): greenfieldtech.nir</font></span></div><div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: small; line-height: normal; margin: 0in 0in 0pt;" class=""><br class=""></div><div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: small; line-height: normal; margin: 0in 0in 0pt;" class=""><span style="font-family:"courier new"" class=""><font size="3" class="">----------------------------------------------------------</font></span></div><div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: small; line-height: normal; margin: 0in 0in 0pt;" class=""><span style="font-family:"courier new"" class=""><font size="3" class=""> <a href="https://mailstrom.co/referral/ARZJE" target="_blank" style="color:rgb(17,85,204)" class="">Zero Your Inbox</a> | <a href="https://www.digitalocean.com/?refcode=97eeea09917a" target="_blank" style="color:rgb(17,85,204)" class="">Cloud Servers</a></font></span></div><div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: small; line-height: normal; margin: 0in 0in 0pt;" class=""><span style="font-family:"courier new"" class=""><font size="3" class="">----------------------------------------------------------</font></span><span style="font-family: calibri; font-size: 14px; line-height: 0px;" class=""> </span></div><div style="color: rgb(34, 34, 34); font-family: arial, sans-serif; font-size: small; margin: 7.5pt 0in 0pt; line-height: 0px;" class=""><span style="font-family:"courier new"" class=""></span><br class="webkit-block-placeholder"></div><font size="3" face="Times New Roman" style="color:rgb(34,34,34);line-height:normal" class=""></font><font face="Times New Roman" style="color:rgb(34,34,34);font-size:small;line-height:normal" class=""></font><table border="0" cellspacing="3" cellpadding="0" style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;line-height:normal" class=""><tbody class=""><tr class=""><td style="margin:0px" class=""><font face="Times New Roman" class=""></font></td></tr></tbody><tbody class=""><tr class=""><td style="margin:0px;padding:0.75pt;border:rgb(0,0,0);background-image:initial;background-size:initial;background-origin:initial;background-clip:initial;background-position:initial;background-repeat:initial" class=""><font face="Times New Roman" class=""></font><div style="margin: 0in 0in 0pt;" class=""><b class=""><span style="font-family:"courier new"" class="">Disclaimer:</span></b><br class=""></div><div style="margin: 0in 0in 0pt;" class=""><span style="font-family:"courier new"" class="">This e-mail is intended solely for the person to whom it is addressed and may contain confidential or legally privileged information. Access to this e-mail by anyone else is unauthorized. If an addressing or transmission error has misdirected this e-mail, please notify the author by replying to this e-mail and destroy this e-mail and any attachments.<span class="inbox-inbox-inbox-inbox-Apple-converted-space"> </span><br class="">E-mail may be susceptible to data corruption, interception, unauthorized amendment, viruses and delays or the consequences thereof. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing or copying of this email is strictly prohibited.</span></div></td></tr></tbody></table></div></div>
-- <br class="">_____________________________________________________________________<br class="">-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" class="">http://www.api-digital.com</a> --<br class=""><br class="">asterisk-dev mailing list<br class="">To UNSUBSCRIBE or update options visit:<br class=""> <a href="http://lists.digium.com/mailman/listinfo/asterisk-dev" class="">http://lists.digium.com/mailman/listinfo/asterisk-dev</a></div></blockquote></div><br class=""></body></html>