An introduction to using ActiveRecord and RSpec to read EVE's static data dump from a MySQL database.
Here's some handy code for emulating named parameters when using ODBC drivers in C# or .net.
A description of using pipes with ssh in a way that allows the results of mysqldump on a remote machine to be stored locally without creating a temporary file.
3 examples for creating tab-delimited files from a MySQL database table.
In order to take advantage of the BIGINT storage with Rails migrations you first need to create a normal integer and then change the column to a BIGINT.
Connector/NET, written in C#, has some upsides over the ODBC driver. Unfortunately, we ran into a number of problems with it and switched to the ODBC driver.
It happens countless times for many reasons. You attempt to start or restart your MySQL server after a small configuration change and MySQL stubbornly refuses to start.
When working with large databases, SQL structure effects query performance dramatically. I recently refactored a query that looked like this.
When transmitting and storing digital data, one of the most important considerations should be the character encoding.