On Wed, Oct 31, 2018 at 3:53 PM Vincent Massol <vinc...@massol.net> wrote:
> Hi Caty, > > > On 31 Oct 2018, at 14:43, Ecaterina Moraru (Valica) <vali...@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=%2Fm%2F01vw9z,%2Fm%2F04y3k,%2Fm%2F0120vr,%2Fm%2F05ynw,Hyper%20SQL and https://www.statista.com/statistics/809750/worldwide-popularity-ranking-database-management-systems/ 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.u...@xwiki.com> > wrote: > > > >> > >> > >> On 31/10/2018 10:52, Thomas Mortagne wrote: > >>> On Wed, Oct 31, 2018 at 10:28 AM Vincent Massol <vinc...@massol.net> > >> wrote: > >>>> > >>>> > >>>> > >>>>> 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? > >>> > >>> 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&exact=1 > >>> > >>> 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&exact=1 > >> > >> > >> > https://packages.ubuntu.com/search?suite=default§ion=all&arch=any&keywords=postgresql&searchon=names > >> > >> 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.u...@xwiki.com > >>>>> More about us at http://www.xwiki.com > >>>> > >>> > >>> > >> > >> -- > >> Simon Urli > >> Software Engineer at XWiki SAS > >> simon.u...@xwiki.com > >> More about us at http://www.xwiki.com > >> > >