// author archive

Randy

Randy has written 30 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.

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 > […]

Givit.com shutters

Givit was a fantastic video editor for iOS devices. It had some amazing features. With it, was a video sharing service that was really clever in a lot of ways. For whatever reason(s), the company closed. The explanation is here: http://www.givit.com/what-happened/ The app, however, is still available on the Apple App Store as a stand […]

C Preprocessor Life Saver(s) – Part 1

More and more when I write code, I’m looking for optimizations, short cuts and less typing. This can mean a careful balance between maintainable code and author convenience. Here’s an example of something I use in every program I write. I use the preprocessor to define debug modes for myself to produce debug output under […]

The government is just there for your protection…

Do you ever hear business owners complain about “Government Red Tape” and think to yourself “What is this guy complaining about?” Here’s a perfect example. I hire Intuit Quickbooks Online Payroll service to handle my business’s payroll. This means they take money out of my business checking account and pay my employees. As part of […]

Mac OS X KEXT trick

A friend suggested this article (http://www.rdoxenham.com/?p=259) to me. I performed the steps and BAM! My Mac performance increased noticeably.

%d bloggers like this: