...I'm working on a project where we plan to do some extensive, dynamic sharding. Previously, I've only used ActiveRecord as my SQL ORM for all ruby projects, but this time around we're considering Sequ...

...hi, I am a relative newbie to using sequel - please be kind. I have already gone through a previous post on a related topic: http://groups.google.com/group/sequel-talk/browse_thread/thread/3deb418cd4...

...Hi all, I've recently moved an app to Heroku, using one of their Postgres databases. The times coming out of that database were -8 hrs, so I started having a look and it seems the times were being sa...

...Does anyone have an example of this plugin in action? It's not immediately clear if/how to use the .apply method. Thanks, -- Jason Dixon DixonGroup Consulting http://www.dixongroup.net/ -- You re...

...Hi all, I'm still a bit noob when it comes to Ruby and Sequel so sorry if this seems trivial. I'm working with a legacy MSSQL database which is primarily updated by a 3rd party app which I have no...

...Hello, I've got some sqlite databases with boolean columns that use 1 and 0 as true and false. Sequel can read this just fine. When I write to a database with something like DB[:some_table].update(:s...

...Hey I'm about to start using Sequel alongside AR in a rails 2.3.x project. Seems to be pretty seamless so far. I'm wondering how connections and connection info work: - seems like Sequel (3.32.0) ...

...I just found out about this project today, it looks awesome: http://pollenware.github.com/patio/index.html It's basically a port of Sequel to Javascript, so you can have a Sequel like-API in node.js....

...In our organisation, we've decided that table names should be singular, i.e. they should represent the objects/rows they store, rather than refer to the collection as a whole. So instead of having a P...

...Hi, I've a small app running on jruby and sequel, accessing H2 embedded databases through jdbc. I've plenty of germanic letters (like 0xD6 capital o with umlaut) I would need in my records, but when...

...Sequel 3.32.0 has been released and should be available on the gem mirrors. = New Features * Prepared statements now support :map and :to_hash prepared statement types. The main reason for this i...

...Hi, I sometimes have to perform the following in my H2 databases: SELECT COUNT(MYKEY),MYKEY FROM MYTABLE GROUP BY MYKEY HAVING COUNT(MYKEY) 1 ORDER BY COUNT(MYKEY) DESC Is there a way to make it ...

...Hi, I've a portion of code (a checksum) which is commonly used in a specific app I just did. I've dozens of models, if not more, and for each I've been copying the portion of code. This seemed to be...

...I have the following Model: module DB LOCAL = Sequel.sqlite("#{File.expand_path("../../../../db/ janitor.db", __FILE__)}") class User < Sequel::Model class << self def creat...

...hi, i just want to let you know, that i have started a project to bring together sequel, fibers, eventmachine and postgresql. https://github.com/jzimmek/em-postgresql-sequel the project is still in...

...Hi, I was wondering if there's an alloted place/way for adding helpers to migrations? Obviously I can just add them in the normal Rubyish ways, but if there's something better (as a plugin, for examp...

...Using SQL Server 2008 R2 sequel 3.31.0 alter_table(:table_name) do set_column_type(:column_name, :bit, {:null = false}) end Expected ALTER TABLE [table_name] ALTER COLUMN [column_name] bit NOT NU...

...DB = Sequel.ado(:conn_string='Provider=SQLNCLI10;Server=localhost;Database=db1;User ID=da;Password=123456') dataset = DB['select count(*) , \'1234\' from Mytable'] dataset.each{|row| p row} print p ...

...So, I'm experiencing what I would describe as inconsistent behavior from the oracle adapter. I can create a Sequel::Oracle::Database object without issue. However, when I try executing a raw query wi...

...$ sequel -m db/b/migrations 'sqlite://db/data.db' Error: Sequel::Migrator::Error: Applied migration files not in file system: 20111227001707_create_user.rb/home/app/ruby/lib/ruby/gems/ 1.9.1/gems/seq...