Hi Maxim,

I agree that this would be a useful feature. The reason why this hasn't been implemented yet is that this is only a small part of a very difficult topic that is schema migration. Once you start going down this road, people will expect more of it. For example, changing the data types of your properties, deleting properties, normalizing or splitting tables, etc etc. This almost becomes impossible to do 'automatically'. You say that Hibernate supports this, but I've never really seen it working reliably. When I for example upgrade Confluence, it's recommended by Atlassian to dump the entire DB and recreate it from scratch instead of using the schema migration functionality.

There are difficult questions that come into play with regards to what happens with existing data, how to handle complex relations that rely on other modifications, etc etc. If you couple these with the fact that many databases don't expose a lot of information through JDBC meta data, it can become very tricky next to impossible to do right.

I personally prefer thinking more along the lines of a schema migration framework, like what Rails provides. We kind of discussed this on the list a while ago, but nobody ever got enough time to implement it until now:
http://www.nabble.com/CRUD-and-Table-Creation-tf1652964.html#a4606148

Best regards,

Geert


On 25 Dec 2006, at 17:21, Maxim Grigoriev wrote:


I've just created this issue
http://uwyn.com/issues/browse/RIFECRUD-4
I think it will be very usefull feature.
--
View this message in context: http://www.nabble.com/Make- CreateCrudStructureParticipant-to-update-db-schema- tf2879818.html#a8047477
Sent from the RIFE - users mailing list archive at Nabble.com.

_______________________________________________
Rife-users mailing list
[email protected]
http://lists.uwyn.com/mailman/listinfo/rife-users


--
Geert Bevin
Uwyn "Use what you need" - http://uwyn.com
RIFE Java application framework - http://rifers.org
Music and words - http://gbevin.com


_______________________________________________
Rife-users mailing list
[email protected]
http://lists.uwyn.com/mailman/listinfo/rife-users

Reply via email to