Which database to choose?
ManicTime Server supports three types of databases:
- SQLite
- MS SQL
- PostgreSql
SQLite is a file database, there is nothing to install, it works out of the box.
The other two are much more powerful database engines, which you need to install, prior to installing ManicTime Server. Both can handle more data and more users than SQLite. It doesn't matter which of the two you choose, both have similar capabilities.
Comparison table
| SQLite | PostgreSQL | Microsoft SQL Server | |
| Is it free? | Yes | Yes | MS SQL Express is a free version, supporting databases of up to 10GB in size (download) |
| Backup plan | You can stop the server and copy database file | Yes | Yes |
| Need to install before installing ManicTime Server | No | Yes | Yes |
| Recommended number of users | Up to 5, but may work ok with more | No limit | No limit |
| Use SQL to transfer data from ManicTime Server to some other database | Yes | Yes | Yes |
| Can be hosted on a different machine | No | Yes | Yes |