In regular expressions you can use the zero-width pattern \b to match the beginning or end of a word...
If you need to export data from MySQL to a CSV, you can profit from really fast built-in methods...
To clear the query cache in your MySQL database manually, e.g. for database profiling, execute the following command in your...
Deadlocks only occur if two transactions in separate threads compete for the same rows in the database. They usually (but...
If you need to do calculations inside the database and can not use Ruby objects you may run into problems...
Occasionally some complex query must be processed on the database because building thousands of Ruby objects is impracticable.
CONCAT('foo', 'bar', NULL) = NULL the NULL always wins in MySQL. If you would rather treat NULL as...
Use this MySQL command to show further info about a table: SHOW CREATE TABLE tags; This will output a table...
The ancestry gem allows you to easily use tree structures in your Rails application. There is one somewhat unobvious pitfall...
If you want to see how long your database queries actually take, you need to disable MySQL's query cache...
It can be useful to have a Ruby expression like condition ? positive_case : negative_case in MySQL queries:
When you need to delete rows from a table, and the delete conditions require a joined table, MySQL needs to...
For some reason you want to define a find condition in array form. And in that condition both column name...
Update RubyGems and Passenger Bundler requires Rubygems >= 1.3.6. Run gem update --system if you have an older version.
When working with times and dates in Rails applications, you need to deal with the following problem: In Rails, Time...
Keyboard layout reverting to US on (every) reboot Cause: I found the same problem, but only on my wife...
In a nutshell: to avoid your shell character set from messing with imports, use -r to export and SOURCE when...
ALTER DATABASE database_name CHARACTER SET "utf8"; ALTER DATABASE database_name COLLATE "utf8_unicode_ci"; After that, for...
You’re a business, calling a business, about conducting business. Don’t be surprised when money comes up.
This may be awkward to set up, but will work once you're done. Fun facts:
Unless all MySQL server defaults are set to UTF-8, mysqldump encodes UTF-8 characters incorrectly and only outputs correct...
MMM (MySQL Master-Master Replication Manager) is a set of flexible scripts to perform monitoring/failover and management of MySQL Master...
Here are eight things my team has found to be true after working with Cucumber for about 6 months.
After some deliberation, we decided to implement a "schema-less" storage system on top of MySQL rather than use a...