SQLite and migrations

rubyonrails-talk
1

Hello everybody.

Something intriguing me for a while: is sqlite full compatible with the Rails's migrations system?

I ask that because I know sqlite doesn't implement fully the SQL "standard" (e.g. see ALTER TABLE to learn that with ALTER TABLE, you cannot remove/edit any field, you are just able to rename the table or add a field).

Is the rails connector also limited or not? Does anyone contournated this problem by any way?

Thanks.

2

ActiveRecord::ConnectionAdapters::SQLiteAdapter actually creates a new table, puts stuff in, makes the change, then drops the old table and renames (moves) the new table back to the original one, so apparently this is circumvented...

d.

3

OK thanks. I thought to this solution...