Best way to process table rows from an RDBMS

[dananrg]

I can handle making the connections and running queries, but what's the
best way to process table rows returned in Python? What about turning a
table definition into an object? Just looking for ways to be efficient,
since I know I will be hitting the same external RDBMS from Python and
regularly processing a fixed set of tables with a certain fixed set of
attribute columns.

Is there something better than tuples for this?

 

[bruno at modulix]

I can handle making the connections and running queries, but what's the
best way to process table rows returned in Python?

depends on what you want to do with them.

What about turning a
table definition into an object? Just looking for ways to be efficient,
since I know I will be hitting the same external RDBMS from Python and
regularly processing a fixed set of tables with a certain fixed set of
attribute columns.

Before ReinventingTheSquareWheel(tm), you may want to have a look at
existing Python ORMs like SQLObjects or SQLAlchemy...