SQL for logging?

[^rooker]

I was just asking myself: Why don't people use a database (e.g. MySQL) for general logging purposes?

It's sometimes really hard to gather information from several logs which must manually be brought into correlation in order to track down certain events. If apps would have a somewhat common logging format and all write into a database, I could do a:

Code: Select all

select * from entry where type='error' and (timestamp > xxx and timestamp < yyy) and debuglevel > 3

or something like that. Don't have much time now to think it through. just an idea.