This script loads a dump into your development database. You can provide the full path to you database dump like...
Some advice for bulk loading many records into InnoDB and finishing before the sun burns out. Use with care.
Probably was in the repository once and got deleted in a commit that you pulled.
Localizing a non-trivial application can be a huge undertaking. This card will give you an overview over the many...
MySQL version 5.1 comes with an alternative, faster InnoDB implementation (called "InnoDB Plugin"). Switching is easy: Stop your mysqld with...
When requests arrive at the application servers simultaneously, weird things can happen. Sometimes, this can also happen if a user...
Using beginning_of_day or end_of_day on Date or DateTime objects in Rails 2.x applications will never...
An association defined with has_many :through will return the same record multiple times if multiple join models for the...
The default behavior of Calc is that when you paste cells from the clipboard, it overwrites whatever cells occupy the...
When talking to your MySQL server via a mysql shell, you can terminate queries by ; or \G -- the latter gives...
Usually you don't need to, but when you want to see which queries your MySQL server currently needs to...
After you configured your ODBC describe in Fix [RubyODBC]Cannot allocate SQLHENV when connecting to MSSQL 2005 with Ruby 1.8.7...
I followed this nice guide Connecting to MSSQL with Ruby on Ubuntu - lambie.org until I ran in the following errors...
When you do a script/dbconsole -p, your MySQL shell will already be using UTF-8. When you call it yourself...
Let's say you need to revert a migration that happened a while back. You'd create a new migration...
will_paginate triggers a database query to determine the total number of entries (i.e. to let you display the number...
In MySQL comparing zero to a string 0 = "any string" is always true! So when you want to compare a...
Ever seen this error when using Graticule? Numerical argument out of domain - acos Similarly to the to_sql problem for...
Possible Reason 1: parallel_tests - running more processes than features If you run old versions of parallel_tests with more...
Use the command geordi migrate to migrate your databases and to prepare them before running tests. The abbrevation geordi m...
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...
When internationalizing your Rails app, you'll be replacing strings like 'Please enter your name' with t('.name_prompt'). You...