>I'm guessing some people will scream at me now but I still have to ask, >is there any point keeping MySQL if it isn't an officially supported >solution verified by QA ? > MySQL works great for me - I see no point in switching to SQLite which may not work as well.
I've had little joy with 7.6 with either MySQL or SQLite so far, but there do appear to be issues with MySQL->SQLite upgrade, and specific things that don't work well with SQLite at all (eg. requiring locking, differences with sorting diacritics, performance with big libraries, etc). I have my own instance that is permanently running, which is a benefit during development when frequently restarting the server (I think?). 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'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). >Is there a reason to keep MySQL besides that some people are used to it? What benefits are there for a user to change from MySQL to SQLite? Other than issues with support, are there actually any benefits (things that work better) in SQLite over MySQL? i.e. I understand there are some issues with virus scanners interfering with MySQL that are a headache for support, and hence the desire for SQLite. I assume that end-user support for MySQL (in terms of OS specific issues) would not be officially supported, but the actual product would support MySQL. >I know MySQL has advantages over SQLite, it just feels like wasted time >to have both when development resources are limited. > One could also say that there's not much reason to support various fringe hosting environments, such as some more obscure flavours of OS, NAS boxes, CLI's for third-party apps, etc. How many end-users actually run Linux, compared to Windows? _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
