LibreOffice Base

Submitted by admin on Mon, 09/16/2019 - 19:38

How to using LibreOffice Base with MySQL as front-end database on Windows

LibreOffice Base is similar to Microsoft Access but it is free (open source). LibreOffice Base actually not a database by it self - the default database for LibreOffice base is HSQLDB. LibreOffice Base also can used front-end database like MySQL, Access Database etc.

If we use LibreOffice default base HSQLDB, only one person can using the database at one time. So, if we want to make a multiple user - we can use MySQL for example as a front-end.


Note:
LibreOffice Base actually one of the products LibreOffice. There are another products in LibreOffice such as Writer Document, Calc Spreadsheet, Impress Presentation, Draw Drawing, Math Formula. But in this article, we only discuss about the LibreOffice Base.


Steps:-

  1. Download LibreOfficehttps://www.libreoffice.org/download/download/
  2. Install LibreOffice base as usual
  3. Download MySQL (MySQL Community Server): https://dev.mysql.com/downloads/mysql/
  4. Install MySQL as usual: See this youtube as guideline how to isntall: https://www.youtube.com/watch?v=BdF7HUmuU-s&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=80

Choosing a Setup Type 

Setup Type Description

Developer Default

Install all products need for MySQL development purpose

Installs the MySQL Server and the tools required for MySQL application development. This is useful if you intend to develop applications for an existing server.

This Setup Type includes:

* MySQL Server

* MySQL Shell
The new MySQL client application to manage MySQL Servers and InnoDB cluster instances.

* MySQL Router
High availability router daemon for InnoDB cluster setups to be installed on application nodes.

* MySQL Workbench
The GUI application to develop for and manage the server.

* MySQL for Excel
Excel plug-in to easily access and manipulate MySQL data.

* MySQL for Visual Studio
To work with the MySQL Server from VS.

* MySQL Connectors
Connector/Net, Java, C/C++, OBDC and others.

* Examples and tutorials
To help you get started with your development.

* Documentation
Allows you to read the documentation offline.

Server only

Install only the MySQL Server product

Installs only the MySQL Server. This type should be used where you want to deploy a MySQL Server, but will not be developing MySQL applications.

Client Only

Install only the MySQL Client produts, without a server

Installs the tools required for MySQL application development, but does not include the MySQL Server itself. This is useful if you intend to develop applications for an existing server.

This Setup Type includes:

* MySQL Shell
The new MySQL client application to manage MySQL Servers and InnoDB cluster instances.

* MySQL Router
High availability router daemon for InnoDB cluster setups to be installed on application nodes.

* MySQL Workbench
The GUI application to develop for and manage the server.

* MySQL Visual Studio Plugin
To work with the MySQL Server from VS.

* MySQL Connectors
Connector/Net, Java, C/C++, OBDC and others.

* Examples and tutorials
To help you get started with your development.

* Documentation
Allows you to read the documentation offline.

Full

Install all included MySQL products and features

Installs all of the products available in this catalog including MySQL Server, MySQL Shell, MySQL Router, MySQL Workbench, MySQL Connectors, documentation, samples and examples and much more.

Custom

Manually select the products that should be installed on the system

Installs all of the products available in this catalog including MySQL Server, MySQL Shell, MySQL Router, MySQL Workbench, MySQL Connectors, documentation, samples and examples and much more.

To connect MySQL server, the are 3 type:

  1. Connect with ODBC
  2. Connect with JDBC
  3. Direct

To connect with ODBC - we need JRE. The problem is, (JRE) Version 8 Update 201 was the last free JRE. Starting from JRE Version 8 Update 211 commercial users will be required to pay for its usage to Oracle. 

To solve this problem (no need to pay - is by using free open source alternative). So we can use the OpenJDK. Download here: https://adoptopenjdk.net/. See this article: http://www.bluechip-india.com/no-brainer-alternative-to-oracle-java-runtime-jre/ and also see this youtube for installation: https://youtu.be/WewvpxrjXro

How to configure java on windoew 10

 

To connect with JDBC - we need Connector J. Download here (Community version): https://dev.mysql.com/downloads/connector/j/. See this youtube for setting: https://youtu.be/aP5wXmnWxGE