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

On 31 Oct 2018, at 15:57, Ecaterina Moraru (Valica) <valicac(a)gmail.com> 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> wrote: > > > On Wed, Oct 31, 2018 at 3:53 PM Vincent Massol <vincent(a)massol.net> wrote: > >> Hi Caty, >> >>> On 31 Oct 2018, at 14:43, Ecaterina Moraru (Valica) <valicac(a)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? >> > > 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 <simon.urli(a)xwiki.com> >> wrote: >>> >>>> >>>> >>>> On 31/10/2018 10:52, Thomas Mortagne wrote: >>>>> On Wed, Oct 31, 2018 at 10:28 AM Vincent Massol <vincent(a)massol.net> >>>> wrote: >>>>>> >>>>>> >>>>>> >>>>>>> On 31 Oct 2018, at 10:15, Simon Urli <simon.urli(a)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/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 >>>> >> >>