Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
Async MySQL driver for Ruby/Eventmachine
Ruby
Tree: 970427cfc1

Fetching latest commit…

Cannot retrieve the latest commit at this time

Failed to load latest commit information.
lib
spec
README.md
Rakefile
VERSION

README.md

EM-MySQL (Plus)

EventMachine wrapper for the C-based MySQL / MySQLPlus Ruby gems, which provides callbacks, errbacks and all other niceties of EventMachine while keeping the API of the original C-based MySQL gem.

Features:

  • Maintains C-based mysql gem API
  • Deferrables for every query with callback & errback
  • Connection query queue - pile 'em up!
  • Auto-reconnect on disconnects
  • Auto-retry on deadlocks

Example usage:

gem install em-mysqlplus irb -r em-mysqlplus

EventMachine.run {
  conn = EventMachine::MySQL.new(:host => 'localhost')
  query = conn.query("select 1+1")
  query.callback { |res| p res.all_hashes }
  query.errback  { |res| p res.all_hashes }
}

Query queueing:

EventMachine.run {
  conn = EventMachine::MySQL.new(:host => 'localhost')

  results = []
  conn.query("select 1") {|res| results.push res.fetch_row.first.to_i}
  conn.query("select 2") {|res| results.push res.fetch_row.first.to_i}
  conn.query("select 3") {|res| results.push res.fetch_row.first.to_i}

  EventMachine.add_timer(0.05) {
    p results # => [1,2,3]
  }
}

Credits

Original Async MySQL driver for Ruby/EventMachine - (c) 2008 Aman Gupta (tmm1)

Something went wrong with that request. Please try again.