Quick and Dirty ORM
In January 2010 I decided to break from common database convention and design a new style of ORM. It was also an excuse to dive deeper into Python 3. The result is my Data Type Tables project, which currently only supports sqlite3.
Features:
- You don’t have to write any SQL to use it, not even create table statements. Right, you’re not impressed, given that you can do the same with Ruby on Rails. BUT, whatever.
- If you add fields to a class you still don’t have to write any SQL, or perform any migrations. The ORM handles it for you (read on to find out how).
- You can do simple relations, like Products in Categories.
- You can do trees, like Categories and Sub-Categories (to infinity).
- You get field-level revisions without having to do a thing. So when you update a Product’s name, all previous values are preserved. You can fetch the history if you need to.
However:
Continue reading