[Asterisk-Dev] Current database abstraction effort ?

Chris Albertson chrisalbertson90278 at yahoo.com
Tue Jan 6 11:51:34 MST 2004

--- david <david at atcomm.com> wrote:

> My question is, why do you need to write the CDR to a database in the
> first
> place?  The applications that read this type of data are used to
> accessing
> it as clear text (ASCII).  This has been picked up in the past from
> RS-232

I assume to enable a new class of applications.  Say you want to
display up to the second data via a web interface.  One example
of this is my "Iconnect" account.  I can make a call, hang up
and then click "refresh" in a browser window on my PC and see that
the call I just hung up cost me five cents.

Even if you don't care about billing because you are switching
between office extensions as a phone system usier I might want to
look up whoit was that called me at about 4:00pm last Tuesday
for whateer reason.

Also you talk about "applications" that read CDR date.  These
"applications" mighbecome triveal two line scripts of the CDR
data were in a SQL database as one line id SQL can equal about
1000 lines of C code.

One more use for a DBMS.  A DBMS allows multiple symultainus
writes from any number of Asterisk servers you might have in
you rack.  And (unless you use MySQL) reading the database
does NOT lock out writes  As you _will_ need multiple * boxes
for a large system supporting concurent writes may be important.

Using a DBMS a reader program will never see a half written
record either.  DBMS querries are "atomic" so you eliminate
race conditions associated with concurrent access to text files

Chris Albertson
  Home:   310-376-1029  chrisalbertson90278 at yahoo.com
  Cell:   310-990-7550
  Office: 310-336-5189  Christopher.J.Albertson at aero.org

Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes

More information about the asterisk-dev mailing list