The SQL code generated by Graticule's spherical distance computation is insufficient and can lead to NULL distances in edge...
Seems like a useful gem for cases where ActiveRecord is overkill but you don't want to do everything by...
Using rename_column, remove_column, etc. more than once in a migration makes that migration run slower than it should...
For performance improvements (and to remove the need for eager loading), the ActsAsTaggableOn gem supports caching your tag lists directly...
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...
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:
Clearfix is a hack to clear floating elements without additional HTML markup. If you only need to support IE8 and...
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...
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...