Wednesday, August 13, 2008

One of the painful things about working with any database-oriented project in production is that you can't just drop the database and re-create every time you have a schema change. (Of course, you could do that, but your users might get a little miffed when their data disappears.) Rails and Django have for this reason had support for migrating from one schema version to another. Well, now SQLAlchemy has a automatic migrations tool by the name of Miruku. I haven't tried it, and it's an extremely early version (0.1a7), but it looks promising. Have a look here, and let me know what you think.

Thanks for the comments. As to Django, I guess I must have confused Rails migrations with Django. As for sqlalchemy-migrate, thanks for the pointer. I remember hearing about it before, but I wasn't too familiar with it. It looks like sqlalchemy-migrate even supports automatic script generation. I wonder if the two projects could benefit from one another...?

Search

Loading...

Useful Resources

Interested in practical MongoDB programming?

MongoDB Applied Design Patternsis available now, both in ebook and dead-tree form. In it, you'll see how to use MongoDB effectively in fields from real-time analytics to content management systems and more. The examples are all in Python, so readers of this blog should have no problem picking it all up.

Want to learn MongoDB using Python?

I just released an 84-page ebook MongoDB with Python and Ming to help you get started. In it, I cover everything from installing MongoDB for the first time, basic pymongo usage, MongoDB aggregation including MapReduce and the new aggregation framework, and GridFS. You'll also learn about Ming, the object-document mapper we built at SourceForge to accelerate our development beyond what we could do with PyMongo.

Pages

Rick's Resources

I'm collecting a list of products and services I've found useful in my work & leisure Python programming at Rick's Resources. If you're interested in that sort of thing, I'd love to have you check it out!