Windows SQLite Database File Into Pythonista 3?

johnnyEss

Hello all,

I have been learning Python on my Windows 7 platform. I just purchased Pythonista 3 for my iPad and am VERY excited to be able to continue my Python play on the go. I have been a life-long database developer and so my coding has mostly been around doing database "type things".

I have been able to create a SQLite db locally on my iPad... but what I would REALLY like is to copy over the one I've been populating for months over on Windows...

But for the life of me I CANNOT figure out how to get my jhs2016.db file over into the Pythonista files area so that I can use it with my Pythonista coding. I have tried "sending it" from Dropbox, OneDrive and iCould to Pythonista but it won't work.

Help!

Thanks for your help!

John

ccc

https://github.com/Pythonista-Tools/Pythonista-Tools / Utilities / DropboxFilePicker

ihf

Another option if you don't want to use Dropbox is ftp. You can use stash to pip install pyftpdlib and then follow the example here: https://pypi.python.org/pypi/pyftpdlib/
I just tested it with transferring an sqlite file and then opening it in Pythonista and it worked fine.

ihf

Or you can use OMZ's script: https://gist.github.com/omz/1aec8a66a5d5d19a36ab

johnnyEss

Thanks for the reply's guys! @ihf I'll give OMZ's script a try!

@ccc At the moment, I don't want to go through the added hassle of getting all setup for the Dropbox development API key and all... but thanks for the reference, I may explore in the future!