Hi Caty, > On 31 Oct 2018, at 14:43, Ecaterina Moraru (Valica) <vali...@gmail.com> wrote: > > IMO we should just write we support: > * HyperSQL 2.x Latest > * MySQL 5.x Latest > * PostgreSQL 9.x Latest > * Oracle 11.x Latest > not sure what help would do to have the explicit 2.4.1, 5.7.24, 9.6.10, > 11.2.0.4.0 versions.
Yes, this is what I proposed. > > Also I'm sure we won't keep up with the versions, so they won't mean > latest. > When we do the tests we should always fix and test on the latest one. > And this 'latest' behavior is consistent with what we do for Browsers, with > the exception that we are a bit more descriptive by giving the DB cycle. Sure. Note that there’s more in this thread, for example: 1) What does latest mean? 2) What about the other 2 questions I asked? WDYT about that? Thanks -Vincent > > Thanks, > Caty > > > On Wed, Oct 31, 2018 at 12:11 PM Simon Urli <simon.u...@xwiki.com> wrote: > >> >> >> On 31/10/2018 10:52, Thomas Mortagne wrote: >>> On Wed, Oct 31, 2018 at 10:28 AM Vincent Massol <vinc...@massol.net> >> wrote: >>>> >>>> >>>> >>>>> On 31 Oct 2018, at 10:15, Simon Urli <simon.u...@xwiki.com> 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 >> >> Maybe it worth it to also look on Ubuntu packages for the LTS, as they >> don't follow the same cycle: >> https://packages.ubuntu.com/search?keywords=mysql-server >> >> Apparently for now version are the same than for Debian. >>> >>> 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 >> >> >> https://packages.ubuntu.com/search?suite=default§ion=all&arch=any&keywords=postgresql&searchon=names >> >> So here I see 9.3, 9.5, 10.5 >> >>> >>> 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 >>>>> simon.u...@xwiki.com >>>>> More about us at http://www.xwiki.com >>>> >>> >>> >> >> -- >> Simon Urli >> Software Engineer at XWiki SAS >> simon.u...@xwiki.com >> More about us at http://www.xwiki.com >>