Cacher is the code snippet organizer for pro developers

# MariaDB and LibreOffice on Manjaro/Archlinux

## Preparation

### Requirements

* Install MaraiDB: Follow installation guide here: https://wiki.archlinux.org/index.php/MySQL
* Install MariaDB-JDBC-Driver (https://aur.archlinux.org/packages/mysql-jdbc/), e.g. by
```
    yaourt -Sa mariadb-jdcb
```
* JARs will be installed in /usr/share/java/mariadb-jdbc

### Register JDBC-Driver

* Open LibreOffice and navigate to: Tools -> Options -> LibreOffice -> Advanced 
* Click "Class Path" and add then "Add Archive ..."
* Select /usr/share/java/mariadb-jdbc/maria-java-client.jar
* Click OK and restart Libre Office

## Setting up a connection to MariaDB/MySQL

* Start LibreOfficeBase, the DB wizard will come up
* choose "Select Database" and then "Connect to an existing database"
* Select "MySQL" from the dropdown menu and hit "Next"
* Fill in your database name (e.g. "mysql", is installed by default)
* Server will be "localhost", port number usually 3306
* In the field MySQL JDBC driver class, enter:
```
org.mariadb.jdbc.Driver
```
* Click "Next" and finish the Wizard