sqlite sorts null values differently than postgres

monkey_sort.rb

# say we have a Monkey with a boolean column

create_table :monkeys do |t|
  t.boolean :is_nice
end

Monkey.create()
Monkey.create(:is_nice => true)
Monkey.create(:is_nice => false)

# now we got 3 monkeys

# postgres:

Monkey.order(:is_nice).map &:is_nice
=> [false, true, nil]

# sqlite:

Monkey.order(:is_nice).map &:is_nice
=> [nil, false, true]

# Monkey business!!!

# next time do this:

create_table :monkeys do |t|
  t.boolean :is_nice, :default => true
end

# or you can default to false if you like mean monkeys