Re: [xwiki-devs] [Proposal] Update database support strategy

On 31 Oct 2018, at 16:19, Ecaterina Moraru (Valica) <valicac(a)gmail.com>

On Wed, Oct 31, 2018 at 5:12 PM Vincent Massol <vincent(a)massol.net>

> Hi Caty, > > Thanks but I think we should focus on the databases that our users use

https://www.xwiki.org/xwiki/bin/view/ActiveInstalls/ k, I understand, with the note that those graphs are influenced by what

support. In the case of Active Install, would be nice to display also the DB versions.

Thanks, Caty > wrote: >> >> Another top >> >

>> >> On Wed, Oct 31, 2018 at 4:45 PM Ecaterina Moraru (Valica) < > valicac(a)gmail.com&gt; >> wrote: >> >>> >>> >>> On Wed, Oct 31, 2018 at 3:53 PM Vincent Massol &lt;vincent(a)massol.net&gt; > wrote: >>> >>>> Hi Caty, >>>> >>>>> On 31 Oct 2018, at 14:43, Ecaterina Moraru (Valica) < > valicac(a)gmail.com&gt; >>>> 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

>>>>> And this 'latest' behavior is consistent with what we do for

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

>>> and >>> >>> >

>>> >>> According to those pages my questions are: >>> * Why are we supporting "Hypersonic DB" ? - but hey, apparently it's

>>> the jetty thing. k :) Here we should just say latest, without any > version >>> to it. This DB is anyway only recommended for the demo version. >>> * Why don't we support Microsoft SQL Server? >>> >>> Another reference: >>> https://db-engines.com/en/ranking >>> >>> * MongoDB also is in the top 5 for 2018 in multiple resources. Should

>>> could we also support that? In the Relational Databases section, DB2

>>> listed, see https://db-engines.com/en/ranking/relational+dbms >>> >>> Anyway, I think it would be enough if we support the top 3 DB for the >>> latest versions. This would mean just MySQL 8.x instead of MySQL 5.x. > Could >>> not find any relevant comparison for DB versions. Found a graph from > 2015 >>> in https://plumbr.io/blog/io/most-popular-relational-databases where >>> MySQL 5.6 was most popular (long time ago), so not sure what we could > use >>> as a reference. On the other hand MySQL 8.0 launched 6 month ago. So >>> indeed, we should support the latest 5.7.x (5.7.24) and also 8.0.x >>> (8.0.13), see https://en.wikipedia.org/wiki/MySQL#Release_history >>> >>> Regarding PostgreSQL, IMO we should support (10.5 || 9.6.10) and 11.0, > see >>> https://en.wikipedia.org/wiki/PostgreSQL#Release_history >>> >>> Regarding Oracle Database, we should support 12.2.0.1 and 18.1.0, see >>> https://en.wikipedia.org/wiki/Oracle_Database#Releases_and_versions >>> >>> Regarding Microsoft SQL Server it should be (in case we decide it) SQL >>> Server 2017, see >>> https://en.wikipedia.org/wiki/Microsoft_SQL_Server#Currently >>> >>> My rule was: latest/latest + the latest stable/previous version. >>> >>> Thanks, >>> Caty >>> >>> >>>> >>>> WDYT about that? >>>> >>>> Thanks >>>> -Vincent >>>> >>>> >>>>> >>>>> Thanks, >>>>> Caty >>>>> >>>>> >>>>> On Wed, Oct 31, 2018 at 12:11 PM Simon Urli &lt;simon.urli(a)xwiki.com&gt; >>>> wrote: >>>>> >>>>>> >>>>>> >>>>>> On 31/10/2018 10:52, Thomas Mortagne wrote: >>>>>>> On Wed, Oct 31, 2018 at 10:28 AM Vincent Massol <

>> >>>>>> wrote: >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>>> On 31 Oct 2018, at 10:15, Simon Urli &lt;simon.urli(a)xwiki.com&gt; > 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 >>>>>> >>>> >

>>>>>> ) >>>>>>>>> >>>>>>>>> +1 >>>>>>>>> >>>>>>>>>> Question 2: review what we support >>>>>>>>>> * For MySQL I think we could also start supporting MySQL 8.x

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

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

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

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

>>>>>> >>>>>> >>>>>> >>>> >

>>>>>> >>>>>> 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.urli(a)xwiki.com >>>>>>>>> More about us at http://www.xwiki.com >>>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> -- >>>>>> Simon Urli >>>>>> Software Engineer at XWiki SAS >>>>>> simon.urli(a)xwiki.com >>>>>> More about us at http://www.xwiki.com >>>>>> >>>> >>>> > >