[Sqliteman-devel] Development of Android mmssms.db on Linux for archiving purposes

[Philip R. <ph...@pr...>]

People,

I want to develop an app for the mmssms.db on my Fedora Linux 
workstation - the background is this post to the sqlite list:


> I periodically crash or otherwise do a factory reset on my Android 
> phone
> but rather than restoring all the SMS messages I would like to just
> import from the backup mmssms.db into a Linux app and keep all the old
> messages for historical posterity allowing me to search and look up
> messages etc in a consolidated DB.  I can't find anything in existence
> that does this nicely so it seems like the easiest way to do this would
> be build it myself using Ruby + SQLite but I thought I would check here
> first - has anyone already done something like this?  Any pointers 
> about
> where to get started?


I have used SqliteMan in the past (but just for trivial DB updates) for 
another situation so I thought it might be worth trying to do what I 
want all from that app.

My process is:

- rsync the current mmssms.db from my phone to my Fedora Linux system 
prior to doing any factory resets or dangerous tinkering

- dump data out of the mmssms.db file and import it into a separate 
archive DB or just add the table info to the previous backup of 
mmssms.db

I will probably only ever want to look at historical stuff on my 
computer but maybe a web app would be convenient for remote access.

Do people think that using SqliteMan is the appropriate tool to do what 
I want?

Thanks,

Phil.

-- 
Philip Rhoades

PO Box 896
Cowra  NSW  2794
Australia
E-mail:  ph...@pr...