On Wed, Oct 31, 2018 at 4:30 PM Vincent Massol <vinc...@massol.net> wrote: > > > > > On 31 Oct 2018, at 16:27, Vincent Massol <vinc...@massol.net> wrote: > > > > > > > >> On 31 Oct 2018, at 16:19, Ecaterina Moraru (Valica) <vali...@gmail.com> > >> wrote: > >> > >> On Wed, Oct 31, 2018 at 5:12 PM Vincent Massol <vinc...@massol.net> wrote: > >> > >>> Hi Caty, > >>> > >>> Thanks but I think we should focus on the databases that our users use for > >>> XWiki. We have that info already with the active installs. > >>> > >> > >> https://www.xwiki.org/xwiki/bin/view/ActiveInstalls/ > >> k, I understand, with the note that those graphs are influenced by what we > >> support. > >> In the case of Active Install, would be nice to display also the DB > >> versions. > > > > 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 > > What’s interesting is that version 8 is not used yet. So we could keep > staying on 5.x for now probably.
XWiki does not start at all on MySQL 8 so not sure it's a good criteria :) > > Thanks > -Vincent > > > 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) <vali...@gmail.com> > >>> wrote: > >>>> > >>>> Another top > >>>> > >>> https://www.eversql.com/most-popular-databases-in-2018-according-to-stackoverflow-survey/ > >>>> > >>>> On Wed, Oct 31, 2018 at 4:45 PM Ecaterina Moraru (Valica) < > >>> vali...@gmail.com> > >>>> wrote: > >>>> > >>>>> > >>>>> > >>>>> 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 > -- Thomas Mortagne