[Tutor] overview of how data is handled [getting dictionariesfrom sql cursor / generators]

Alan Gauld alan.gauld at blueyonder.co.uk
Wed May 19 14:57:23 EDT 2004

> On Tue, 18 May 2004, John Fabiani wrote:
> > The handling of data is like nothing I have ever done.  It's
> > like Delphi, Java, .Net or VFP.
> The approach that the DB API 2.0 takes is similar to Java's JDBC
> A 'cursor' object in Python behaves like a combination of a Java's
> 'java.sql.Statement' and 'java.sql.ResultSet'.

For info to those who may be puzzled by John's question (and
apologies if I've got it wrong!) but I think John is referring to
the way Delphi, VB and Java IDEs have "live data" controls that
allow you to drop the data directly from the database into a table
control on the GUI without writing any code (except the SQL,
and sometimes not even that!). Once the connection is made
you can see the real data in the cells, and modify it by simply
updating the cell contents etc.

By comparison JDBCs and Python's DBAPI are both fairly primitive
tools and therefore seem cumbersome.

Again, if I guessed wrong then apologies to all,

Alan G.

More information about the Tutor mailing list