Async MySQL driver for Ruby/EventMachine
  (c) 2008 Aman Gupta (tmm1)
 
 
Requires mysqlplus.
 
  require 'em/mysql'
 
  # alias SQL for simpler syntax
 
  SQL = EventedMysql
  def SQL(query, &blk) SQL.select(query, &blk) end
 
  
  # setup connection details and allow 4 connections to the server
 
  SQL.settings.update :host => 'localhost',
                      :port => 3306,
                      :database => 'test',
                      :connections => 4
  
 
  # use 4 connections to execute queries in parallel
 
  SQL('select sleep(0.25)'){ p 'done' }
  SQL('select sleep(0.25)'){ p 'done' }
  SQL('select sleep(0.25)'){ p 'done' }
  SQL('select sleep(0.25)'){ p 'done' }
 
Also includes a sequel async wrapper
 
  require 'sequel'
  require 'sequel/async'
 
  DB = Sequel.connect(:adapter => 'mysql', :user => 'root', :database => 'test', ...)
  EventedMysql.settings.update(..., :on_error => proc{|e| log 'error', e })
 
  DB[:table].where(:field => 'value').async_update(:field => 'new value')
 
For more info, see the comments in lib/sequel/async.rb