Yes, this is the key issue on migrations: independent of DB engine. As to completely avoid the programmer using SQL: this is true when we're talking about DDL (Data Definition Language), i.e., when we define the structure, but you can still use 'raw' SQL when doing DML (Data Manipulation Language). This is not usually recomended, since you attach yourself to a specific DB engine, you should use an ORM like Active Record.
Cheers, :jb On Thu, Mar 3, 2011 at 9:38 PM, ivanpoval <ivanpo...@gmail.com> wrote: > Please, don't forget that the migrations are also provide u a pure > ruby DSL to operate over your DB structure. It means that they are > also independent from the DB driver (oracle or mysql or postgres). > -- > Thanks, Ivan Povalyukhin > > On Mar 2, 2:18 pm, David Kahn <d...@structuralartistry.com> wrote: > > On Wed, Mar 2, 2011 at 3:59 PM, Gaba Luschi <li...@ruby-forum.com> > wrote: > > > Are migrations used only when you're making changes to a database? > Does > > > it just allow the developer to avoid using raw SQL when working with > > > databases? > > > > Right. Not only does it allow the developer to use a much easier (IMO) > > manner to do things like add, modify columns, tables, etc, it also keeps > a > > record of the progression of your database schema. Migrations also > include > > the ability (assuming it is used) to roll back any changes with a command > > from a terminal. At times a migration may also contain data-transforming > > tasks or really any other ruby code one needs to write to complete the > > migration. > > > > > > > > > > > > > -- > > > Posted viahttp://www.ruby-forum.com/. > > > > > -- > > > 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+unsubscr...@googlegroups.com. > > > For more options, visit this group at > > >http://groups.google.com/group/rubyonrails-talk?hl=en. > > -- > 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+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/rubyonrails-talk?hl=en. > > -- 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+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
