Philip Meyer;604215 Wrote: > >b/c i have had many problems not with AV, but windows defender, that i > >believe cost me two raptor HDs. > ??? Are you saying that because SBS was using MySQL, it cost you two > raptor HD's, and switching to SQLite will obviously prevent that from > ever happening again? > > Or in reality perhaps Windows Defender was the problem, and thus > removing that would prevent the problem.
hard to do, no, impossible to do, when its part of the operating system. besides, logitech isn't in the business of martyring itself. it is the parasite, it doesn't have the weight to tell microsoft whats up. they know they need to give customers the best experience. and yes, i am saying SBS cost me two hard drives. when SBS was killed in task manager, the issues stopped. which app was at fault really isn't the point. Philip Meyer;604215 Wrote: > > >anyway, erland says his plugins (which i don't use, but i will test > the > >one this weekend!) will work on sqlite. > > > Might not work as well - who knows unless they are completely > regression tested (and with comparative stats to see whether there's an > improvement or degradation in performance). i don't know, and i don't worry about it, since i don't use plugins generally, but i take erland at his word, and like i said i don't hear any big reason which outwieghs the benefits. Philip Meyer;604215 Wrote: > > >so my question is what > >indispensible plugin or feature do we lose if mysql is no longer > >supported? > > > Who knows, unless everything is retested. And where several of the > third-party plugin devs have departed or no longer maintaining their > plugins, how will they be upgraded? always the case. you could have plugins break just by a new version on SBS that still uses mysql. frankly, this is not compelling. Philip Meyer;604215 Wrote: > > >frankly, i doubt there is any. > Quite possibly most will work. But also likely that a few will not > without (minor) changes. to be clear, i was saying frankly i doubt there is any INDISPENSIBLE plugin or feature that will be lost. surely some things will be lost, but i haven't heard anyone mention a showstopper. Philip Meyer;604215 Wrote: > > >whatever niche cases there are, really don't hold any water. give me > a > >showstopping reason as to why mysql must be maintained, or get over > it. > In the old days, when there was SlimServer, it used its own data > structure, not a DB engine. > Then it was changed to use SQLite. > This had loads of problems, and thus the engine was switched to use > MySQL. Support for SQLite was dropped instead of maintaining it in > case it was ever switched back. This has worked well; it is a known > and trusted entity. It will work better with large libraries (but at > what library size is unknown). There are less locking issues; it is a > better DB engine with better tools. > > There was much joy with devs when SQLite was dropped and MySQL was > used. > > It just seems strange to me to totally remove support for the engine, > seeing that: > 1) history has shown that this product has changed it's mind over DB > engine several times already. > 2) MySQL worked fine, and really should be simple to maintain: > a) DB Engine comms is a one-off job, already done (but broken). > Should have added support for SQLite, rather than change support. It > would be a bit like changing WixXP support for Vista, instead of adding > Vista support. > b) SQL statements have some minor differences (MySQL generally has > more functionality - I think closer support of ANSI SQL, and better > extended functions support). In most cases ANSI-SQL will work with > both engines. > > Of course, the only real reason why DB engine is changing again is to > support Tiny SBS, a product that has much reduced functionality, > otherwise I'm pretty sure full SBS wouldn't be changing. That driving > decision is going to creep in all the time, with full SBS functionality > being reduced to meet requirements of TinySBS. while tinysbs is probably the driving reason, there are lots of other good reasons, like other low-powered hardware, and eliminating extra processes and software conflicts. to me it makes perfect sense. Philip Meyer;604215 Wrote: > At the same time, I agree - if SQLite were indeed a better solution, > there'd be no reason to support MySQL. However, SQLite isn't a better > solution (for full SBS). and i am saying why do you say that? what exactly do you lose that outweighs the benefits of sqlite? the benefits of switching to sqlite are clear as a bell to me. the drawbacks clear as mud. Philip Meyer;604215 Wrote: > I'm thinking that actually, full SBS isn't so much on the agenda these > days, just Tiny SBS as that is a selling point for newer hardware > players. Maybe OS support will be dropped next, because it only needs > to run on Linux to run on Touch (I think not, but maybe more > development for Tiny SBS and less of a driver for full SBS, and Tiny > SBS bugs/enhancements may take precidence over support for lesser used > OS's in full SBS). unlikely. this would only happen if they started selling a server box to go with the player box, (meaning something better than the touch server). besides, they have such a large installed userbase, i just can't see it happening, it would alienate way too many users. Philip Meyer;604215 Wrote: > No doubt that some time in the future I will switch to 7.6 with SQLite. > But at the moment, 7.6/SQLite doesn't seem to run too well for me. It > doesn't seem to improve performance, and some plugins don't work. > There's little incentive (killer features in 7.6) - yet! > > Phil i refuse to even test 7.6 yet. it sounds nightmarish to me. but thats the nature of the beast. i expect that over time they will get sqlite running smoothly on 7.6, and when they do, and get closer to actually releasing it, i'll be happy to move to it. i just don't see any reason to worry about and/or lament the switch, and for me, i think it will be an improvement. -- MrSinatra www.lion-radio.org using: sb2 & sbc (my home) / sbrec & ipeng (parents' home) - sbs 7.5.3b - win xp pro sp3 ie8 - p4(ht) 3.2ghz, 2gig ram - 1tb wd usb2 raid1 - d-link dir-655 - 45k+ mp3 ::VOTE FOR 'BUG 15604' (http://bugs.slimdevices.com/show_bug.cgi?id=15604)!!!:: ------------------------------------------------------------------------ MrSinatra's Profile: http://forums.slimdevices.com/member.php?userid=2336 View this thread: http://forums.slimdevices.com/showthread.php?t=84697 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
