> On 31 Oct 2018, at 16:27, Vincent Massol <[email protected]> wrote:
>
>
>
>> On 31 Oct 2018, at 16:19, Ecaterina Moraru (Valica) <[email protected]>
>> wrote:
>>
>> On Wed, Oct 31, 2018 at 5:12 PM Vincent Massol <[email protected]> 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.
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) <[email protected]>
>>> 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) <
>>> [email protected]>
>>>> wrote:
>>>>
>>>>>
>>>>>
>>>>> On Wed, Oct 31, 2018 at 3:53 PM Vincent Massol <[email protected]>
>>> wrote:
>>>>>
>>>>>> Hi Caty,
>>>>>>
>>>>>>> On 31 Oct 2018, at 14:43, Ecaterina Moraru (Valica) <
>>> [email protected]>
>>>>>> 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 <[email protected]>
>>>>>> wrote:
>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> On 31/10/2018 10:52, Thomas Mortagne wrote:
>>>>>>>>> On Wed, Oct 31, 2018 at 10:28 AM Vincent Massol <[email protected]
>>>>
>>>>>>>> wrote:
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>> On 31 Oct 2018, at 10:15, Simon Urli <[email protected]>
>>> 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
>>>>>>>>>>> [email protected]
>>>>>>>>>>> More about us at http://www.xwiki.com
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>> Simon Urli
>>>>>>>> Software Engineer at XWiki SAS
>>>>>>>> [email protected]
>>>>>>>> More about us at http://www.xwiki.com
