[Asterisk-Users] CDR records into SQLite

[Brian K. West]

That is a very intresting patch... i'll see if I can test it.

bkw

----- Original Message ----- 
From: "David Creemer" <david at zachary.com>
To: <asterisk-users at lists.digium.com>
Sent: Wednesday, July 07, 2004 3:09 PM
Subject: Re: [Asterisk-Users] CDR records into SQLite


> 
> 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
> 
> _______________________________________________
> 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
>