Re: [Astlinux-users] CDR and sqlite database management

2015-07-02 Thread Michael Knill
Thanks Lonnie Yes I have been writing a billing tab for a hotel and its not only much much faster, its actually much easier so sqlite3 is now my standard. I do it using your option 2. Looks like I will need to test it out. Regards Michael Knill On 2 Jul 2015, at 11:20 pm, Lonnie Abelbeck wr

Re: [Astlinux-users] CDR and sqlite database management

2015-07-02 Thread Lonnie Abelbeck
Hi Michael, In case you were not aware, there are two ways to log CDR's using sqlite3 in Asterisk. 1) cdr_sqlite3_custom Older solution with sqlite3 built into Asterisk. 2) cdr_adaptive_odbc Newer, more general solution, where the unixodbc sqlite3 driver is used. CDR Call Logging with SQL ht

[Astlinux-users] CDR and sqlite database management

2015-07-01 Thread Michael Knill
Hi group I have decided to use sqlite for cdr recording as its sooo much faster than csv. Im just concerned about managing database size. What is the best way to do this? Cron query? Is it already being done? Regards Michael Knill