> On 6 Nov 2018, at 10:14, Thomas Mortagne <thomas.morta...@xwiki.com> wrote:
>
> 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 :)
Good point :)
Thanks
-Vincent
>
>>
>> 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
