Database

Supported databases

Currently Gerrie supports only MySQL.

Note

You want to support another database like PostgreSQL or a NoSQL database? Feel free to contribute. This is _very_ welcome!

Setup the schema

To setup the schema the database itselfs has to be exists. Please create this database before using Gerrie. A command can look like

CREATE DATABASE gerrie;

Based upon this you can create the database schema. The gerrie:setup-database command will help you to setup the database schema.

Schema

To query the database and answer questions based on this data it is important that you will understand how the data is structured. MySQL is a typical RDBMS. So we use a typical table / column schema to reflect the complex data structure of Gerrit. Below you will find a visualisation of the database scheme as entity relationship model.

../_images/eer-diagram.png

This entity relationship model was created with MySQLWorkbench. If you want to get a deeper look at this schema to investigate it, you can install MySQLWorkbench and load the source file eer-diagram.mwb.