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