To show the MySQL default character set you have to login to the MySQL console and execute SHOW VARIABLES LIKE...
Given the problem you have a new column postion and that column should be updated for all existing rows with...
When adding a new field to your model's database table, don't set any defaults in the database.
In order to open a MySQL shell without the need to enter user and password, you can say the following...
In case you have sensitive data within your RDS instance, you want to use encrypted connections between your application and...
The technique described in this card has an important caveat: The result of GROUP_CONCAT is truncated to the maximum...
You can use heredoc to avoid endlessly long lines of code that nobody can read. Heredoc strings preserve linebreaks and...
When you run rake db:create and get this error message Couldn't create database for {"encoding"=>"utf8", "username"=>"root...
Most likely you run rake and your code is causing an exception which is not the one shown in your...
Here is a way to create a duplicate of one database, with all its tables and their data, under a...
There is a bug in Rails 3's dbconsole script, which makes the following command open a database console for...
Simple: Tell the application controller how to handle exceptions, here a RecordNotFound error. Do this with the following line: # application_controller.rb...
While it might seem trivial to implement an invoice that sums up items and shows net, gross and vat totals...
When the Ruby parser module of Ruby-GetText comes across a file in one of its search directories (e.g. lib/scripts...
Do you wonder which databases are actually taking up how much space but only have one huge ibdata1 in your...
If you use Amazon AWS cloud services you definitively want to utilize software raid for IO intensive stuff such as...
The Capybara API is somewhat hard for parse for a list of methods you can call on a Capybara node...
Possible fixes: Upgrade your Firefox. It's fixed in 5.0. Hunt down funny float or overflow directives in your CSS...
Note: If you are currently working with Ruby 1.8.7 or 1.9.3, we recommend to upgrade to Ruby 2.1 first. From...
Note that this card is very old. You might want to use ActiveType for your auto-coerced virtual attributes instead...
Note: Consider using MATE instead of Gnome 3 on newer system Awesome is a very good tiling window manager that...
Install Ruby from the Ubuntu repository: sudo apt-get install ruby ruby-dev \ ruby is the meta package. If you...
These steps are now part of Spreewald. Since Capybara 0.4.1 a within scope will only look at the first element...
This Perl script will run diagnostics on your MySQL database and recommend changes to your MySQL configuration.