[sqlite] Development environment reccomendation

[Philip Rhoades]

People,

I previously posted about a "Simple SQLite app importing from mmssms.db 
and using GContacts"



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?



but I didn't get any responses so I am posting again with a different 
Subject.  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

I want to import data into a DB that can keep accumulating stuff.

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.


What development environment would people suggest for building the 
sqlite app?


Thanks,

Phil.


--
Philip Rhoades

PO Box 896
Cowra  NSW  2794
Australia
E-mail:  p...@pricom.com.au
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Import 5000 xml files in a sqlite database file

[Eduardo Morras]

On Sat, 22 Oct 2016 19:26:42 +0200
bob_sql...@web.de wrote:

> Hi,
> 
> I have more than 5000 xml files. All files have the same
> xml-structure. 
> 
> Each file has different values (timestamps, numbers and strings). I
> would like to put all these values in a sqlite database tabke, all in
> one table. => Import the data values into a sqlite database table.
> 
> Can you please tell me a software program, that can do this quickly?

You can convert them to json and use sqlite3 json capabilities.
Duckduckgo search engine takes me to:

http://web-notes.wirehopper.com/2013/12/06/linux-command-line-convert-xml

http://openlife.cc/blogs/2013/november/translating-reliably-between-xml-and-json-xml2json

Which describes some apps to convert from xml to json. Some are in
javascript, python, php, perl and others are online converters.


> Thank you for your answers.
> 
> Best regards 
> 
> Bob
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


---   ---
Eduardo Morras 
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Import 5000 xml files in a sqlite database file

[Sylvain Pointeau]

hello,

I am not sure if Oxygen or another XML specialized software could do it,
however it would be easy done using C or C++ or Java. Advantage is that it
is then easy to automatize in a batch mode. I can propose you my services
if you are interested.

Best regards,
Sylvain

Le samedi 22 octobre 2016,  a écrit :

> Hi,
>
> I have more than 5000 xml files. All files have the same xml-structure.
>
> Each file has different values (timestamps, numbers and strings). I would
> like to put all these values in a sqlite database tabke, all in one table.
> => Import the data values into a sqlite database table.
>
> Can you please tell me a software program, that can do this quickly?
>
> Thank you for your answers.
>
> Best regards
>
> Bob
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org 
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users