Libreoffice Base Mariadb

Libreoffice base mariadb
  1. Connect Libreoffice Base To Mariadb
  2. Libreoffice Base Mariadb
Been a few weeks since my last posts. Am out-of-state taking care of business.
While on my trip, I have decided to try LibreOffice - since it is more modern with apparently better support.
  1. 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.
  2. 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).

Ookla speed

I have been watching videos from TheFrugalComputerGuy.

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.
Questions:
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?Libreoffice Base Mariadb
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..