Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
PerlMonks  

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 SQLmonks.org 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?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (3)
As of 2016-08-25 01:31 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    The best thing I ever won in a lottery was:















    Results (352 votes). Check out past polls.