What the difference between mysql and mysql2 gem

by

Here’s a quote from the mysql2 gem page:

Yeah… but why?

Someone: Dude, the Mysql gem works
fiiiiiine.

Me: It sure does, but it only hands
you nil and strings for field values.
Leaving you to convert them into
proper Ruby types in Ruby-land – which
is slow as balls.

Someone: OK fine, but do_mysql can
already give me back values with Ruby
objects mapped to MySQL types.

Me: Yep, but its API is considerably
more complex and can be ~2x slower.

More Related Contents:

  1. Error installing mysql2: Failed to build gem native extension
  2. Library not loaded: libmysqlclient.16.dylib error when trying to run ‘rails server’ on OS X 10.6 with mysql2 gem
  3. gem install: Failed to build gem native extension (can’t find header files)
  4. Rails, MySQL and Snow Leopard
  5. MySQL Install: ERROR: Failed to build gem native extension
  6. How to delete duplicate records in mysql database?
  7. rails + MySQL on OSX: Library not loaded: libmysqlclient.18.dylib
  8. Ruby gem mysql2 install failing [duplicate]
  9. Correct MySQL configuration for Ruby on Rails Database.yml file
  10. Rails select random record
  11. Mysql2::Error::ConnectionError: Access denied for user
  12. mysql2 gem compiled for wrong mysql client library
  13. no such file to load — rubygems (LoadError)
  14. Mysql::Error: Specified key was too long; max key length is 1000 bytes
  15. How to handle Ruby on Rails error: “Please install the postgresql adapter: `gem install activerecord-postgresql-adapter'”
  16. Nokogiri installation fails -libxml2 is missing
  17. “193: %1 is not a valid Win32 application” bug with a new Rails Application
  18. How to use bundler behind a proxy?
  19. How do I use RVM and create globally available gems?
  20. libmysqlclient15-dev on macs?
  21. How do you write a case insensitive query for both MySQL and Postgres?
  22. “gem install rails” fails with DNS error
  23. String.force_encoding() in Ruby 1.8.7 (or Rails 2.x)
  24. unable to install pg gem
  25. Failed to build gem native extension — Rails install
  26. uninitialized constant MysqlCompat::MysqlRes (using mms2r gem)
  27. sqlite3 gem fails to install
  28. How to fix “Your Ruby version is 2.3.0, but your Gemfile specified 2.2.5” while server starting
  29. Ruby 1.9.2 how to install RMagick on Windows?
  30. Unable to install MySQL2 gem on Windows 7

Leave a Comment