SQLite and migrations


#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 http://www.sqlite.org/lang_altertable.html 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 removed_email_address@domain.invalid wrote:

I ask that because I know sqlite doesn’t implement fully the SQL
“standard” (e.g. see http://www.sqlite.org/lang_altertable.html 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…