Disadvantages of Sequel gem

Question

Are there any alternatives to the Sequel ORM when working on a Sinatra-based app?

"Questions asking us to recommend or find a book, tool, software library, tutorial or other off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, [describe the problem](http://meta.stackoverflow.com/questions/254393) and what has been done so far to solve it." — the Tin Man, Feb 09 '16 at 18:30
You ask for disadvantages in the title, but alternatives in the question. Which do you want? — the Tin Man, Feb 09 '16 at 18:31

score 3 · Accepted Answer · edited Apr 21 '11 at 23:36

3

AFAIK, you are not forced to use Sequel with Sinatra. If you wish you can use Datamapper or an other ORM.

edited Apr 21 '11 at 23:36

jwfearn

28,781
28
95
122

answered Jun 26 '09 at 06:45

Simone Carletti

173,507
49
363
364

score 2 · Answer 2 · answered Feb 09 '16 at 18:48

You don't have to use Sequel with Sinatra. Sinatra is pretty agnostic.

If you are interested in using ActiveRecord its pretty straightforward: require 'rubygems' require 'sinatra' require 'active_record'

ActiveRecord::Base.establish_connection(
  :adapter => 'sqlite3',
  :database =>  'sinatra_application.sqlite3.db'
)

You can read more about ActiveRecord and Sinatra here. There is also a gem sinatra-activerecord that handles some of the boilerplate.

There is also the Ruby Object Mapper (rom-rb) which is a pretty nice implementation of the DataMapper pattern if you want something more fully featured than Sequel, but aren't interested in using ActiveRecord.

score 1 · Answer 3 · edited Feb 09 '16 at 18:29

1

You might check out Padrino. It's a lightweight framework with a Sinatra core that supports several ORMs right out of the box.

edited Feb 09 '16 at 18:29

the Tin Man

158,662
42
215
303

answered Apr 22 '11 at 02:35

Jason Slocomb

3,030
1
23
25

Indeed, Padrino is very modular so you can just include the ORM parts without any of the other functionality. Padrino supports the following as ORM by default: mongoid, activerecord, datamapper, couchrest, mongomatic, ohm, ripple, sequel – Martijn Heemels Jul 09 '12 at 15:56

score 0 · Answer 4 · edited Feb 09 '16 at 18:30

0

You can use DataMapper or ActiveRecord, or just plain DBI. Sinatra does not have any integrated support for a specific ORM framework.

edited Feb 09 '16 at 18:30

the Tin Man

158,662
42
215
303

answered Jun 26 '09 at 11:03

Evgeny

6,533
5
58
64

Disadvantages of Sequel gem

4 Answers4