A few months ago I read about ORMs and (SQLAlchemy in particular) and decided it was time to start using them in my scripts for database access.

Now, I have no problem writing some SQL. But being able to handle database information as objects and getting closer to database independence (e.g. SQLite vs. MySQL) seemed like a good thing. So after hearing about how Django will be including SQLAlchemy in the future, I decided it was time to give it another try.

I made sure pysqlite was up to date, and installed SQLAlchemy via easy_install.

Much to my surprise I found that between the excellent 0.2 documentation on the main site, and some helpful tutorials on the web, I was able to start creating/updating databases in no time.

Also, as a side note, I had no problem getting SQLAlchemy to work with the built-in SQLite3 in Python 2.5.

This entry was posted on Sunday, October 8th, 2006 at 5:14 pm and is filed under Programming, Python, Software. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.