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. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On 3/7/07, Aurélien Malisart <aurelien.malisart@gmail.com> 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. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk@googlegroups.com To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
OK thanks. I thought to this solution... --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---