[Asterisk-Users] CDR records into SQLite

[Holger Schurig]

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.