Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
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!


Comment on Re: Re: Re: Web Logs Using DBI
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 making s'mores by the fire in the courtyard of the Monastery: (8)
As of 2014-11-28 23:03 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My preferred Perl binaries come from:














    Results (200 votes), past polls