erland;449502 Wrote: > > Well, you can't blame Logitech for this. > > They provide the database abstraction layer because it contained all > functionality they needed for the server implementation. You can't > really expect them to make an abstraction layer to cover every possible > usage.
Oh, no I don't blame them at all.. your plugins are almost by nature going to push the edge of any sort of schema/backend. If only SQL were a real standard, it would be trivial to use MySQL/SQLite/Postgres/Oracle/DB2/whatever. "Yeah, just use this DB connector and you're done!" But, alas, it's not. > > It also contains all functionality that I would need in my plugins if I > had implemented them the correct way. However, I selected the quick and > dirty path to get something out that worked and solved the problem, > instead of making the proper solution to invent and implement my own > query language for smart playlists. The reason I selected the quick path > was that I do this on my spare time and it would take too much time to > do the proper solution. Didn't mean it as a criticism of your appreciated work, just the "yeah db backends change, and just like the bug 6.5 change, lots of things broke" dejavu'ishness of it all. I survived back then (and was happy to switch to MySQL), and even if MySQL support is dropped, I'd still survive (but would have to fiddle with some PHP code I have to list albums.. oh, well). > > As a database engine it's a lot better than it was back in 2006 (when I > think the MySQL switch was). I remember it had problem running more > complex SQL statements back in 2006 but now the same statements works > perfectly in the current SQLite version. The only thing I had to change > to make the SQL statements in my plugins to work in SQLite in 7.4 was > some MySQL specific functions and some joined UPDATE statements. And the joys of different ways to do 'RANDOM' order by clauses. SQLite performance on low end hardware is apparently a TON faster than MySQL on the same hardware. On more expensive hardware, I think the difference is less, but if it stops the neverending "why do I get 'cant write to *.MYI' errors" from dumb Antivirus software, that's a huge bonus as well. The backend db for anything (whether it is SC/SBServer/SS/whatever) is almost always a religious issue. -- snarlydwarf ------------------------------------------------------------------------ snarlydwarf's Profile: http://forums.slimdevices.com/member.php?userid=1179 View this thread: http://forums.slimdevices.com/showthread.php?t=66745 _______________________________________________ discuss mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/discuss
