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...
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...