// archives

Technology

This category contains 12 posts

Use MySQL to generate a tiny url style string

We all appreciate getting small urls and the most famous link generator is http://tinyurl.com/. They do a perfect job of creating shortened URLs using random strings. The idea is pretty simple. Create a string of N char length and use it as key to reference a value. Perhaps it’s a URL or a document or […]

XtraDB Cluster on CentOS 7

Setting up XtraDB Cluster (aka Galera) is straight forward…or so I was told. To do this correctly, there are some tricks. Some published. Some disparate. I’m going to save you HOURS of Googling for answers and break down the process here. Just know that from version to version, dependency changes have a HUGE impact. I […]

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…

%d bloggers like this: