SQLite and migrations

Rails
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

On 3/7/07, Aurélien Malisart [email protected] wrote:

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?

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…