OpenOffice Base

free software

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.

OpenOffice Base
Developer(s)StarOffice
StarDivision (1984–1999)
OpenOffice.org
Sun Microsystems (1999–2010)
Oracle Corporation (2010–2011)
Apache OpenOffice
Apache Software Foundation (2011—)
Stable release
3.4.1 / August 24, 2012; 11 years ago (2012-08-24)
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.

Related pages change

Notes and references change

  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 change