CookpadMysqlDefaults

This gem forces better MySQL table defaults on creation.

• Set engine to InnoDB.
• Use 4-byte UTF-8 charset and collate to support Emojis.
• Use ROW_FORMAT=DYNAMIC for indexes on big columns.

Usage

Just add the gem to your project!

Installation

Add this line to your application's Gemfile:

gem 'cookpad_mysql_defaults', github: 'cookpad/cookpad_mysql_defaults'

And then execute:

$ bundle

Test

Run docker-compose up -d to create and run the MySQL database.

Then run ruby test/defaults_test.rb

License

The gem is available as open source under the terms of the MIT License.