Lavagna support the following databases:
- MySQL version 5.1 or later
- MariaDB version 10.0 or later
- PostgreSQL version 9.2 or later
- embedded HSQLDB version 2.3.1
If it’s not possible to use MySql or Postgresql and the full text search feature is not important, the HSQLDB backend can be used with a file backend. See the HSQLDB section below.
When using MySql, for ensuring a good full text search experience, it’s advisable to set in the MySql configuration file:
The default 4 minimal word length can be problematic for searching 3 letters acronyms.
Additionally, when creating the database, it must ensured that utf-8 is used everywhere:
CREATE DATABASE lavagna CHARACTER SET utf8 COLLATE utf8_bin;
Unit tests are run also on MariaDB and as a general rule everything that must be done for MySql must be done also for MariaDB.
When using PostgreSQL, ensure that the database/schema is in utf-8.
For the full text search support, the unaccent extension must be present. In general it’s already included in the PostgreSQL
installation. If it’s not present, an error will be launched when running lavagna the first time.
It’s the default development database. But it’s possible to use it a persistent way: when configuring the jdbc url, the file backend can be used: