# LibreOffice Base

> Open source database application

**Wikidata**: [Q12810618](https://www.wikidata.org/wiki/Q12810618)  
**Wikipedia**: [English](https://en.wikipedia.org/wiki/LibreOffice_Base)  
**Source**: https://4ort.xyz/entity/libreoffice-base

## Summary

LibreOffice Base is a database management application. It was established on January 25, 2011.LibreOffice Base is part of the LibreOffice productivity suite. It provides tools for creating and managing databases, including forms, reports, queries, and tables.

## Summary
LibreOffice Base is an open-source database management application that is part of the LibreOffice office suite. It provides users with tools to create and manage relational databases, forms, and reports, supporting multiple operating systems including Windows, macOS, Linux, and Android.

## Key Facts
- LibreOffice Base was first released on January 25, 2011, as part of the LibreOffice suite
- It is licensed under the GNU Lesser General Public License, Mozilla Public License 2.0, and Apache Software License 2.0
- The application is developed by The Document Foundation and is written in C++ and Java
- It supports cross-platform operation on Windows, macOS, Linux, BSD, Android, and Haiku operating systems
- The latest stable version as of July 2022 is 7.3.5, with 7.2.7 being the long-term support release
- LibreOffice Base uses the OpenDocument Database file format for both reading and writing database files
- It is classified as both free software and a database management system

## FAQs
### Q: What is LibreOffice Base used for?
A: LibreOffice Base is used for creating and managing relational databases, designing forms and reports, and providing a user interface for database operations. It can connect to various database engines including MySQL, PostgreSQL, and SQLite.

### Q: Is LibreOffice Base free to use?
A: Yes, LibreOffice Base is completely free to use as it is open-source software distributed under multiple free software licenses including the GNU LGPL, MPL 2.0, and Apache 2.0.

### Q: What file formats does LibreOffice Base support?
A: LibreOffice Base primarily uses the OpenDocument Database file format (.odb) for storing database files, which is an open standard format that can be read and written by the application.

## Why It Matters
LibreOffice Base represents a significant contribution to the open-source software ecosystem by providing a free, cross-platform database management solution that rivals commercial alternatives like Microsoft Access. It democratizes access to database technology by removing cost barriers and platform limitations, making it accessible to individuals, educational institutions, and organizations with limited budgets. The application plays a crucial role in the LibreOffice suite by enabling users to create sophisticated data-driven applications without requiring extensive programming knowledge. Its support for multiple database engines and open standards ensures data portability and long-term accessibility, addressing concerns about vendor lock-in that plague proprietary solutions. By being part of the broader LibreOffice project, Base benefits from continuous development and community support, ensuring its relevance in an increasingly data-centric world where the ability to organize, analyze, and report on information is essential for both personal and professional tasks.

## Notable For
- Being a completely free alternative to Microsoft Access with comparable functionality
- Supporting multiple database engines including MySQL, PostgreSQL, and SQLite through native and ODBC/JDBC connections
- Offering a built-in database engine (HSQLDB) for creating standalone database applications without external dependencies
- Providing a comprehensive form designer with wizards that simplify database application creation for non-technical users
- Maintaining cross-platform compatibility across major operating systems while remaining entirely free and open-source

## Body
### Technical Architecture
LibreOffice Base is built using C++ as the core language with Java integration for database connectivity and certain features. The application leverages the LibreOffice framework, which provides the underlying document handling and user interface components. This architecture allows Base to integrate seamlessly with other LibreOffice applications while maintaining its specialized database functionality.

### Database Engine Support
The application supports multiple database backends through various connection methods. It includes HSQLDB as a built-in engine for creating self-contained database files, making it possible to distribute complete database applications without requiring users to install separate database software. For more demanding applications, Base can connect to external database servers using JDBC or ODBC drivers, supporting popular systems like MySQL, PostgreSQL, Oracle, and Microsoft SQL Server.

### Form and Report Design
Base includes a visual form designer that allows users to create data entry forms and reports through drag-and-drop interfaces. The designer provides access to form controls, subforms, and various data-bound widgets that can be configured to interact with database tables and queries. Report generation capabilities include grouping, sorting, and formatting options that enable the creation of professional-quality printed outputs.

### Query Builder and SQL Support
Users can create database queries through a graphical query builder or by writing SQL directly. The query builder provides a visual interface for selecting tables, defining relationships, and specifying selection criteria, making database querying accessible to users without SQL expertise. For advanced users, Base includes a full SQL editor with syntax highlighting and query execution capabilities.

### Migration and Compatibility
LibreOffice Base can import data from various sources including Microsoft Access databases, allowing users to migrate from proprietary solutions to the open-source alternative. The application maintains compatibility with standard database formats and provides tools for exporting data in multiple formats, ensuring that users can work with data from diverse sources and share results with others regardless of their software choices.

## Schema Markup
```json
{
  "@context": "https://schema.org",
  "@type": "SoftwareApplication",
  "name": "LibreOffice Base",
  "description": "Open source database application that is part of the LibreOffice office suite",
  "url": "https://www.libreoffice.org/discover/base/",
  "operatingSystem": [
    "Windows",
    "MacOS",
    "Linux",
    "Android",
    "BSD",
    "Haiku"
  ],
  "applicationCategory": "DatabaseApplication",
  "creator": {
    "@type": "Organization",
    "name": "The Document Foundation"
  },
  "license": [
    "GNU Lesser General Public License",
    "Mozilla Public License 2.0",
    "Apache Software License 2.0"
  ],
  "programmingLanguage": [
    "C++",
    "Java"
  ],
  "releaseDate": "2011-01-25",
  "sameAs": [
    "https://en.wikipedia.org/wiki/LibreOffice_Base",
    "https://www.wikidata.org/wiki/Q10135"
  ]
}

## References

1. [Source](https://www.libreoffice.org/download/license/)
2. [Source](https://blog.documentfoundation.org/blog/2020/04/30/libreoffice-636/)
3. [LibreOffice 6.4.4 available for download. 2020](https://blog.documentfoundation.org/blog/2020/05/21/libreoffice-644/)
4. [Source](https://blog.documentfoundation.org/blog/2022/03/10/announcement-of-libreoffice-7-2-6-community/)
5. [Source](https://blog.documentfoundation.org/blog/2022/03/31/libreoffice-732-community/)
6. [Source](https://blog.documentfoundation.org/blog/2022/05/05/libreoffice-733-community/)
7. [Source](https://blog.documentfoundation.org/blog/2022/05/12/libreoffice-727-community/)
8. [Source](https://blog.documentfoundation.org/blog/2022/06/09/libreoffice-7-3-4-community/)
9. [Source](https://blog.documentfoundation.org/blog/2022/07/21/libreoffice-7-3-5-community/)