Note: This applies specifically to MySQL. In PostgreSQL for example, this is not an issue. If you care about performance...
Look here for informations how you can show the MySQL default character set. At first you need the Amazon RDS...
To show the collation of your tables you have to login to the MySQL console and execute SHOW TABLE STATUS...
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...
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...
When you run rake db:create and get this error message Couldn't create database for {"encoding"=>"utf8", "username"=>"root...
Here is a way to create a duplicate of one database, with all its tables and their data, under a...
Random list of useful git commands for advanced users. I found some of them useful.
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...
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...
VirtualBox does not offer anything for this task -- you need to do it yourself. It's not that hard:
Install Ruby from the Ubuntu repository: sudo apt-get install ruby ruby-dev \ ruby is the meta package. If you...
After managing a few agile projects from India and learning the tricks of the trade, I have been wondering why...
This Perl script will run diagnostics on your MySQL database and recommend changes to your MySQL configuration.
When you encouter an unsafe string that you actually made html_safe before, perhaps you called one of the following...
When your cucumber features grow massively over time, the test execution can take a lot of time.
The trick is this: send a low-resolution version of your image to the screen, and a high-resolution version...
Ruby comes with a class BigDecimal which you can use for arbitrary precision arithmetic. You should use BigDecimal instead of...
When storing floating-point numbers such as prices or totals in an SQL database, always use a DECIMAL column. Never...