Top "Sequel" questions

How to round an average to 2 decimal places in PostgreSQL?

I am using PostgreSQL via the Ruby gem 'sequel'. I'm trying to round to two decimal places. Here's my code: …

sql ruby postgresql sequel

Encoding::UndefinedConversionError

I keep getting an Encoding::UndefinedConversionError - "\xC2" from ASCII-8BIT to UTF-8 every time I try to convert a …

ruby encoding sinatra sequel

How to update or insert on Sequel dataset?

I just started using Sequel in a really small Sinatra app. Since I've got only one DB table, I don't …

ruby upsert sequel

How to run raw SQL queries with Sequel

I am not clear yet on the proper way to run raw SQL queries with Sequel. Currently I am trying …

sql ruby sequel

Unable to connect mysql from Sequel gem

When I try to connect to MySQL from Sequel. I am getting these errors: require 'rubygems' require 'sequel' DB = Sequel.…

mysql ruby sequel

Sequel::AdapterNotFound: LoadError: cannot load such file -- win32ole

I am successfully able to connect to MySQL and Postgres database using 'sequel'. I want to connect to the SQL …

ruby-on-rails ruby database ruby-on-rails-3 sequel

Slicing params hash for specific values

Summary Given a Hash, what is the most efficient way to create a subset Hash based on a list of …

ruby hash sinatra sequel

How to disconnect an existing ruby sequel connection to a database?

I mean the one which was previously established as DB = Sequel.sqlite('my_blog.db') or DB = Sequel.connect('postgres://…

ruby sequel

How do I test for non-null in Ruby::Sequel?

I'm looking to do something like User.select(...).where(:name != nil) without writing something like User.select(...).to_a.find_…

ruby sequel