+1 On Mon, Nov 12, 2018 at 5:37 PM Vincent Massol <vinc...@massol.net> wrote: > > > > > On 12 Nov 2018, at 16:52, Vincent Massol <vinc...@massol.net> wrote: > > > > So we need to conclude on this thread. I’m proposing to update the page > > with: > > > > * HSQLDB - Latest only > > * MySQL - latest of oldstable/stable/unstable from > > https://packages.debian.org/search?keywords=mysql-server&searchon=names&exact=1 > > (i.e. latest of 5.5.x and 5.7.x today) > > * PostgreSQL - latest of oldstable/stable/unstable > > fromhttps://packages.debian.org/search?keywords=postgresql&searchon=names&exact=1 > > (i.e. latest of 9.4.x, 9.6.x and 11.x today) > > * Oracle - latest of 12.x (we currently test on 11.x AFAIK so we need to > > start testing on 12.x from now on) > > > > Note that by “support" we mean test on. And it’s not because a version is > > not supported that it doesn’t work nor that we won’t fix it if a problem > > happens. > > > > I hesitated a long time for the mysql/pgsql versions since I wanted only a > > single version supported, but since we provide a debian packaging it makes > > sense to test the versions defined by the debian repos, and now that we > > have automated functional tests on various configurations, we can test on > > them. BTW I suggest we run all tests on the latest version only (i.e. 5.7.x > > for mysql and 11.x for postgresql, and move to mysql 8.x when we fix the > > bug on it) and then we do smoke tests on the other versions. > > > > Let me know quickly if you have a problem with this strategy since I’d like > > to update the page + add the configs in our CI tests. > > FYI, I’ve now updated the page at > https://dev.xwiki.org/xwiki/bin/view/Community/DatabaseSupportStrategy (but I > can update/revert if need be). > > Thanks > -Vincent > > > > > Thanks > > -Vincent > > > > > >> On 31 Oct 2018, at 09:06, Vincent Massol <vinc...@massol.net> 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) > >> > >> 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) > >> > >> 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? > >> > >> So WDYT about the 3 questions? > >> > >> Thanks > >> -Vincent > > >
-- Thomas Mortagne