Database and Interface for Python

[Maciej Dziardziel]

Michael Foord wrote:

> I need to analyse this information by different criteria. E.g. How
> many users accessed the website between August 5th and August 12th,
> listed by refferer !! etc It would be great to have a database engine
> where I could ask these questions in just a couple of queries, rather
> than having to implement all the sort/analyse functions myself.
 
Just simply transfer those your data to database and then retrievieng
detailed information will be simple.

> I guess this is as bad a time as anyto start to learn to use a
> database !! So I look on google and the situation is a little unclear.
> I can use the database API that will give me a 'consistent
> interface'... but I still need a database engine installed. e.g.
> MySQL. Not only that but I need a python interface to that engine that
> the database API can use ?

Yes, you will need both database and python interface to access it.


> I think the web server I use will allow MySQL databases, so if I
> install it on my windoze box and install the MySQLdb python module
> then I'm well away....
 
Webserwer has nothing to do with database.
 
> Have I got it right ? Can I do 'date range' queries using MySQL,
> MySQLdb and the Python database API ?

Yes.

-- 
Maciej "Fiedzia" Dziardziel (fiedzia (at) fiedzia (dot) prv (dot) pl)
www.fiedzia.prv.pl