Welcome!
This is the community forum for my apps Pythonista and Editorial.
For individual support questions, you can also send an email. If you have a very short question or just want to say hello — I'm @olemoritz on Twitter.
Storing UI view .json data in an sqlite3 database?
-
Is it plausible to store ui view .json data in an sqlite3 database?
Some ideas I have for this are:
- Multiple views could be redistributed this way
- Loading views from a database rather than a ui file may be a plus
Atop ui views, I am really thinking of a way to use sqlite3 to distribute many things like code from one iPad with Pythonista installed to another. Or I could host this database somewhere and have Pythonista users access it. I understand sqlite3 may not be the best tool for the job since it is usually used for local storage, but I am interested in using it for a project.
Any comments on these ideas?
-
A pyui is simply a text file. You could store it in a database, host it on a webpage, store it in a gist or git repo.. use
ui.load_view_str
instead ofui.load_view
to avoid having to create a file. -
Didn't even know that function existed. Thanks.
-
@TutorialDoctor , I come across this post randomly today, I was searching for something else. SQLite is pretty nice and easy to use for things like this. But have you see @Webmaster4o livejson? Pretty sure this would be perfect for saving pyui files, I will also try it. I have been using livejson the last 3 or 4 days as a data store for Formula One data. It really is nice as well as easy.
But as I say, I just come across this post searching for something else 😱 I need to keep searching 😬