Move tvheadend Config to SQL (sqlite, mysql, mariadb ,... )
Move tvheadend Config to SQL (sqlite, mysql, mariadb ,... )Replies (2)
RE: Move tvheadend Config to SQL (sqlite, mysql, mariadb ,... )
-
Added by Adam Sutton over 11 years ago
Short answer, no.
We've discussed sqlite (certainly mysql would NEVER be used, or any similar DB) but there is little benefit and would require significant reworking that is not something the devs (i.e. me and Andreas) are interested in doing for no obvious benefit.
The better approach, would be to provide a better API for querying and updating TVHs internal data structures. And to get some UI devs on board to make the UI better to allow control from there.
Adam
RE: Move tvheadend Config to SQL (sqlite, mysql, mariadb ,... )
-
Added by G Ho almost 6 years ago
Totally agree with the original request. This kind of data is far better managed by sqlite in a handful of relational tables. You haven't to reinvent the wheel for a "better API" - simply use SQL. Far far better than JSON files in a directory structure. Some TV sets also export the channel list as sqlite DB file. For these you do not even need a special editor for tweaking. One of the many sqlite clients will do the job (even as browser add-on).
Just had to modify the generated icon path of some channels. So I had to do it very low level (bash, grep, sed). With sqlite a single "update" would have it done - even transactional!