MrSinatra;602526 Wrote:
>
> is it the case that your plugins, and many others, will only work with
> mysql and can't work with sqlite? or do i have that wrong?
>
It's possible to make them work with both SQLite and MySQL, I will just
have to adapt them a bit. I think they mostly works in both today with
some exceptions. However, I'm not completely sure if I'm going to
support both MySQL and SQLite in 7.6, I might choose to only support
SQLite in 7.6. The reason for this is that it takes time to support
both so I prefer to focus on one of them.
In my opinion, Logitech should really just say that only SQLite will be
supported in 7.6, it's pretty obvious that only SQLite is going to work
if they don't prioritize MySQL bugs. So in a scenario like this, why
even give users a choice ?
MrSinatra;602526 Wrote:
>
> i'm just curious as to future impact... my understanding is that
> sqlite will be faster, the default, won't need an external separate
> process, and will eliminate AV and win defender type issues, so its
> likely where i'll be headed.
>
Not sure SQLite is faster, besides the scanner, 7.6 is faster than 7.5
but that's also related to other changes, especially related to the
scanning process.
The only doubt some people have had regarding SQLite is that:
- MySQL might be faster in larger libraries, but no one has been able
to prove that yet because 7.5 only works with MySQL and 7.6 only works
with SQLite at the moment.
- It's easier to access and manually do modifications to the MySQL
database due to its networked interface and all the client tools
available.
I assume Logitech is resonably convinced that SQLite will work good
enough in the largest library they like to support, so this means that
the first point isn't an issue. To me this means that there is really
no reason for them to support MySQL at all, it just takes up valuable
development time that could be used to correct other bugs. I would
prefer that they focus on fixing music related bugs instead of spending
time fixing bugs related to a low priority database backend.
So my suggestion to Logitech is to completely drop MySQL support in 7.6
and only focus on SQLite.
I suspect the only reason they haven't done so already is that they are
afraid to get critique from the community and don't want to spend time
discussing it. To me, Andy's "MySQL is not a top priority for 7.6"
statement really means "MySQL won't work in 7.6 and we don't plan to
support it".
My suggestion the the community is just to accept SQLite, it's here to
stay and it's a lot better than it was a few years back.
Let's focus on the music related stuff which really matters instead of
technical issues like this which don't have any impact on our music
listening experience.
--
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=84697
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta
