DB API

[Mike Apted]

Check out:

http://www.webtechniques.com/archives/2000/01/jepson/

Covers different DB's and their pros and cons.

>From: Simon Faulkner <News at Titanic.co.uk>
>To: python-list at python.org
>Subject: Re: DB API
>Date: Sun, 02 Jan 2000 19:44:42 GMT
>
>Thanks for the reply...
>
> >> with most^H^H^H^Hall database servers<<
>Is this a typo or am I missing something?
>
>I have my database working online!!!  GREAT!
>
>Which database do you recommend?  MySQL is free (or v. cheap)
>
>I am keen to try everything.
>
>TIA
>
>Simon
>
>On 2 Jan 2000 12:13:17 GMT, boud at rempt.xs4all.nl (Boudewijn Rempt)
>wrote:
>
> >Simon Faulkner <News at titanic.co.uk> wrote:
> >> Hi All,
> >
> >> Where can I find the instructions for the DB API?
> >
> >> I have managed to figure out the .connect() and .fetchone() methods
> >> but am flagging with the rest.
> >
> >> The Python Database API Specification 2.0 document does not realy show
> >> me the methods or examples that I need to get started and the MySQLdb
> >> documentation is deliberatly vague to discourage use of the _mysql.
> >> methods (so you use the proper API?)
> >
> >If you're using to MySQL, then you'd better not go to far using all
> >the options and stuff from DB-API II - if you use connect, execute and
> >fetchall, you've exhausted the capabilities of the database. No need
> >for commit, rollback or things like that - MySQL doesn't support them.
> >There's one area where MySQL has functionality beyond DB-API II, and
> >that's in the area of autoincrement columns, where you can get quite
> >easily get back the autoincrement values back after insertion.
> >
> >Also, with most^H^H^H^Hall database servers, what you really need to do 
>is
> >ask for a few rows, and fetch them immediately from the server. Keeping
> >large resultsets on the server and nibbling piecemeal from them is a
> >recipe for performance problems.
>
>Simon Faulkner
>--
>http://www.python.org/mailman/listinfo/python-list

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com