Merging iOS Message databases: update

Success! Sort of … Instead of the complicated method I described previously, I’ve gone manual, which is, yes, more complicated :-). I started with the latest sms.db file from my new iPhone, and then editing SQLite scripts, incremented the ROWIDs by 30,000 for the message table, and 1000 for the others, so as to avoidContinue reading Merging iOS Message databases: update

Merging two iPhone SMS sqlite databases

Disclaimer: I haven’t actually done it, yet. Last night I rediscovered my original iPhone SMS database from before I did a factory-reset on my phone. I had jailbroken my 3G ages ago, and ever since then, the carrier wasn’t updating properly, regardless of the SIM card I used or country I was in. So inContinue reading Merging two iPhone SMS sqlite databases

ADN (Or, what the cool kids are calling App.net)

I am a developer-tier member of ADN. I started writing something this week but I’m not really sure where I want to go with the concept. It’s not a Twitter clone, it’s more a social media platform, and there are amazing clients already. I use Felix, Kiwi, Riposte and Netbot. So instead, I recommend youContinue reading ADN (Or, what the cool kids are calling App.net)

Where do I start with a Run Book?

On SuperUser.com, a question came up about how to do a proper Linux backup, including the applications installed, and associated configurations. In light of a previous post I wrote about backups and run books, I thought this would be useful information to share. I answered with a link to the original run book I haveContinue reading Where do I start with a Run Book?

PocketCloud Windows Companion vs RDP port-forwarding

Someone asked a question on SuperUser today, about getting PocketCloud and RDP to play nicely together, where they could connect to the host from outside the network. I thought I’d repeat my answer here with more info. Firstly, it’s important to note that PocketCloud Windows Companion uses the Remote Desktop Protocol, running on port 3389.Continue reading PocketCloud Windows Companion vs RDP port-forwarding