From: Sharon Rosner <ciconia@...>
Date: 2007-10-12T05:23:43+09:00
Subject: Re: SQLite and ruby


> what should i install, as a gem for example, in order to play with such
> a database ?
>

If you have the sqlite3 libs installed, you can install the sqlite3
gem:

  sudo gem install sqlite3-ruby

May I also suggest Sequel for a nice & simple API for 'playing' with
the database:

  sudo gem install sequel

Sequel lets you write stuff like this:

  require 'sequel/sqlite'

  # Open the database
  DB = Sequel.sqlite('mydb.sqlite')

  # Assuming the table name is 'people'
  class Person < Sequel::Model(:people)
    def capitalize
      p[:lastName].capitalize!
      p[:firstName].capitalize!
      p[:fullName].capitalize!
      save
    end
  end

  Person.each {|p| p.capitalize}

You can find out more about Sequel here:

  http://code.google.com/p/ruby-sequel/

The API is here:

  http://sequel.rubyforge.org/

best
Sharon