> On 31 Oct 2018, at 10:28, 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?
Actually what I did is try to follow the “latest” tag on the official docker
images. Since we need some docker images anyway.
Sometime the “latest” tag is really recent though. For postgresql for ex, it’s
11.0, see https://hub.docker.com/_/postgres/
So I suggest as a general rule to follow the dockerhub official image “latest”
tags. WDYT?
Thanks
-Vincent
>
> 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
