loading...

Just released sequel-activerecord-adapter gem

janko profile image Janko Marohnić ・1 min read

Sequel is a superb database library for Ruby. However, it can be difficult to get started with it in an app that already uses ActiveRecord, because Sequel requires its own database connection.

So I've created the sequel-activerecord-adapter gem that allows Sequel to reuse the existing ActiveRecord connection for its database interaction.

require "sequel-activerecord-adapter"

ActiveRecord::Base.establish_connection("postgresql:///mydb")

DB = Sequel.activerecord # reuses the ActiveRecord connection

DB.tables #=> [:users, :articles, ...]

DB[:articles].insert(title: "Sequel ActiveRecord Adapter")
DB[:articles].all #=> [{ title: "Sequel ActiveRecord Adapter" }]
DB[:articles].update(author_id: 2)

This means you can now easily use Sequel in parts of your app that might be more performance-sensitive or require more advanced database queries that ActiveRecord doesn't support.

It also means you can use libraries like Rodauth that use Sequel under-the-hood without increased performance and mental overhead that would come with separate database connections.

Posted on Apr 27 by:

janko profile

Janko Marohnić

@janko

Ruby developer and open source enthusiast

Discussion

markdown guide