On 4/28/06, Peter S. firstname.lastname@example.org wrote:
Well, i did not have exactly this on my mind (nevertheless thx for the
points, i am thinking about switching to postgre), since these can be
corrected manually - but there were some issues with database integrity
(FK contraints are not enforced or something like this) which can cause
serious problems (or at least the writer of the mail claimed - i could
not find the thread).
Well, I don’t know about that… I mean for me I always write FKs
into migrations in an execute block because I am quite picky about
that sort of stuff. In the end, all a migration is is a way to deploy
changes to the DB - it’s just executing a chunk of ALTER TABLE or
whatever, so as long as you can verify that it’s doing what you expect
and putting the right FKs in, then it’s up to the DB to make sure that
Might the original author have been having troubles with a MyISAM
MySQL table? Perhaps the lack of transactions caused some problems?
Anyway, I use migrations regularly on my sites and although I do test
them with some vigour before I deploy them, I’ve yet to have a problem
apart from those I mentioned.
My 2c I guess.