Updated PostgreSQL driver for OpenOffice.org Released

Posted on 2004-06-15

Joerg Budischewski has released version 0.6.0 of the native PostgreSQL driver for OpenOffice.org for Windows and Linux x86.

The driver's homepage can be found here:

http://dba.openoffice.org/drivers/postgresql/index.html

The driver allows a user to directly use the PostgreSQL database from OpenOffice.org via libpq without any other wrapper layer such as ODBC or JDBC. After installation, you can configure a PostgreSQL database via the Tools/Data Sources dialog and can then view data via the <F4> beamer window.

The current version 0.6.0 contains some major improvements compared to 0.5.0, but it can still be considered to be in a alpha state. About 80% of the features a professional driver should have are implemented now. Beside the missing features, there are some known bugs. The main purpose of this version is to collect input from the community in an early development stage. Treat this driver with care, it is not thouroughly tested yet and might (in the worst case) destroy your data. It should not be used in a production environment (or it must have been thouroughly tested for its concrete purpose before).

The driver is aimed at the 1.1 OpenOffice.org versions, it should not work with the OpenOffice.org 1.0.x series. It should work with OpenOffice.org 2.0 development versions, but this has not been tested yet.

Major improvements since 0.5.0 version include:

  • tables can now be dragged into a calc sheet
  • structural changes to tables
  • better serial data type support
  • tables and views can now be distinguished via UI
  • relations between tables can now be viewed and edited
  • date, time and timestamp support

Have fun,

Joerg

This post has been migrated from a previous version of the PostgreSQL website. We apologise for any formatting issues caused by the migration.