asterisk users - Jul 2004 - CDR records into SQLite

Hi !

I just wrote cdr_sqlite.c, see

http://bugs.digium.com/bug_view_advanced_page.php?bug_id=0001986

This little app creates automatically the sqlite database file in 
/var/log/asterisk/cdr.db, creates a table 'cdr' inside it and inserts
all
CDR records into this table.

Please comment.



I'll use this in my project DESTAR 
(http://www.holgerschurig.de/destar.html) to show these CDR records in 
some web form.

SQLITE is usually much easier to handle than mysql/postgressql, you don't 
need no running database daemon for it, yet it is very fast and supports 
SQL for ad-hoc queries.

> SQLITE is usually much easier to handle than mysql/postgressql, you
> don't 
> need no running database daemon for it, yet it is very fast and
> supports 
> SQL for ad-hoc queries.
Excellent addition to the source!

Also, sqlite in our experience is faster then Mysql/Postgres for our
needs.

Holger, Thanks very much :)