Chapter 9. Database Management
Prev | Part I. Tigase Administration Guide | Next

## Chapter 9. Database Management

Tigase is coded to perform with multiple database types and numbers. Owing to it’s versatile nature, there are some tools and procedures that may be of use to certain administrators.

## Recommended database versions

As of v8.0.0 here are the minimum and recommended versions of databases for use with Tigase:

Database | Recommended Version | Minimum Version | Additional Information
--- | --- | --- | ---
DerbyDB | 10.12.1.1 | 10.12.1.1 | Included with Tigase XMPP Server
MySQL | 5.7 | 5.6.4 | Required to properly support timestamp storage with millisecond precision
SQLServer | 2014 | 2012 | 2012 needed so we can count use fetch-offset pagination feature.
PostgreSQL | 9.5 | 9.4 | New UA schema requires at least 9.4
MongoDB | 3.2 | 3.0 |
MariaDB | ? | 10.0.12 | Basic features works with 10.0.12-MariaDB Homebrew, but is not fully tested.

Although Tigase may support other versions of databases, these are the ones we are most familiar with in offering support and advice. Use of databases outside these guidelines may result in unforeseen errors.

Prev | Up | Next
TLS/SSL encryption features configuration | Home | Database Watchdog