Hi Enrico, Well I have been looking at using a nice light weight C logger.....and played around with LOG4C, Panthious have and also checked out using syslog-ng, matlog and standard syslog....but in the end decided that for this specific application an SQLite logger would work well.....
I am already using SQLIte as a queue so the administrators are already comfortable using the SQLite command line ;-) Lynton On 10/05/2011 11:52, Enrico Thierbach wrote: > Hi Lynton, > > I don't think sqlite (or any SQL database, for that matter) is a perfect fit > for a logger, because there is a certain amount of write overhead. > Why do you think you would want to do this? > > /eno > > On 10.05.2011, at 10:09, Lynton Grice wrote: > >> Hi there, >> >> SQLite is a perfect fit for a logger, the only question I have is once >> it is in production my database will grow rapidly, how can I implement / >> mimic a type of "rotating log"? >> >> So in my mind I am thinking that perhaps I can LIMIT the size of the >> SQLIte DB to say 5 MB? And once the DB reaches that size it starts >> INSERTING new logs over the earliest records in the database? >> >> Is this possible? >> >> Thanks for the help >> >> Lynton >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users