<?xml version="1.0" encoding="windows-1252"?>
<node id="253894" title="Re: Web Logs Using DBI" created="2003-04-28 23:58:05" updated="2005-07-07 14:27:49">
<type id="11">
note</type>
<author id="961">
Anonymous Monk</author>
<data>
<field name="doctext">
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-</field>
<field name="root_node">
7598</field>
<field name="parent_node">
251930</field>
<field name="reputation">
-1</field>
</data>
</node>
