Wiki source code of Database Support Strategy

Last modified by Vincent Massol on 2020/10/05 17:31

Show last authors
1 There are a lot of databases out there and supporting all of them in all versions is just too hard to be done in a quality manner.
2
3 By "supporting" we mean:
4
5 * Issues created for these databases in JIRA are not closed as won't fix and we make a best effort to fix them.
6 * We try as much as possible to include these databases in our tests (be them automated or manual).
7 * When we create new features or modify existing features we make a best effort to verify that they work on the supported list of databases.
8 * The complete and precise list of tested databases in a given XWiki release is indicated in the Release Notes for that release (starting with XWiki 4.0-milestone-2).
9
10 = Supported databases =
11
12 |=Database|=Versions|=Reason for supporting it
13 |(((
14 {{database name="hsqldb"/}}
15 )))|[[Latest>>http://hsqldb.org/]]|Currently Hypersonic DB is used in embedded mode in our standalone distribution.
16 |(((
17 {{database name='mariadb'/}}
18 )))|[[Latest + LTS version strategy>>Community.SupportStrategy.LatestLTSDefinition]]. Currently tested: {{productVersions product = 'mariadb'/}}.|MySQL has been replaced by MariaDB in all Debian and most of the Linux distributions, and is thus going to be used more and more (especially when building an open source stack)
19 |(((
20 {{database name="mysql"/}}
21 )))|[[Latest + LTS version strategy>>Community.SupportStrategy.LatestLTSDefinition]]. Currently tested: {{productVersions product = 'mysql'/}}.|MySQL is one of the most used open source database.
22 |(((
23 {{database name="postgresql"/}}
24 )))|[[Latest + LTS version strategy>>Community.SupportStrategy.LatestLTSDefinition]]. Currently tested: {{productVersions product = 'postgresql'/}}.|PostgreSQL is also one of the most used database (especially when building an open source stack)
25 |(((
26 {{database name="oracle"/}}
27 )))|[[Latest + LTS version strategy>>Community.SupportStrategy.LatestLTSDefinition]]. Currently tested: {{productVersions product = 'oracle'/}}.|Being an enterprise wiki, XWiki also supports Oracle to be "business"-friendly
28
29 = Databases that are not supported =
30
31 The following databases are not officially supported. XWiki may work with them, completely or partly. We don't constantly test against it, we don't ensure that new features work on them. However whenever someone raises an issue on [[JIRA>>https://jira.xwiki.org]] about them and it's easy to fix (or if someone provides a patch) then we fix it.
32
33 {{info}}
34 Note that we use Hibernate for our persistence and thus if the database you wish to use is supported by Hibernate you should be able to make it work in XWiki. However it may require tuning some Hibernate HBM files
35 {{/info}}
36
37 |=Database
38 |(((
39 {{database name="h2"/}}
40 )))
41 |(((
42 {{database name="db2"/}}
43 )))
44 |(((
45 {{database name="mssql"/}}
46 )))
47 |(((
48 {{database name="derby"/}}
49 )))
50
51 You can [[Search the XWiki mail archive>>Community.MailingLists||anchor="HArchives"]] to see all discussion threads about the Database you're interested in.

Get Connected