Home ›

The Python DB-API

Issue 49

From Issue #49
May 1998

May 01, 1998  By Andrew M. Kuchling
 in
A Python SIG has put together a DB-API standard; Mr. Kuchling gives us the details.
______________________

Comments

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Iteration?

Anonymous's picture
Submitted by Anonymous (not verified) on Mon, 04/02/2007 - 09:25.

I would rather do something more like this


cursor.execute(...)
for i in cursor:
   ...

clearer code

Anonymous's picture
Submitted by Anonymous (not verified) on Mon, 03/27/2006 - 10:30.

why
while (1):
instead of
while 1:

and
if attendee == None: break
instead of
if attendee is None: break

if you want to give an example, please give a good one, not just something that works, show how to write pythonic code

I wonder if you thought at all before posting

digginestdogg's picture
Submitted by digginestdogg (not verified) on Mon, 02/26/2007 - 23:51.

Sometimes, things are not as they appear to the casual, shallow minded observer.
AMK is no 'newbie' to Python. Rather like a skilled sensei teaching young would-be samurai, he simplied his technique so as not to distract his students with complexity but rather to let them focus on his lesson one simple point at a time.

Huahweuahwa

Anonymous's picture
Submitted by Anonymous (not verified) on Sun, 08/27/2006 - 01:23.

The real pythonic way of "saying" [if attendee is None: break]
is [if not attendee: break]
Remember, nothing is so good that can not be better . . .
If you want to correct someone, do this better next time.

Hey Andrew, nice code, your tutorial is the only link at PyGreSQL page, continue helpping people that are realy capable of learnning something.

Huahweuahwa

Anonymous's picture
Submitted by Anonymous (not verified) on Sun, 08/27/2006 - 01:18.

The real pythonic way of "saying" [if attendee is None: break]
is [if not attendee: break]
Remember, nothing is so good that can not be better . . .
If you want to correct someone, do this better next time.

You certainly don't know who

Anonymous's picture
Submitted by Anonymous (not verified) on Mon, 06/26/2006 - 18:35.

You certainly don't know who AMK is.

Well, as a python

Anonymous's picture
Submitted by Anonymous (not verified) on Mon, 04/03/2006 - 18:47.

Well, as a python programmer, it could have been better, but since it's about using the API, and not how to write good python, it's still a good example.

Re: The Python DB-API

Anonymous's picture
Submitted by Anonymous on Fri, 04/05/2002 - 03:00.

This is useful. Thanks.

Re: The Python DB-API

Anonymous's picture
Submitted by Anonymous on Wed, 04/09/2003 - 02:00.

Good writing-hack. Thanx a lot, 'cause it was so useful.

LINUX POWER TO U ;o)

This is really helpful to beg

Anonymous's picture
Submitted by Anonymous (not verified) on Fri, 03/18/2005 - 06:05.

This is really helpful to beginners to give them idea what is like DB programming with Python. Thanks!

nice :) There's a small ty

Anonymous's picture
Submitted by Anonymous (not verified) on Tue, 05/17/2005 - 03:12.

nice :)

There's a small typo in one of the code samples where &Gt appears literally (it comes out as >>&Gt instead of >>>)

Thanks.

This is really helpful to beg

Anonymous's picture
Submitted by Anonymous (not verified) on Fri, 03/18/2005 - 06:01.

This is really helpful to beginners to give them idea what is like DB programming with Python. Thanks!

Webcast
More Resources
How to Build an Optimal Hadoop Cluster to Store and Maintain Unlimited Amounts of Data Using Microservers

Realizing the promise of Apache® Hadoop® requires the effective deployment of compute, memory, storage and networking to achieve optimal results. With its flexibility and multitude of options, it is easy to over or under provision the server infrastructure, resulting in poor performance and high TCO. Join us for an in depth, technical discussion with industry experts from leading Hadoop and server companies who will provide insights into the key considerations for designing and deploying an optimal Hadoop cluster.

Learn More

Sponsored by AMD

White Paper
More Resources
Red Hat White Paper: Using an Open Source Framework to Catch the Bad Guy

Built-in forensics, incident response, and security with Red Hat Enterprise Linux 6

Every security policy provides guidance and requirements for ensuring adequate protection of information and data, as well as high-level technical and administrative security requirements for a system in a given environment. Traditionally, providing security for a system focuses on the confidentiality of the information on it. However, protecting the data integrity and system and data availability is just as important. For example, when processing United States intelligence information, there are three attributes that require protection: confidentiality, integrity, and availability.

Learn more about catching the bad guy in this free white paper.

Learn More

Sponsored by DLT Solutions