What Is LibreOffice Base and Supported Databases

LibreOffice Base is a fully featured, open-source desktop database management tool that allows users to create, configure, and manage databases through an intuitive graphical user interface. This article explains the core functionality of LibreOffice Base, how it works as both a standalone database and a frontend interface, and the embedded and external relational database engines it supports.

What is LibreOffice Base?

LibreOffice Base is the database component of the free and open-source LibreOffice productivity suite. Similar to Microsoft Access, Base is designed to fulfill a broad range of database requirements, from simple personal asset tracking to enterprise-level data interfaces.

Base allows users to: * Create and modify tables: Define schema structures, field types, primary keys, and relationships. * Design queries: Retrieve and filter data using visual design tools or direct SQL commands. * Build user-friendly forms: Create graphical input interfaces for entering and editing data. * Generate reports: Produce structured, printable reports using the integrated Report Builder.

Base operates in two primary modes: as an all-in-one embedded database system where data is saved within a single .odb file, and as a frontend client to connect to external multi-user database servers.

Embedded Relational Database Engines

For standalone desktop use, LibreOffice Base includes embedded database engines that do not require an external server setup:

• Firebird SQL: The default embedded relational engine in modern versions of LibreOffice. Firebird provides strong SQL standards compliance, high performance, and ACID transaction support without requiring a Java Runtime Environment (JRE).
• HSQLDB: A Java-based relational database engine that served as the original default embedded engine for Base. It is still supported for backward compatibility with older database files.

Supported External Database Engines

LibreOffice Base can act as a frontend interface for virtually any external Relational Database Management System (RDBMS). It interfaces with external servers using native connectors, direct drivers, or standard communication layers:

• MySQL and MariaDB: Supported through dedicated native C++ connectors, standard JDBC, or ODBC drivers.
• PostgreSQL: Supported via a direct native SDBC driver, JDBC, or ODBC.
• Microsoft SQL Server: Supported via standard ODBC or JDBC connections.
• Microsoft Access (MDB/ACCDB): Supported for reading and importing data via native access drivers or ODBC.
• Oracle Database: Accessible via JDBC or ODBC connections.
• SQLite: Supported through third-party ODBC or JDBC drivers.
• dBASE: Supported natively for legacy tabular data files.

Standard Connection Interfaces

To achieve broad interoperability with diverse database engines, LibreOffice Base supports standard database connectivity protocols:

• ODBC (Open Database Connectivity): A platform-independent protocol allowing Base to connect to any database with an installed ODBC driver.
• JDBC (Java Database Connectivity): A Java-based standard that allows Base to communicate with any relational database engine providing a JDBC driver.
• Flat-File and Address Book Sources: In addition to relational SQL servers, Base can read data from spreadsheets (Calc), CSV/text files, and system address books (such as Thunderbird, LDAP, or macOS Address Book).