SQL for logging?

Ideas, discussions about all topics - no matter how brilliant or stupid they are. Place for hobby-psychatrists, hobby-architects, hobby-scientists, hobby-whatever...
Post Reply
User avatar
^rooker
Site Admin
Posts: 1469
Joined: Fri Aug 29, 2003 8:39 pm

SQL for logging?

Post by ^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.
Jumping out of an airplane is not a basic instinct. Neither is breathing underwater. But put the two together and you're traveling through space!
Post Reply