[Asterisk-Users] CDR records into SQLite

[David Creemer]

On Jul 7, 2004, at 6:59 AM, brian wrote:

> I don't get why we need this.  cdr_odbc.c has this covered.  Also Josh 
> has
> some info on how to compile cdr_odbc using iodbc libs instead of 
> unixodbc.
>

Well not quite. As shipped I couldn't make cdr_odbc.c work with SQLite. 
I've patched it, and it works well for my purposes. If anyone wants to 
submit the patch please feel free to do so. I currently have CDR's 
logged via unixodbc-2.2.8 and the sqliteodbc-0.62 driver.

See http://www.sonic.net/~dcreemer/cdr_odbc-update.patch

-- David

> cdr_sqllite.c and cdr_tds.c were both written and not needed.  I'm not
> trying to discourage anyone from writing anything but why were these 
> needed?
>
> http://www.unixodbc.com/drivers.html
>
> bkw
>
>> -----Original Message-----
>> From: asterisk-users-admin at lists.digium.com [mailto:asterisk-users-
>> admin at lists.digium.com] On Behalf Of Holger Schurig
>> Sent: Wednesday, July 07, 2004 5:02 AM
>> To: asterisk-users at lists.digium.com
>> Subject: Re: [Asterisk-Users] CDR records into SQLite
>>
>>> Do you know how many thousands?
>>
>> No. This depends on your machine, the type of queries you make etc.
>>
>>
>>
>> But hey, as this uses SQL, you can add and drop indexes at will, even
>> while Asterisk has the cdr.db file open.
>>
>> For example, when you need to select quite often by the destination 
>> and
>> you think that is slow, then just create an index on-the-fly:
>>
>> $ sqlite /var/log/asterisk/cdr.db
>> SQLite version 2.8.0
>> Enter ".help" for instructions
>> sqlite> create index cdr_dst on cdr (dst);
>> sqlite> .exit
>>
>> See the documentation at http://www.sqlite.org (especially in their 
>> wiki)
>> for optimizations and so on. I only have a few records in the 
>> database,
>> because I don't (yet) use Asterisk in real life for the whole office.
>>
>> _______________________________________________
>> Asterisk-Users mailing list
>> Asterisk-Users at lists.digium.com
>> http://lists.digium.com/mailman/listinfo/asterisk-users
>> To UNSUBSCRIBE or update options visit:
>>    http://lists.digium.com/mailman/listinfo/asterisk-users
>
>
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users