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...
|
