Home Original page

DB API

Simon Faulkner News at Titanic.co.uk
Sun Jan 2 14:44:42 EST 2000 
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
More information about the Python-list mailing list