Sqlite3 gem not supported on Heroku

When I tried to deploy second part of RoR tutorial to Heroku I get this error:

       An error occurred while installing sqlite3 (1.3.5), and Bundler cannot continue.
       Make sure that `gem install sqlite3 -v '1.3.5'` succeeds before bundling.
 !
 !     Failed to install gems via Bundler.
 !
 !     Detected sqlite3 gem which is not supported on Heroku.
 !     http://devcenter.heroku.com/articles/how-do-i-use-sqlite3-for-development
 !
 !     Heroku push rejected, failed to compile Ruby/rails app

To git@heroku.com:thawing-beyond-7283.git
 ! [remote rejected] master -> master (pre-receive hook declined)
error: failed to push some refs to 'git@heroku.com:thawing-beyond-7283.git'

I searched a little bit about this error and find this stackoverflow post. But when I look more carefully on the Gemfile syntax I found a mistake. I used simply:

gem 'sqlite3', '1.3.5'

But I should have:

group :development do
  gem 'sqlite3', '1.3.5'
end
group :production do
  gem 'pg', '0.12.2'
end

As RoR tutorial states.

Prepare for Ruby on Rails on Debian wheezy

I start to learn Ruby on Rails. As always when you learn new programming language toolchain is required. In this tutorial I will try to go through toolchain preparation for my Debian wheezy. Of course I based on Vim as my editor of choice. Second requirement will be using some parts of toolchain in latest greatest version.

As a beginner point for learning Ruby on Rails I choose this tutorial. I will try to use their methods of setting environment adding my comments where it is needed. Also will resolve Debian and Vim specific issues. So let's begin.

After quick look at RoR tutorial I have to switch to this site for installation for Ubuntu 12.04 LTS. But instructions don't work as expected for my Debian. So after quick:

sudo apt-get install git curl

I realized that I need proxy for curl and not only temporary but permanent. I added below line to my $HOME/.curlrc:

proxy=proxy.server.com:8080

After that I was able to download and install stable version of rvm:

curl -L get.rvm.io | bash -s stable

Next I sourced configuration:

source ~/.rvm/scripts/rvm

Output which I get was:

pietrushnic@lothlann:~/src/node$ rvm requirements
Requirements for Linux "Debian GNU/Linux wheezy/sid"

NOTE: 'ruby' represents Matz's Ruby Interpreter (MRI) (1.8.X, 1.9.X)
             This is the *original* / standard Ruby Language Interpreter
      'ree'  represents Ruby Enterprise Edition
      'rbx'  represents Rubinius

bash >= 4.1 required
curl is required
git is required (>= 1.7 for ruby-head)
patch is required (for 1.8 rubies and some ruby-head's).

To install rbx and/or Ruby 1.9 head (MRI) (eg. 1.9.2-head),
then you must install and use rvm 1.8.7 first.

Additional Dependencies:
# For Ruby / Ruby HEAD (MRI, Rubinius, & REE), install the following:
  ruby: /usr/bin/apt-get install build-essential openssl libreadline6 libreadline6-dev curl git-core zlib1g zlib1g-dev libssl-dev libyaml-dev libsqlite3-dev sqlite3 libxml2-dev libxslt-dev autoconf libc6-dev ncurses-dev automake libtool bison subversion pkg-config

# For JRuby, install the following:
  jruby: /usr/bin/apt-get install curl g++ openjdk-6-jre-headless
  jruby-head: /usr/bin/apt-get install ant openjdk-6-jdk

# For IronRuby, install the following:
  ironruby: /usr/bin/apt-get install curl mono-2.0-devel

I need Ruby so copy&paste line for it and:

sudo apt-get install build-essential openssl libreadline6 libreadline6-dev curl git-core zlib1g zlib1g-dev libssl-dev libyaml-dev libsqlite3-dev sqlite3 libxml2-dev libxslt-dev autoconf libc6-dev ncurses-dev automake libtool bison subversion pkg-config

Next thing we need is Node.js because this code of JavaScript runtime is under active development (latest version is 0.8.14 and Debian provided for sid 0.6.19) we use its latest greatest version from git repository.

git clone https://github.com/joyent/node.git

Following by:

cd node;./configure;make;make test

In my configuration only one test failed test-tls-server-verify:

Running 'Allow both authed and unauthed connections with CA1'

assert.js:102
  throw new assert.AssertionError({
        ^
AssertionError: agent1 rejected, but should NOT have been
    at ChildProcess. (/home/pietrushnic/src/node/test/simple/test-tls-server-verify.js:217:14)
    at ChildProcess.EventEmitter.emit (events.js:96:17)
    at Process.ChildProcess._handle.onexit (child_process.js:698:12)
    at process._makeCallback (node.js:248:20)

This is known issue probably we have to wait for update of OpenSSL library in wheezy. Ignore this problem and install node.js:

sudo make install

Because of RoR tutorial requirements we install version 1.9.3:

rvm get head && rvm reload
rvm install 1.9.3

Next thing will be adding vim-ruby for our favorite editor Vim. I organize my dotfiles using git. I also use pathogen to control Vim plugins (as described here), so :

cd workspace
git submodule add https://github.com/tpope/vim-rails.git dotfiles/vim/bundle/vim-rails
git submodule init && git submodule update
git commit -m "vim-rails submodule added"

Finally we have ready to use Ruby on Rails development environment based on Vim. I suggest to take a look at this movie and after that dive into tutorial.

New background and not so big "coming back"

It's been a long time since I last wrote anything on the blog. Because I hear complains about the background causing my blog hard to read I decide to change it.

I have little break in my side project and noticed that most read posts are related to some technical workarounds and solutions for different problems I decide to write a series about gcc errors and some solutions for it. I know it may sound like some complete spam and trash for blog, but when I searched for some explanation and solution of this errors sometimes it was hard to find them, sometimes it was hard to match with my code and finally sometimes I was unable to understand what is going on. I want to share what I learned and even if it wouldn't help anyone I want to have this in one place.

Recently I returned to my long-neglected hobby - chess. I will also try to write something constructive in this topic. Last time I also think a lot about embedded stuff (trying to reverse my printer), android (writing little project helping my colleague) and many other things. So maybe I will write about this. To not be boring I will simply get my hands dirty.