I am making my way through learning Ruby and Rails with a couple projects that I’ve always wanted to write. Rather than writing sample applications I find it a lot easier to learn if I have a need to use a tool, and these projects provide that need.

As I’m working through each one I’m discover gaps in what I have learned thus far, and have found these various tutorials helpful.

This list will continue to grow as I find more useful tutorials.

Posted in Programming, Ruby/Rails at May 25th, 2007. No Comments.

While working my way through Agile Web Development with Rails (yes I’m learning Rails and Ruby, more on this too later) I ran into the following error:

SQLite3::SQLException: near “ADD”: syntax error: ALTER TABLE products ADD “date_available” datetime

while trying to add a column through a migration. Searching Google took me to a couple of places, but it took a while to find a result that explained how to resolve this issue.

Luckily I came across this post by Mark Cornick, which explained that the issues was caused by the version of SQLite3 that is included in OS X 10.4.

After downloading and installing (from source) the latest version of SQLite3, and uninstalling and reinstalling the sqlite3-ruby gem

sudo gem uninstall sqlite3-ruby
sudo gem install sqlite3-ruby

I was able to run the migration to add the column and continue on.

Posted in Programming, Ruby/Rails at February 3rd, 2007. 4 Comments.