> 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?
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