Embedded databases are stored as a single file using C++ based Firebird and Java-based HSQLDB as its storage engine.

īase is able to work with both embedded and external database files. LibreOffice Base requires Java in order to create databases with forms, wizards, and more. Base includes software wizards to assist users with various aspects of the program. 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. LibreOffice Base is designed to allow users to easily create, access, modify, and view databases and their data. Base is recognized for its cross-platform compatibility relative to Microsoft Access, which is developed exclusively for Windows. Similarly to the other packages in the LibreOffice suite, Base is supported across multiple platforms including Microsoft Windows, macOS, and Linux. LibreOffice Base was built off of a fork of and was first released as version 3.4.0.1 on October 4, 2011. LibreOffice Base is a free and open-source database development and administration tool for relational database management systems that is part of the LibreOffice office suite.

MPLv2.0 (secondary license GPL, LGPLv3+ or Apache License 2.0) Linux, FreeBSD, Mac OS X and Microsoft Windows This is because the LibreOffice product is designed to primarily work with a variety of SQL databases.įor creating new relational databases, users can choose HSQLDB Embedded, and if experimental features are activated, users can choose to create databases with Firebird. The advantage it has over Access is that users can connect to and edit the data in much larger databases with it. It, however, does not have the numerous features and capability that its Microsoft counterpart has, such as the ability to directly include images and themes to the data tables. Many consider it to be a direct competitor to Microsoft Access because it is used to create relational databases for personal and small group purposes. Like the other applications in the suite, it works equally well on Windows, Mac OS, and Linux distros. LibreOffice Base is a front-end database application that has been part of the LibreOffice suite for more than two decades.

Libreoffice base firebird