Software:LibreOffice Base

From HandWiki
LibreOffice Base
LibreOffice 7.5 Base Icon.png
LibreOffice 7.2.4.1 Base screenshot.png
LibreOffice Base 7.2.4 (released in December 2021, running on Linux and KDE Plasma 5 with the Breeze icon set)
Developer(s)The Document Foundation
Stable release
Operating systemLinux, FreeBSD, Mac OS X and Microsoft Windows
TypeRDBMS
LicenseMPLv2.0 (secondary license GPL, LGPLv3+ or Apache License 2.0)[2]
Websitewww.libreoffice.org/discover/base/

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. LibreOffice Base was built off of a fork of OpenOffice.org and was first released as version 3.4.0.1 on October 4, 2011.[3]

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.[4]

Features

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.[5][6] Base includes software wizards to assist users with various aspects of the program.[7][8] LibreOffice Base requires Java in order to create databases with forms, wizards, and more.[9]

Table Data View 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 Access Database Engine (ACE/JET), ODBC/JDBC data sources, MySQL, MariaDB, and PostgreSQL.[6]

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.[5] Proprietary database management software costs have been described as a reason for the use of Base in small businesses.[10]

Migration From HSQLDB to Firebird

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.[11][12]

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.[13][14]

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.[15] In February 2020, embedded Firebird was moved back to experimental mode, taking effect in version 6.4.1.[16]

References

  1. 1.0 1.1 https://www.libreoffice.org/download/download/
  2. "Licenses". The Document Foundation. https://www.libreoffice.org/download/license/. 
  3. "Index of /libreoffice/old". The Document Foundation. http://downloadarchive.documentfoundation.org/libreoffice/old/?C=M;O=A. 
  4. Klosowski, Thorin (15 August 2013). "Battle of the Office Suites: Microsoft Office and LibreOffice Compared". LifeHacker. https://lifehacker.com/battle-of-the-office-suites-microsoft-office-and-libre-1147940828. 
  5. 5.0 5.1 Gaskin, James (5 August 2016). "LibreOffice 5 Review". https://www.laptopmag.com/reviews/software/libreoffice. 
  6. 6.0 6.1 Elena, Opris (17 January 2014). "LibreOffice Base Review". http://www.softpedia.com/reviews/windows/LibreOffice-Review-418139.shtml. 
  7. "Microsoft Access alternatives: are there any free applications that achieve the same result?". 1&1. 6 November 2017. https://www.1and1.com/digitalguide/server/tools/microsoft-access-alternatives-at-a-glance/. 
  8. Wallen, Jack (20 February 2015). "Creating Forms for Easy LibreOffice Database Entry on Linux". https://www.linux.com/learn/creating-forms-easy-libreoffice-database-entry-linux. 
  9. "on firefox and have loaded java 32 [closed - Ask LibreOffice"]. 17 November 2017. https://ask.libreoffice.org/en/question/138238/on-firefox-and-have-loaded-java-32/. 
  10. Wallen, Jack (27 January 2012). "DIY: Create easy to use databases with LibreOffice Base". TechRepublic. https://www.techrepublic.com/blog/diy-it-guy/diy-create-easy-to-use-databases-with-libreoffice-base/. 
  11. "LibreOffice 4.2 released with new SQL preview feature: Firebird SQL backend". Firebird News. 30 January 2014. https://www.firebirdnews.org/libreoffice-4-2-released-with-new-preview-feature-firebird-sql-backend/. 
  12. "HSQLDB to be replaced by Firebird". LibreOfficeForum.org. http://en.libreofficeforum.org/node/6062. 
  13. "The Document Foundation announces LibreOffice 6.1, a major release which shows the power of a large and diverse community of contributors". LibreOffice. The Document Foundation. 8 August 2018. https://blog.documentfoundation.org/blog/2018/08/08/libreoffice-6-1/. 
  14. "LibreOffice 6.1: Release Notes". The Document Foundation's Wiki. https://wiki.documentfoundation.org/ReleaseNotes/6.1. 
  15. "ReleaseNotes/6.2". The Document Foundation's Wiki. https://wiki.documentfoundation.org/ReleaseNotes/6.2. 
  16. "Set Firebird creation option experimental". The Document Foundation. https://cgit.freedesktop.org/libreoffice/core/commit/?id=dc3c6e64650f0347648598dae0fa67c296ad36f5. 

External links