Logging to DB

Is there any tried and tested way to log to a database?

There appears to be several options using fifo, syslog, etc floating
around, however, there seems to be some issues with certain options.

Any pointers would be welcome.

Thanks,

John

On 06/07/11 01:17, John Macleod wrote:

Is there any tried and tested way to log to a database?

There appears to be several options using fifo, syslog, etc floating
around, however, there seems to be some issues with certain options.

how to do this depend on acceptable delay.

If you need nearly real time info in DB:
tail -F /var/log/access.log | /path/to/writer_logs_to_db

If several minutes lag is acceptable, you can rotate logs and then load
full log
in single transaction.


Anton Y.

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs