Tag: sql

Using Migrations to Insert Content

Migrations have made “Rails”:http://www.rubyonrails.org development so much easier by being able to code our SQL “data definations”:http://en.wikipedia.org/wiki/Data_Definition_Language in “Ruby”:http://www.ruby-lang.org. You can also use migrations to code in some data too. To do this you just access the models as you would in any other “Rails”:http://www.rubyonrails.org file. For example, if you want to add to rows …

Read more

Using Scripts to Automate SQL

Well I am getting my svk setup here to do some development on a few projects and I decided to try to get some automation in the setup. Seeing as I am currently hacking on Typo, I wanted someway for me to checkout the code from svk, setup my configs, and then put some test …

Read more

Choosing Names in Your Database

At work I was working on a simple Ruby on Rails project that is basically going to use CRUD to store, edit, and view information, something simple. I kept getting really weird errors with my scaffolding. After much mangling done with my database and code I found the problem was that I named a field …

Read more