On 19 Dec 2018, at 6:02pm, Jens Alfke <j...@mooseyard.com> wrote: > Of course you can save the JSON in the database file. Just create a ‘prefs’ > table with one blob column for the JSON. > > A related solution is to store each named pref as a row in the ‘prefs’ table, > identified by a ‘key’ column.
Or you could use SQLite's JSON Extension: <https://www.sqlite.org/json1.html> Settings and preferences do tend to lend themselves to a nesting JSON dictionary. I've never tried using SQLite for that, through I stopped writing that sort of software years ago. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
