Officially disguised as a Canadian
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
I ran into a bit of a snag with my original plan. I built the framework for parsing the SQL script, one statement at a time, and catered for statements that wrapped over more than one line. It took about two hours to get to the point where I was ready to parse the SQLContinue reading Progress on Merging SMS 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
A new beta of ShutOff 2000 v3.0.0 is now available. The product is fast approaching code completion. The Visual Basic 6 edition of the application has always used the Windows Registry to store its settings. However, Microsoft’s best practice for the Windows 7 and Windows Server 2008 R2 platform does not allow for this, soContinue reading The life of an application config from the registry to SQLite to SQL CE to XML