While on my trip, I have decided to try LibreOffice - since it is more modern with apparently better support.
- The MariaDB database, like MySQL, is widely supported by programming and scripting languages. LibreOffice Base Base can be used to provide a graphical front end to a MySQL database, complete with table design, forms, and reports (similar to Microsoft Access). To connect to a MySQL database using Base, please follow these steps.
- MariaDB runs on port 3306 by default and creates a local unix socket at /var/lib/mysql/mysql.sock. By default, data is stored in the /var/lib/mysql directory and logs are located under /var/log/mariadb/. In order to change these directories, pay attention to use correct SELinux context and owner.
The file mariadb-java-client-2.4.0.jar is downloaded from JRE is installed and enabled under LibreOffice Tools Options Advanced (according to the Mariadb connector page, only Java is required, not SDK).
Connect Libreoffice Base To Mariadb
So far, LO Base looks almost identical to MS Access, which I suppose is a good thing based on my needs right now.
Q1.) According to this gentleman, LO Base is not aptly named in that it is just a front-end application designed to interact with a database on the back-end.
Libreoffice Base Mariadb
Is this true?
Q2.) Is it true that if I choose the Firebird database that I won't need the JRE running on my Mac?
Q3.) How does HSQLDB compare to Firebird?
Q4.) Whether I choose HSQLDB or Firebird, where does the actual database, and database files, exist? (When I used MS Access long ago, your entire database was in one or maybe two files. By contrast, I believe large databases like Oracle have hundreds or thousands of files which make up the database.)
Okay, that's a good start I guess..