// archives

Technology

This category contains 12 posts

Finding duplicate rows in MySQL

I saw this question online reading “How do I identify duplicate rows in MySQL” and it’s been gnawing at me so here’s my approach: Make a duplicate of your subject matter CREATE TABLE a2 LIKE a1; INSERT INTO a2 SELECT * FROM a1; Add a ‘checksum’ column to the new table ALTER TABLE a2 ADD […]

I started making this iOS game with Sprite Kit

Side benefits of jet lag + general insomnia include lots of time to learn new things. I decided it was time to learn Sprite Kit by making a game for my 2-year old to play on my iPhone. I call it “Say Shapes” – Here’s progress after 4 total hours. Like this:Like Loading…

Apple’s One Timezone planet

At midnight, the world timeclock gets label panic. Don’t ask me how I know… Like this:Like Loading…

Yahoo! mail fail

We’re Sorry. Like this:Like Loading…

Facebook Actively Inactive :-(

You have activity! You have no activity?!? Like this:Like Loading…

LinkedIn lost its data link

Like this:Like Loading…

2 Fails, 1 Page – AT&T and Facebook Fail

Fail #1 – AT&T Hacked Fail #2 – Facebook flapping 3 fails, if you count the facial on the video still… Like this:Like Loading…

Getting the mysqldump you always hoped for.

Dumping data from MySQL might be seem like a covered topic, but just so it’s clear, you aren’t stuck outputting SQL. There’s at least 3 options for outputting data. Option 1: The SQL way Good’ole fashioned structured query language output of your whole database in a single file. mysqldump -u root -p -f your_schema_name_here > […]

MarketWatch App Fail

InvalidOperation much? Like this:Like Loading…

%d bloggers like this: