Libreoffice Base Mariadb

Posted onby admin

MariaDB Server: The open source relational database

Generate and populate databases with large volumes of realistic test data. SB Data Generator is a simple and powerful GUI tool for creating large volumes of realistic test data to populate selected tables or entire databases. Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

Webinar: AI in MariaDB with MindsDB

MindsDB is an AutoML framework that lets software engineers do machine learning, without having to go through the whole data science pipeline. Additionally, MindsDB has done a seamless integration with MariaDB, by making use of the Connect Storage Engine. …

MariaDB 10.5.10, 10.4.19, 10.3.29 and 10.2.38 now available

The MariaDB Foundation is pleased to announce the availability of MariaDB 10.5.10, MariaDB 10.4.19, MariaDB 10.3.29 and MariaDB 10.2.38, the latest stable releases in their respective series. …


MariaDB 10.6.0 now available

The MariaDB Foundation is pleased to announce the availability of MariaDB 10.6.0, the first alpha release in the new MariaDB 10.6 development series. …

Poll: Which MariaDB Server version do you mainly run in production?

Our second poll aims to get to know you better by learning which version of MariaDB Server you primarily use in production. This helps us shift our priorities according to your needs and establish goals that align better with the popularity of the versions. …

Google Summer of Code 2021

Good news, for you and for us: We have been approved for this year’s edition of Google Summer of Code!
What is Google Summer of Code? …

Point-in-Time Recovery for MongoDB on Kubernetes

By Percona, 2021-05-10

New Extensions in Percona Distribution for PostgreSQL, Updated Percona Kubernetes Operators: Release Roundup May 10, 2021

By Percona, 2021-05-10

War Stories and Learning From Others – Percona Live

By Percona, 2021-05-10

New User and LDAP Management in ClusterControl 1.8.2

By SeveralNines, 2021-05-10

Libreoffice Base Mariadb

Galera Streaming Replication Feature Deep Dive Video and Blog

By Galera Cluster, 2021-05-10

Webinar: AI in MariaDB with MindsDB

By MariaDB Foundation, 2021-05-10

LibreOffice Base
LibreOffice Base 7.1.2 (released in April 2021, running on Linux and GNOME with the default icon set)
Developer(s)The Document Foundation
Stable release
  • Community: 7.1.3 (6 May 2021; 3 days ago[1])
  • Enterprise:[2] 7.0.5 (12 March 2021; 58 days ago) [±]
Operating systemLinux, FreeBSD, Mac OS X and Microsoft Windows
LicenseMPLv2.0 (secondary license GPL, LGPLv3+ or Apache License 2.0)[3]

LibreOffice Base is a free and open-sourcerelational database management system that is part of the LibreOfficeoffice suite. LibreOffice Base was built off of a fork of and was first released as version on October 4, 2011.[4]

Similarly to the other packages in the LibreOffice suite, Base is supported across multiple platforms including Microsoft Windows, macOS, and Linux. Base is recognized for its cross-platform compatibility relative to Microsoft Access, which is developed exclusively for Windows.[5]


LibreOffice Base is designed to allow users to easily create, access, modify, and view databases and their data. This is done by providing users with a graphical user interface that allows users to work with four main tools: Tables, queries, forms, and reports.[6][7] Base includes software wizards to assist users with various aspects of the program.[8][9] LibreOffice Base requires a Java Runtime Environment (JRE) in order to create databases with forms, wizards, and more.[10]

Creating Table in Libreoffice Base

Base is able to work with both embedded and external database files. Embedded databases are stored as a single file using C++ based Firebird and Java-based HSQLDB as its storage engine. When connecting to external databases, Base acts as a graphical user interface front-end to facilitate interactions with various database systems including Microsoft Access databases (JET), ODBC/JDBC data sources, MySQL, MariaDB, and PostgreSQL.[7]

Base has been described as an unusual project in the niche of database management system software which tends toward proprietary software designed for enterprise users.[6] Proprietary database management software costs have been described as a reason for the use of Base in small businesses.[11]

Migration From HSQLDB to Firebird[edit]

Work was started in 2014 to transition the embedded storage engine from HSQLDB to the Firebird SQL back-end. Firebird has been included in LibreOffice as an experimental option since LibreOffice 4.2.[12][13]

Connect Libreoffice Base To Mariadb

In August 2018, The Document Foundation announced the release of LibreOffice version 6.1. If the experimental mode is used, the embedded Firebird engine support is fully available, and the old HSQLDB engine is deprecated—although still available—and replaced by Firebird as the default option.[14][15]

In February 2019, The Document Foundation released LibreOffice version 6.2. The embedded Firebird engine support was moved from experimental mode to operational and the Firebird Migration Assistant can create a backup copy of content as an XML document for the migration process.[16] In February 2020, embedded Firebird was moved back to experimental mode, taking effect in version 6.4.1.[17]


  1. ^'LibreOffice 7.1.3 Community available for download'. The Document Foundation. Retrieved 2021-05-06.
  2. ^
  3. ^'Licenses'. The Document Foundation. Retrieved 12 August 2018.
  4. ^'Index of /libreoffice/old'. The Document Foundation. Retrieved 13 August 2018.
  5. ^Klosowski, Thorin (15 August 2013). 'Battle of the Office Suites: Microsoft Office and LibreOffice Compared'. LifeHacker. Retrieved 13 August 2018.
  6. ^ abGaskin, James. 'LibreOffice 5 Review'. Laptopmag. Retrieved 13 August 2018.
  7. ^ abElena, Opris. 'LibreOffice Base Review'. Softpedia. Retrieved 13 August 2018.
  8. ^'Microsoft Access alternatives: are there any free applications that achieve the same result?'. 1&1. 6 November 2017. Retrieved 13 August 2018.
  9. ^Wallen, Jack. 'Creating Forms for Easy LibreOffice Database Entry on Linux'. Linux. Retrieved 13 August 2018.
  10. ^'on firefox and have loaded java 32 [closed] - Ask LibreOffice'. Retrieved 2021-03-16.
  11. ^Wallen, Jack (27 January 2012). 'DIY: Create easy to use databases with LibreOffice Base'. TechRepublic. Retrieved 13 August 2018.
  12. ^'LibreOffice 4.2 released with new SQL preview feature: Firebird SQL backend'. Firebird News. 30 January 2014. Retrieved 2 May 2015.
  13. ^'HSQLDB to be replaced by Firebird'. Archived from the original on 19 March 2015. Retrieved 2 May 2015.
  14. ^'The Document Foundation announces LibreOffice 6.1, a major release which shows the power of a large and diverse community of contributors'. The Document Foundation. LibreOffice. 8 August 2018. Retrieved 13 August 2018.
  15. ^'LibreOffice 6.1: Release Notes'. The Document Foundation's Wiki. Retrieved 26 August 2018.
  16. ^'ReleaseNotes/6.2'. The Document Foundation's Wiki. Retrieved 26 February 2019.
  17. ^'Set Firebird creation option experimental'. The Document Foundation. Retrieved 26 October 2020.

External links[edit]

Retrieved from ''