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_viewto 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 😬