Python + RDBM framework?

[bukzor]

On Jun 14, 10:43 am, Larry Bates <larry.ba... at websafe.com`> wrote:
> bukzor wrote:
> > It seems that whenever I have an application that uses a database
> > (MySQL) I end up writing a database framework from scratch. Is there
> > some accepted pre-existing project that has done this?
>
> > I see Django, but that seems to have a lot of web-framework that I
> > don't (necessarily) need. I just want to have my objects go in and out
> > of the database in a consistent manner without writing a ton of code.
> > Can you just use the database part without making a full-blow web app?
>
> > I see Zope, but that doesn't use MySQL (as far as I can tell), which
> > I've invested a lot of time learning to use and optimize. Also, my
> > manager wants to be able to log into a MySQL prompt and be able to
> > look at the data.
>
> > --Buck
>
> Zope definitely has MySQL interface, but if you think Django is a lot then Zope
> is even more.  If I'm understanding your correctly what you want is ORM/  These
> links should help:
>
> http://pythonnotes.blogspot.com/2004/09/python-orm-tools.htmlhttp://www.sqlalchemy.org/http://www.sqlobject.org/
>
> -Larry

Both of those would work. I have a lot of data-integrity checks to
make that would be impossible at the MySQL level and hard at the
python/MySQLdb level. This will help a lot. I'll probably use the
SQLAlchemy.

Thanks so much!
--Buck