- Less cluttered data, easier to be copied
- Easier to be synced and backuped
- All preset data is in place (same as 1
If you like the idea, why not then change the favorites save data into an human readable format, so we could rename the favorites names for example?
EDIT: Or rename the "Hive_Presets.presetsdb" to a proper, common sqlite database file-ending (i.e. "Hive_Presets.db"), so you could edit any value yourself (including setup values) with db browser for sqlite or similar.
Is the database lacking of a "tag" table completely? Where do these tag ids come from? You already seem to have a n-m-relation using "tagmap", but it only supports 1-n so far... A GUI problem? Or are these tags also the categories etc.?
I think a overhaul of those structures with keeping portability in mind would not hurt. For example, not using unique ids for preset-tag relations or so? This seems to be difficult, string ids are ugly. Sometimes a simple "json" field directly within the presets table might be more practical? At least postgresql directly supports json fields in queries now... sqlite 3.9 introduces the json1 extension: https://www.sqlite.org/json1.html
Thanks for consideration
