Not coincidentally, just before PyCon I am announcing the start of a
new project, SQLObject 2 and SQL-API. To be quite honest, I have had a
hard time maintaining SQLObject, and have not given it the attention
it should. I expect I am not the only one who created something that
I later found difficult to work with; that I myself am responsible for
all the problems, and made all the bad decisions, makes it worse --
for every problem I could go and fix it, but I can't fix them all as
they come in (or I might just be opening up other problems), and as
a result I don't fix any. Oleg
Broytmann has done a good job giving it the project the more
consistent attention that I have not, but when you are working on a
project written by someone else it can be hard to make certain
changes. This is my own attempt to make those changes I see as
necessary.
This package will both more and less than SQLObject 0.x. It does less
because several things have been moved to SQL-API, and ideally SQLObject
will only be asked to do what it does well, and will not have to address all
needs simply because it will be friendlier to other techniques working
in the same application.
SQL-API itself is
intended to be a neutral front-end to DB-API compliant databases,
providing many of the details that are important to usability but not
included in the DB-API. Ideally SQL-API can provide
infrastructure for other database packages; if you are interested
please contact me, or catch me at PyCon, or IRC, or email, or whatever.
I want SQL-API to be as
neutral as possible, but the only way to really ensure that is for
other people to use it in very different ways than I am using it in SQLObject. If
you just plain can't use SQL-API for some technical reason, then
that's a bug (though you don't have to use all of it to make use of
some of it).
So... there you go. Read the pages for the nitty-gritty (though I
apologize that the SQL-API page is a little light yet). Looking
forward to seeing some of y'all at PyCon.