<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hi Robert</p>
<div><br>
</div>
<div>A while back we had similar considerations regarding CDR. What
we ended up with, was to use the JSON CDR module for writing the
records to disk. Then we used an custom tool[1] to upload the
files to Google Cloud, where they may be indexed further.</div>
<div>The main idea was to store as much data as possible, as it may
come in handy later. Also, the database module seemed to lack some
of the information that we needed (eg. custom variables).</div>
<div>This worked very well for us, as we did not know from day 1
what information could be useful, and storing everything solved
exactly that.<br>
<br>
Have fun!</div>
/Kim<br>
<br>
[1] <a
href="https://github.com/Bitstackers/openreception/tree/master/tools/cdrctl">https://github.com/Bitstackers/openreception/tree/master/tools/cdrctl</a><br>
<br>
<div class="moz-cite-prefix">On 2017-07-17 17:19, robert mundkowsky
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:224992776.2280023.1500304763949@mail.yahoo.com">
<div style="font-family:Helvetica Neue, Helvetica, Arial,
sans-serif;font-size:medium;">
<div>
<p class="ydp9f36e60cMsoPlainText">What are the best practice
for writing Call Detail
Records (CDRs) to a database?</p>
<p class="ydp9f36e60cMsoPlainText"> </p>
<p class="ydp9f36e60cMsoPlainText">We are using custom code to
write CDR-like data to log
files and then later loading logs into a database.<span> </span>We
have very low usage right now, so I
suspect that we could just write directly to the database.<span>
</span>But as we scale, is it a better idea to not
write directly to the database?</p>
<p class="ydp9f36e60cMsoPlainText"> </p>
<p class="ydp9f36e60cMsoPlainText">Note I am not sure if we
need custom CDRs or if FS' CDR
module might be leveraged.<span> </span>I have to
look into that.</p>
<p class="ydp9f36e60cMsoPlainText"> </p>
<p class="ydp9f36e60cMsoPlainText"> </p>
<p class="ydp9f36e60cMsoPlainText">Robert</p>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
<a class="moz-txt-link-abbreviated" href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://www.freeswitchsolutions.com">http://www.freeswitchsolutions.com</a>
Official FreeSWITCH Sites
<a class="moz-txt-link-freetext" href="http://www.freeswitch.org">http://www.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://confluence.freeswitch.org">http://confluence.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://www.cluecon.com">http://www.cluecon.com</a>
FreeSWITCH-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a>
UNSUBSCRIBE:<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a>
<a class="moz-txt-link-freetext" href="http://www.freeswitch.org">http://www.freeswitch.org</a></pre>
</blockquote>
<br>
</body>
</html>