[DB-SIG] Re: [Python-Dev] database APIs

[Luke Kenneth Casson Leighton]

On Sun, Feb 02, 2003 at 02:30:37PM -0600, Ian Bicking wrote:

> On Sun, 2003-02-02 at 09:51, Kevin Jacobs wrote: 
> > > also for some of the background please see the advogato article
> > > http://advogato.org/article/600.html particularly the link to
> > > jmg's code which contains some very simple to use but obscure 
> > > coding methods to wrap SQL databases in objects.
> > 
> > We (my company) and many others have their own SQL generation and OR mapping
> > implementations that are considerably more advanced.  Some (like mine) are
> > in the process of transitioning to an open source development model, while
> > some are already freely available (see http://colorstudy.com/software/SQLObject
> > for one released just last week).  So maybe it is time for all of us to get 
> > together and put the Open Source "bazaar" to the test and see what comes out.
> 
> There is a list of a number of such interfaces here:
> http://www.python.org/cgi-bin/moinmoin/HigherLevelDatabaseProgramming
> 
> If there's any missing I hope someone will extend them.  Currently
> listed are:
> 
> DbObj
> db_row
> ll.sql
> PgResultSet
> MiddleKit
> Object Relational Membrame
> PyDo
> SQLBuilder
> SQLDict
> SQLObject
> 
> In various forms these address exactly what Luke was proposing.

GREAT!

example, the next application is a replacement for an extremely
poorly written php app.

it contains classes (base class a db class that does the db connection)

the classes basically take a unique primary key, do a SELECT,
record the row of info in the class instance as variables,
then obviously it's possible to modify any of the variables,
then there's a save() method.

_all_ of this code has been hand-crafted!

madness!

take the SQL file, auto-generate the darn code, for pity's sake.


i've been working some way towards this "ideal" goal.

see http://sf.net/projects/pysqldb.

more later, have a real-world application / customer to keep happy :)

l.