SQLAlchemy

I don't usually blog about releases, especially point releases, but this one is pretty significant in that we've repaired some very severe speed bumps that were impacting the flush() process. Anyone working with large numbers of objects that has observed the Session to slow down as it gets bigger should download this release, as [...]

SQLAlchemy 0.5.4p1 Recommended for All Ages

Let's meditate on this for a moment. Oracle will own MySQL. time to take the postgres plunge ? (all those who haven't as of yet).

Oracle Buys.....MySQL ??!

As the 0.5 release of SQLAlchemy has now become available, here's a little retrospective on the "relational" nature of SQLAlchemy. SQLAlchemy's equal treatment of any relation and its deep transformational abilities of such are the core value that makes us highly unique within the database access/ORM field. It's the key to our [...]

SQLAlchemy - Breaking the 80% Barrier Since Day One

Wayne Witzel gives us a very nice tutorial on how to implement simple tagging with SQLAlchemy. It's a totally straightforward example with nice usage of 0.5 Query paradigms as well as some SQL expression language integration (which looks familiar from the ML the other day...).

Tags with SQLAlchemy

A few people have been asking about this one as of late, it's quite easy to do with a ConnectionProxy. Here's a quick recipe (yes, this is 0.5): from sqlalchemy.interfaces import ConnectionProxy import time import logging   logging.basicConfig() ... [More] logger = logging.getLogger("myapp.sqltime") logger.setLevel(logging.DEBUG)   class TimerProxy(ConnectionProxy): def cursor_execute(self, execute, cursor, statement, parameters, context, executemany): [...] [Less]

Ticket 798, allow conjunctions to act as column elements, is complete after a long wait, finally attended to for the great reason that I suddenly needed this feature myself ;). A few tweaks and we can now talk about asking yes/no questions of our database. As we head into the 0.5 era of SQLAlchemy, [...]