OurSQL Episode 121: Fun with text files

This week we discuss manipulating text data and the CSV storage engine. Ear Candy is Venn Diagrams visually showing joins, and At the Movies is about how to retain your individuality while being on a team.

Events
FOSDEM 2013 is taking place in Brussels, Belgium Sat Feb 2 - Sun Feb 3rd. Call for papers for the MySQL & Friends room closes December 21st.

Northeast LinuxFest is happening at Harvard University, Cambridge MA Saturday March 16th and Sunday March 17th, 2013. Open Database Camp will be held there. Sponsors are needed, make sure to specify you are helping out because of Open Database Camp. Registration is free, register today!

Percona Live: MySQL Conference and Expo 2013 is being held at the Santa Clara Convention Center Monday April 22nd - Thursday April 25th. The tutorial schedule is up. Register today, early bird pricing goes until Friday, December 28th.

Training
MySQL Marinate, a FREE basic MySQL training course led by Sheeri.

SkySQL Trainings

Oracle's MySQL Trainings

Percona Trainings

Manipulating Text Data
cygwin
cat
mysqldump --tab
UUOC

paste
sort
head
tail
join

grep
Regular Expression Pocket Reference from O'Reilly

cut
uniq

Combining some of the utilities we’ve seen so far, it’s possible to get some interesting analysis from your error log:

grep -vE "(Version|ERROR)" /var/log/mysql/error.log  | cut -d ':' -f 1 | sort | uniq -c

sed and the sed Wikipedia page

IBM's RPG language

Comma-Separated Values Storage Engine
CSV Manual page
Sample CSV table CREATE statement:
CREATE TABLE t1 (i1 INT NOT NULL, s1 VARCHAR(20) NOT NULL) ENGINE=CSV;

Statistics gathering script - could easily be modified to send output to a CSV table/file.
From the Drizzle list, .csv is empirically faster than LOAD DATA INFILE

Ear Candy
Visual Representation of SQL Joins

At the Movies
Working together: Finding your individuality in a team by LB Denker at last month's CodeConnexx conference.

Where you can see us
MySQL Marinate starts January 1st, 2013. It is a virtual self-study course learning MySQL which both Gerry and Sheeri will be helping lead.

Gerry will be at the January Seattle MySQL meetup group which will feature Lisa Phillips of Twitter talking about how Twitter uses MySQL. The Seattle meetup group will also discuss the current topics in MySQL Marinate, so it's a live, in-person way to get questions answered.

Sheeri will be at the January Boston MySQL meetup group on Monday, January 14th from 7-9 pm. The topic is NuoDB, an emergent database that is 100% SQL, 100% ACID, and scales out elastically on decentralized resources in the cloud, on-premises, or both.

Sheeri will be speaking at the miniconfs at Linux Conf Australia, about "Getting Started With a Podcast", "mysql security" and "The Art of Cat Herding: How to Manage Geeks." Linux Conf Australia will be held Monday January 28th through Saturday February 2nd, 2013 in Canberra.

Sheeri will be speaking at Rocky Mountain Oracle User Group Training Days in denver, colorodo from Monday Feb 11 - Thursday February 14th on "Backing up MySQL" and "Are You Getting the Most Out of Your Indexes?"

Sheeri will be speaking at Confoo in Montreal, Canada on Monday February 25 - Friday March 1, 2013, giving talks in English about "Are You Getting the Most Out of Your Indexes?" and "Different (MySQL) Forks for Different Folks".

Gerry will present a tutorial at Percona Live:MySQL Conference and Expo on Using TokuDB: A Guided Walk Through TokuDB Implementation. Many of the concepts apply to custom MySQL / MariaDB installations as well. Percona Live: MySQL Conference and Expo 2013 will be held April 22-25, 2013 in Santa Clara, California.

Feedback
Facebook group
Google+ page
e-mail: podcast at technocation.org
voicemail using phone/Skype: +1-617-674-2369
twitter: @oursqlcast
or Tweet about @oursqlcast