Database Support Strategy

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

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.

By "supporting" we mean:

  • Issues created for these databases in JIRA are not closed as won't fix and we make a best effort to fix them.
  • We try as much as possible to include these databases in our tests (be them automated or manual).
  • 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.
  • 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).

Supported databases

DatabaseVersionsReason for supporting it
HyperSQL
LatestCurrently Hypersonic DB is used in embedded mode in our standalone distribution.
MariaDB
Latest + LTS version strategy. Currently tested: .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)
MySQL
Latest + LTS version strategy. Currently tested: .MySQL is one of the most used open source database.
PostgreSQL
Latest + LTS version strategy. Currently tested: .PostgreSQL is also one of the most used database (especially when building an open source stack)
Oracle
Latest + LTS version strategy. Currently tested: .Being an enterprise wiki, XWiki also supports Oracle to be "business"-friendly

Databases that are not supported

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 about them and it's easy to fix (or if someone provides a patch) then we fix it.

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

Database
H2
IBM DB2 Database
Microsoft SQL Server
Apache Derby

You can Search the XWiki mail archive to see all discussion threads about the Database you're interested in.

Tags:
   

Get Connected