(Difference between revisions)
|(One intermediate revision by one user not shown)|
|−|OpenOffice.org Base is the database module initially released with OpenOffice.org version 2.0. Currently it is based on the HSQLDB database engine written in Java. Note that another database engine, SQLite, had been considered but the OpenOffice. org team decided to go with HSQLDB after evaluating the features, connectivity and embed quality of both database engines. |+|
Base is the database the . , the . to with , and of database .
| || |
|−|The HSQLDB developers have suggested only 76% of the target has been met in the 1. 8.0 release, which is the version that was integrated with OOo 2.0. They have been appealing for contributions to fulfill all the feature targets, since the core database engine itself is an independent project with no external funding. |+|
|−|OpenOffice.org users, however, can choose to connect to external full-featured SQL database such as MySQL, PostgreSQL and even Oracle through ODBC or JDBC drivers. OpenOffice.org Base can hence act as a GUI frontend for SQL views, table design and query. In addition, OpenOffice.org 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. |+|
|−|Released under the terms of the GNU Lesser General Public Licence, Base is free software. |+|
Latest revision as of 12:28, 22 May 2011
Base is the database front-end of the LibreOffice suite. With Base, you can seamlessly integrate your existing database structures into the other components of LibreOffice, or create an interface to use and administer your data as a stand-alone application. You can use imported and linked tables and queries from MySQL, PostgreSQL or Microsoft Access and many other data sources, or design your own with Base, to build powerful front-ends with sophisticated forms, reports and views. Support is built-in or easily addable for a very wide range of database products, notably the standardly-provided HSQL, MySQL, Adabas D, Microsoft Access and PostgreSQL.