2017-07-03, 19:01
Hi!
I have some remarks about the database:
First of all, postgresql should also be supported, not only mysql and sqlite. When users, like me,
already run a postgresql server, they have to switch to mysql or run 2 database servers.
The kodi database user has to much permissions. It would be better, the admin creates a
database for "kodi" and a user for that database. Kodi can only create and alter the tables.
Everytime the database is being updated, kodi could prompt the user to go on or cancel to
make a backup first. So no old database is being left and has to be deleted (maybe also for sqlite).
I think, users with a separate database are advanced ones. So they should be able to make
a backup before the database is updated by kodi.
I have some remarks about the database:
First of all, postgresql should also be supported, not only mysql and sqlite. When users, like me,
already run a postgresql server, they have to switch to mysql or run 2 database servers.
The kodi database user has to much permissions. It would be better, the admin creates a
database for "kodi" and a user for that database. Kodi can only create and alter the tables.
Everytime the database is being updated, kodi could prompt the user to go on or cancel to
make a backup first. So no old database is being left and has to be deleted (maybe also for sqlite).
I think, users with a separate database are advanced ones. So they should be able to make
a backup before the database is updated by kodi.