Supported Databases¶

SQLite¶

RhodeCode Enterprise installs SQLite as the default database if you do not specify another during installation. SQLite is suitable for small teams, projects with a low load, and evaluation purposes since it is built into RhodeCode Enterprise and does not require any additional database server. However, we do not recommend using SQLite in a large development environment as it has an internal locking mechanism which can become a performance bottleneck when there are more than 5 concurrent users.

Using MySQL or PostgreSQL in an large setup gives you much greater performance, and while migration tools exist to move from one database type to another, it is better to get it right first time and to immediately use MySQL or PostgreSQL when you deploy RhodeCode Enterprise in a production environment.

MySQL¶

To use a MySQL database you should install and configure the database before installing RhodeCode Enterprise. This is because during RhodeCode Enterprise installation you will setup a connection to your MySQL database. To work with MySQL, use the following steps:

1. Depending on your operating system, install a MySQL database following the appropriate instructions from the MySQL website.
2. Configure the database with a username and password which you will use with RhodeCode Enterprise.
3. Install RhodeCode Enterprise, and during installation select MySQL as your database.
4. Enter the following information to RhodeCode Enterprise during the database setup:
   • Your network IP Address
   • The port number for MySQL access. The default MySQL port is 3306
   • Your database username
   • Your database password
   • A new database name

PostgreSQL¶

To use a PostgreSQL database you should install and configure the database before installing RhodeCode Enterprise. This is because during RhodeCode Enterprise installation you will setup a connection to your PostgreSQL database. To work with PostgreSQL, use the following steps:

1. Depending on your operating system, install a PostgreSQL database following the appropriate instructions from the PostgreSQL website.
2. Configure the database with a username and password which you will use with RhodeCode Enterprise.
3. Install RhodeCode Enterprise, and during installation select PostgreSQL as your database.
4. Enter the following information to RhodeCode Enterprise during the database setup:
   • Your network IP Address
   • The port number for MySQL access. The default MySQL port is 5434
   • Your database username
   • Your database password
   • A new database name