SQLite and migrations

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.

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 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.

OK thanks. I thought to this solution…

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs