Is class table inheritance possible with MySQL and Rails? I saw John Wilger's cool yet complicated Postgres implementation. I have looked for a solution, but I can not find one. Are there any plans for class table inheritance for Rails in the future?
Mr. Interweb wrote:
Is class table inheritance possible with MySQL and Rails? I saw John Wilger's cool yet complicated Postgres implementation. I have looked for a solution, but I can not find one. Are there any plans for class table inheritance for Rails in the future?
I have hacked a plugin based on John Wilger's approach that automatically creates updateable views for PostgreSQL. However, it has no tests and resetting primary key sequences after fixture loading is an ugly hack. I plan to release it after fixing these deficiencies. It'd be very easy port it for other databases that support aggregate views (MySQL views as far as I know can be based only on a single table).