In MySQL comparing zero to a string 0 = "any string" is always true! So when you want to compare a...
Possible Reason 1: parallel_tests - running more processes than features If you run old versions of parallel_tests with more...
Though Internet Explorer 9 supports the box-shadow CSS property there is a nasty bug which sometimes prevents it from...
When selecting records in a date range, take care not to do it like this: start_date = Date.parse('2007-05...
Basically, you now need to know if your project uses a "real" time zone or :local, and if config.active_record.time_zone...
In your Cucumber features you can't really click hidden elements when using Selenium (it does work for a plain...
Add a separator between left-aligned and right-aligned items. In the separator properties, set the style to "Transparent" and...
The SQL code generated by Graticule's spherical distance computation is insufficient and can lead to NULL distances in edge...
When you have objects in your database that hold latitude and longitude and you want to find others that are...
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...