OpenOffice Base

OpenOffice Base is the database module released with OpenOffice version 2.0 and later. Currently it is based on the HSQLDB database engine written in Java.

OOoBase.svg
Oo base 3.4.1.png
OpenOffice Base 3.4.1
Developer(s)StarOffice
StarDivision (1984–1999)
OpenOffice.org
Sun Microsystems (1999–2010)
Oracle Corporation (2010–2011)
Apache OpenOffice
Apache Software Foundation (2011—)
Stable release3.4.1 / August 24, 2012; 12 years ago (2012-08-24)
Development statusActive
Operating systemMicrosoft Windows, Mac OS X, Linux
PlatformJava
TypeDatabase
LicenseLGPL version 3[1] (OpenOffice.org 2 Beta 2 and earlier are dual-licensed under the SISSL and LGPL)[2]
Apache License 2.0 (Apache OpenOffice 3.4 and later)[3]
Websitewww.openoffice.org

The HSQLDB developers have suggested only 76% of the target has been met in the 1.8.0 release,[4] which is the version that was integrated (merged) with OOo 2.0. They have been asking for contributions[5] to complete all the feature targets, since the inner database engine is an independent project with no outside funding.

OpenOffice users, however, can choose to connect to an external full-featured SQL database such as MySQL, PostgreSQL and even Oracle through ODBC or JDBC drivers. OpenOffice Base can then act as a GUI frontend for SQL views, table design and query. In addition, OpenOffice has its own Form wizard to create dialog windows for form filling and updates.

Starting with version 2.3, Base will offer report generation based on Pentaho software.[6]

Released under the terms of the Apache License, Base is free software.

OpenOffice Base Media

Related pages

Notes and references

  1. "LGPL v3". Oracle Corporation. Retrieved 22 April 2009.
  2. "License Simplification FAQ". Oracle Corporation. Retrieved 27 February 2010.
  3. "Licenses & Copyrights". Apache Software Foundation. Retrieved 2 January 2012.
  4. "HSQL page about integration with OpenOffice.org".
  5. "HSQL appeal for funding for OpenOffice.org integration work". Archived from the original on 2008-04-15. Retrieved 2008-08-26.
  6. "Report Designer will extend the Database Application".

Other websites