| 337 | | '''SQLAlchemy''' I assume you guys are aware of it and have perhaps already looked into it, but if not (isn't mentioned here, I didn't follow all previous threads on the list) you might want to look at how SQLAlchemy handles this -- fundamentally a bit different of course as SA is not ActiveRecord-ish (without using one of its "extensions") but perhaps still useful. Maybe start here: http://sqlalchemy.org/docs/adv_datamapping.myt#advdatamapping_inheritance ''-ToddG'' |
| 338 | | |
| 339 | | '''PostgreSQL''' Please, take in account that PostgreSQL support that kind of inheritance at database level (see: [http://www.postgresql.org/docs/8.1/interactive/ddl-inherit.html]) would be nice that in case one uses postgresql that inheritance to be used instead of the JOIN's approach. Dunno if other databases support inheritance. |
| 340 | | |
| 341 | | Section "5.8.1 Caveats" on the above mentioned doc site shows that PostgreSQL implementation of inheritance might not |
| 342 | | be mature enough. |
| 343 | | |
| 344 | | '''!SqlObject''' I have used inheritence in !SqlObject, and at first it was buggy (about two years ago) then they fixed it and it worked great. A very important feature for me, and I liked the way they did it. [http://www.sqlobject.org/Inheritance.html] |
| | 337 | * '''SQLAlchemy''' I assume you guys are aware of it and have perhaps already looked into it, but if not (isn't mentioned here, I didn't follow all previous threads on the list) you might want to look at how SQLAlchemy handles this -- fundamentally a bit different of course as SA is not ActiveRecord-ish (without using one of its "extensions") but perhaps still useful. Maybe start here: http://sqlalchemy.org/docs/adv_datamapping.myt#advdatamapping_inheritance ''-ToddG'' |
| | 338 | ** You might have a look at [Elixir http://elixir.ematia.de/], as it seems to be an ActiveRecord-style ORM (a la Django's ORM) that is built on top of SQLAlchemy. -- Chris W. |
| | 339 | |
| | 340 | * '''PostgreSQL''' Please, take in account that PostgreSQL support that kind of inheritance at database level (see: [http://www.postgresql.org/docs/8.1/interactive/ddl-inherit.html]) would be nice that in case one uses postgresql that inheritance to be used instead of the JOIN's approach. Dunno if other databases support inheritance. Section "5.8.1 Caveats" on the above mentioned doc site shows that PostgreSQL implementation of inheritance might not be mature enough. |
| | 341 | |
| | 342 | * '''!SqlObject''' I have used inheritence in !SqlObject, and at first it was buggy (about two years ago) then they fixed it and it worked great. A very important feature for me, and I liked the way they did it. [http://www.sqlobject.org/Inheritance.html] |