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

On 31 Oct 2018, at 16:27, Vincent Massol <vincent(a)massol.net> wrote: Yes. However we can’t support all versions and people usually lag behind. So I don’t think we should support more than the latest one. Already hard to do. BTW we do have the versions, we just don’t display them. See http://activeinstalls.xwiki.org/#/dashboard I did a quick pie chart for mysql: https://www.evernote.com/l/AHe-MYCE-09Nuoyau9jFQf45OgtIZKmaqk0

Thanks -Vincent > > Thanks, > Caty > > >> >> It’s already a lot of work :) >> >> My goal with this thread was not fully review the list of supported >> databses, just to make it more clear the versions of them we want to >> support. >> >> Thanks >> -Vincent >> >>> On 31 Oct 2018, at 15:57, Ecaterina Moraru (Valica) &lt;valicac(a)gmail.com&gt; >> wrote: >>> >>> Another top >>> >> https://www.eversql.com/most-popular-databases-in-2018-according-to-stackov… >>> >>> 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 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? >>>>> >>>> >>>> See >>>> >>>> >> https://trends.google.com/trends/explore?cat=13&date=today%205-y&q=… >>>> and >>>> >>>> >> https://www.statista.com/statistics/809750/worldwide-popularity-ranking-dat… >>>> >>>> According to those pages my questions are: >>>> * Why are we supporting "Hypersonic DB" ? - but hey, apparently it's in >>>> 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 is >>>> 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 &lt;vincent(a)massol.net >>> >>>>>>> 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 >>>>>>> >>>>> >> https://www.oracle.com/technetwork/database/enterprise-edition/downloads/in… >>>>>>> ) >>>>>>>>>> >>>>>>>>>> +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… >>>>>>>> >>>>>>>> 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&a… >>>>>>> >>>>>>> >>>>>>> >>>>> >> https://packages.ubuntu.com/search?suite=default&section=all&arch=a… >>>>>>> >>>>>>> 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