"Classic" Excel (XLS) has a magic limit of 65535 rows per worksheet. This was fixed in XLSX but the version...
When you have objects in your database that hold latitude and longitude and you want to find others that are...
Instead of running all missing migrations on your test database with rake db:migrate RAILS_ENV=test you can also...
Two new methods on and off are the new way of declaring event handlers. bind, delegate and live area deprecated...
There are several options, but most of them are impractical. The best way is to use the :ruby filter:
Note: This applies specifically to MySQL. In PostgreSQL for example, this is not an issue. If you care about performance...
Clearance is a gem that provides authentication functionality (e.g. login, logout). This note explains, how the clearance login, logout and...
Look here for informations how you can show the MySQL default character set. At first you need the Amazon RDS...
If you want to distribute a 's width equally over its columns, you can use the following CSS property:
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...
First keep in mind that :dependent => :destroy hooks into before_destroy. So when you use other before_destroy callbacks the...
Using the jQuery adapter breaks the built-in save function of CKEditor. Phenomenon: The page is submitted correctly, but the...
If you want to know the exact hits on your website (or whatever logfile you want) for a specific date...
The most common use case for Ruby's #collect is to call a method on each list element and collect...
Given the problem you have a new column postion and that column should be updated for all existing rows with...
Generally for nested forms, a blank form is placed below all other existing object forms. If you would like to...
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...