New News Entry

A new entry has been added to the news database.

Database Admin: http://www.postgresql.org/admin/edit_news.php?199

Submitted by: justin(at)postgresql(dot)org
Headline: New release of the PostgreSQL driver for OpenOffice.org
Summary:

Joerg Budischewski has released the next version (0.6.0) of the native PostgreSQL driver for OpenOffice.org for windows and linux x86.

Story:

Joerg Budischewski has released version 0.6.0 of the native PostgreSQL driver for OpenOffice.org (see <a href=\"http://www.openoffice.org\">http://www.openoffice.org</a>) for windows and linux x86.

The driver\'s homepage can be found here:

<a href=\"http://dba.openoffice.org/drivers/postgresql/index.html\">http://dba.openoffice.org/drivers/postgresql/index.html</a>

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:
<ul>
<li>tables can now be dragged into a calc sheet</li>
<li>structural changes to tables</li>
<li>better serial data type support</li>
<li>tables and views can now be distinguished via UI</li>
<li>relations between tables can now be viewed and edited</li>
<li>date, time and timestamp support</li>
</ul>

Have fun,

Joerg