[mythtv-users] Converting scripts to not use the database directly

[Hika van den Hoven]

Hoi Simon,

Wednesday, November 5, 2014, 9:03:03 AM, you wrote:

> UB40D <ub40dd at googlemail.com> wrote:

>> Where is the single place I should go to edit whatever data?

> It doesn't exist yet.
> That, in part, is what the discussion about.

> At present, there is no "single place to edit any editable data"
> while *some* data can be edited via various obscure places in teh
> UI. As a result, many people edit the DB directly via SQL.

> Now, some stuff is completely "safe" to edit that way - well as
> safe as anything can be when subject to fat fingers etc. But there
> is a lot in there that shouldn't be touched and the DB itself won't
> enforce (eg) referential integrity if a user decides to edit something they shouldn't.
> It's the latter bit that makes the devs keen to remove external access to the DB.

> But there's a bit of a "cart", "horse", "put in right order" situation.
> The devs need to get a fully functional and acceptable means of
> accessing the database in place before removing access to the DB.
> That means a UI for "casual users" and ad-hoc changes, plus a
> scriptable API for scripted operations.

> The former doesn't exist at all yet, the latter sounds like it is still in it's infancy.

> _______________________________________________

I rarely use the edit option through the UI because it's to much
work. A simple improvement already would be if I could do it through
the Web interface, so I could sit behind my desk in stead of standing
in front of the TV. But best would be if the Web interface would
provide a kind of spreadsheet with the editable data, like I now have
in phpmyadmin! I rarely want to edit just one episode, but to check on
consistency within a series, so I need the overview!
And than I do not talk about what I do through scripts. I don't get
season/episode info through my grabber, so I try to automate it
through other means.

Tot mails,
  Hika                            mailto:hikavdh at gmail.com

"Zonder hoop kun je niet leven
Zonder leven is er geen hoop
Het eeuwige dilemma
Zeker als je hoop moet vernietigen om te kunnen overleven!"

De lerende Mens