Forum Archive

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 of ui.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 😬

livejson