On Wed, Oct 31, 2018 at 5:28 PM 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 Thanks > > > 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 > >>>>>>> > >>>>> > >>>>> > >> > >> > >
