31 Oct
2018
31 Oct
'18
4:19 p.m.
On Wed, Oct 31, 2018 at 5:12 PM Vincent Massol <vincent(a)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.
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
wrote:
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> >>>>>>>
>>>>>>> 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§ion=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
>>>>
>>
>>