gharris999;611875 Wrote:
> Obviously, compared to your work, I've only lightly dabbled in db /
> plugin interactions. But from my very limited experience, to me it
> seems like SQLite does provide at least one major feature for the SBS
> plugin developer missing from MySQL, namely, the
> DBD::SQLite::sqlite_create_function() function. To me, this opens up a
> whole raft of possibilities that one just can't accomplish via
> DBD::MySQL.
>
Yes, from a functionality point there isn't a reason to choose MySQL.
As you say, the sqlite_create_function makes it really flexible to add
custom stuff with SQLite.
The advantage with MySQL is only:
- That is has a networked based protocol
- That SBS handles it as a multi user database, so you can easily
connect to it with a client application at the same time as it's used
by SBS. With SQLite you need to disable locking to do the same thing.
- There are a lot better SQL clients available for MySQL
Anyway, there is really not much point discussing all this, the choice
have been made, so the only thing left to do is that people that want
to be able to continue using MySQL needs to spend some time help
Logitech to test and provide patches and/or vote on MySQL related
bugs/enhancements.
Personally, I've decided to instead spend my time implementing third
party features that affects my music listening/exploring experience
instead of focus on technical stuff like supporting multiple database
engines. I might not drop support for MySQL in my plugins but I'm
definitely going to focus any testing in 7.6 on SQLite as that's what's
going to be used by most users.
--
erland
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
(Developer of 'many plugins/applets'
(http://wiki.slimdevices.com/index.php/User:Erland). If my answer
helped you and you like to encourage future presence on this forum
and/or third party plugin/applet development, 'donations are always
appreciated' (http://erland.isaksson.info/donate))
------------------------------------------------------------------------
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=85714
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta
