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...
Store schema-less data in MySQL.
We say “back in time”, and “back” feel like “left” to me, not right. So let’s break that standard...
Fuck acronyms, really
It’s a fact of CSS life that the ‘border’ of any block level element gets factored into it’s...
The most popular option should be checked. If choosing nothing is valid, then a radio group isn’t a good...
They don't teach you this in college, but the fundamental theorem of the software industry is the idea that...
Let’s take a gander at four different ways. Each of them handling the illusion in a different way, and...
The difference is that return false; takes things a bit further in that it also prevents that event from propagating...