// author archive

Randy

Randy has written 77 posts for @randymelder

The day I un-liked all my Facebook pages

Have you ever stopped to think what’s happening behind the scenes at Facebook with regard to all those “pages” that you “Liked” and forgot about? We all know FB aggregates and sells that data, but what about my “Wall” and the things I see? I did a little experiment and “un-liked” all the pages 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 […]

Things that make the USA Awesome!

I recently went on a vacation to some foreign lands. It gave me the opportunity to reflect on the things I love about the USA. Don’t get me wrong, we had a great time and there are some great things about other countries. However, in the end, I really did long for all things American […]

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.

Apple’s One Timezone planet

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

Amazon Time Warp Fail

When you see it…

Yahoo! mail fail

We’re Sorry.

Facebook Actively Inactive :-(

You have activity! You have no activity?!?

LinkedIn lost its data link