Thread: [Sqliteman-devel] Development of Android mmssms.db on Linux for archiving purposes
Brought to you by:
subik
From: Philip R. <ph...@pr...> - 2016-10-27 03:49:10
|
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... |