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?
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 end get '/' do Article.establish_connection( :adapter => "sqlite3", :database => "hw.db" ) Article.first.title end