Atomic Object Show Nav
Close Menu
< Blog Home
We're Hiring
Atomic Object
Services
Portfolio
Team
Culture
Contact
Atomic Object Atomic Object
Services
Portfolio
Team
Culture
We're Hiring
Blog
Contact
Atomic Object
Services
Portfolio
Team
Culture
We're Hiring
Blog
Contact
← Back to Blog Home

MySQL

Extracurricular Activities

Hacking EVE, Part 1 – Reading SDD Data

An introduction to using ActiveRecord and RSpec to read EVE's static data dump from a MySQL database.
.NET / WPF

Faking Named Parameters in .NET when Using ODBC

Here's some handy code for emulating named parameters when using ODBC drivers in C# or .net.
DevOps & System Admin.

Remote mysqldump without Temp Files

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.
Platforms & Languages

3 Ways to Make Tab Delimited Files from Your MySQL Table

3 examples for creating tab-delimited files from a MySQL database table.
Ruby on Rails

Ruby on Rails and MySQL BIGINT

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.
.NET / WPF

MySQL in .NET: Native or ODBC

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.
Platforms & Languages

MySQL: Failed Registration of InnoDB as a Storage Engine

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.
Platforms & Languages

MySQL "IN" – Query Performance

When working with large databases, SQL structure effects query performance dramatically. I recently refactored a query that looked like this.
DevOps & System Admin.

Running Low on Disk Space Using MySQL Replication?

Platforms & Languages

Extracting a Table from a MySQL Dump

Platforms & Languages

On the Importance of Character Sets & Character Encodings in MySQL

When transmitting and storing digital data, one of the most important considerations should be the character encoding. 

Want to see what Atomic can do?

Check out some of our work

Atomic's Portfolio

Atomic is a software design + development consultancy.

© 2023 Atomic Object LLC
Explore
  • Careers
  • Diversity
  • Resources
  • Atomic Blog
Offices
  • Grand Rapids
  • Ann Arbor
  • Chicago
  • Raleigh-Durham
Details
  • Contact
  • Media
  • Privacy Policy
Certified B Corporation