Chris Collins Chris Collins - 9 months ago 33
Ruby Question

What's the best way to talk to a database while using Sinatra?

As I understand it, the Sinatra framework, unlike Rails, does not provide an ORM. In that case, how do you talk to a DB in a Sinatra app? Or is Sinatra only for apps that don't use a DB?

Answer Source

If you like ActiveRecord, use that. Or something else. Datamapper, for instance. For AR with SQLite, this works:

require 'rubygems' # may not be needed, depending on platform
require 'sinatra'
require 'active_record'

class Article < ActiveRecord::Base

get '/' do
    :adapter => "sqlite3",
    :database => "hw.db"
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download