On Wed, Oct 31, 2018 at 10:28 AM Vincent Massol <[email protected]> wrote: > > > > > On 31 Oct 2018, at 10:15, Simon Urli <[email protected]> wrote: > > > > Hi, > > > > On 31/10/2018 09:06, Vincent Massol wrote: > >> Hi devs, > >> We currently have > >> https://dev.xwiki.org/xwiki/bin/view/Community/DatabaseSupportStrategy > >> However, it doesn’t say explicitly which versions we officially support: > >> * For HSQLDB it says 2.3.3 which is wrong since the latest version is 2.4.1 > >> * For MySQL it says 5.x but doesn’t specify which specific version(s) > >> * Same for other DBs > >> We cannot really support every versions since supporting means testing too. > >> So what I propose: > >> Question 1: definition > >> * We say we support the latest stable version of the databases for a given > >> version cycle > >> ** For MySQL, it’s the latest of the 5.x cycle, which is 5.7.24 as of > >> today (see https://hub.docker.com/_/mysql/) > >> ** For PostgreSQL, it’s the latest of the 9.x cycle, which is 9.6.10 as > >> of today (see https://hub.docker.com/_/postgres/) > >> ** For Oracle, it’s the latest of the 11.x cycle, which is 11.2.0.4.0 as > >> of today (see > >> https://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html) > > > > +1 > > > >> Question 2: review what we support > >> * For MySQL I think we could also start supporting MySQL 8.x (ie the > >> latest version of that cycle). We have an issue open for it currently: > >> https://jira.xwiki.org/browse/XWIKI-15215 > >> * For PostgreSQL we could also start supporting versions 11.x (ie the > >> latest version of that cycle) > >> * For Oracle, we could also start supporting versions 12.x (ie the latest > >> version of that cycle) > > > > +0 I don't really know how much effort it involves to ensure the support of > > the latest version of each database and to fix the bugs accordingly. > > > >> Question 3: decide if we drop some support > >> * Is there any cycle that we should support for? Right now I think that > >> MySQL 5.x is still heavily used, same for postgreSQL 9.x I guess. Don’t > >> know for Oracle. > >> * Any idea? > > > > What about the cycles that are bundled in major LTS distributions? > > You mean the versions from apt-get for ex (when using the default repos)? > > Indeed the idea could to follow one of them. Any suggestion for which one to > follow and where the info is?
Since we provide Debian package one good reference to know which version of MySQL to support IMO would be https://packages.debian.org/search?keywords=mysql-server&searchon=names&exact=1 So it would be good to support 5.5 and 5.7 Here is the one for postgresql (since we also have a pgsql based Debian package) https://packages.debian.org/search?keywords=postgresql&searchon=names&exact=1 So 9.4, 9.6 and 11 > > Thanks > -Vinent > > > > > Simon > > > >> So WDYT about the 3 questions? > >> Thanks > >> -Vincent > > > > -- > > Simon Urli > > Software Engineer at XWiki SAS > > [email protected] > > More about us at http://www.xwiki.com > -- Thomas Mortagne
