Philip Meyer;566680 Wrote: > I don't see what the issue is with supporting MySQL and SQLite. Is it > the difference in queries, or the support for creating the DB schema, > or supporting the hosting environment?
There is if you've used any MySQL-specific syntax. I know that a large part of the optimizations made for the server running on the Touch consisted of dumping a lot of the OOP database approach that produced garbage queries and instead using native SQL. The "support" really comes into play when it comes to QA testing under both systems, which just plain isn't going to happen with the skeleton crew left on the Squeezebox product. Developers only occasionally test their checkins, as we've always seen, so expecting them to test under both is out of the question. > There's meant to be hardly any differences in terms of queries. I don't > see why MySQL support was broken in the first place when changing back > to SQLite (assumed that there would be specialisations for each SQL DB > type, rather than only support one, and the use of libraries for SQL > queries. Some pluggins were more likely to break though). There are actually some significant differences in how the two systems are used, although it's not in the queries. Such as persistent data being in an entirely new database instead of simply being tables in the one database. Doing joins across databases can add some complexity, and having one system doing this, while it's not required in the other probably has the potential to break a lot of things. >From what I've observed, the main problems seem to be primarily in the system not really knowing that MySQL is the database, and attempting to use both. The external scanner using one, main server using another, then the switch to an in-process scanner for the auto scanning and new & changed scans causing both to run simultaneously. It's kind of a mess, but I'm betting that it wouldn't take too much work to sort out when someone gets around to it. -- JJZolx ------------------------------------------------------------------------ JJZolx's Profile: http://forums.slimdevices.com/member.php?userid=10 View this thread: http://forums.slimdevices.com/showthread.php?t=80914 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
