Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options

Re: Re: Re: Web Logs Using DBI

by stonecolddevin (Vicar)
on Apr 21, 2003 at 03:55 UTC ( #251930=note: print w/replies, xml ) Need Help??

in reply to Re: Re: Web Logs Using DBI
in thread Web Logs Using DBI

This is a neat article!!! You could really make things easier by writing a script to print all the info to the screen!!! Much easier that sorting through a .log file. You could even sort them by date and what not, so you only get that days, or even that time's specific error. Awesome!

Replies are listed 'Best First'.
Re: Web Logs Using DBI
by Anonymous Monk on Apr 29, 2003 at 03:58 UTC
    Hmmm, I've been logging using a similar approach (REAL similar, in fact. I think by default, you'd end up with the same table structure regardless of who put it together). But now the REAL question (and one I can't find ANY answer to: What magic SQL does one use to get anything worthwhile OUT of this data? Is there an that could help? Or is anybody interested in setting up a repository for useful open-sourced SQL code to handle log files? (i.e., glean the number of visitors? Number of visits? number of nonblack nonravens?) I've got a few queries I've hacked together, but nothing compared to the visions of loveliness I had in mind when I started logging this info a few months ago. -end fret-

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://251930]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (10)
As of 2016-10-21 11:36 GMT
Find Nodes?
    Voting Booth?
    How many different varieties (color, size, etc) of socks do you have in your sock drawer?

    Results (288 votes). Check out past polls.