Thread: Anyone want to get involved in writing the the driver to connect Star/OpenOffice and PostgreSQL?

Hi guys,

Have been discussing what it would take to write an "SDBC" driver for 
connecting StarOffice/OpenOffice to PostgreSQL with Frank Schönheit, a 
senior member of the Sun StarOffice/OpenOffice DBA team, and a few 
senior members of the OpenOffice project.

SDBC is based largely on ODBC, so it might be more a matter of porting 
the existing ODBC stuff rather than a complete re-write.  Frank reckons 
it would take about 2 man weeks of total effort if needed to be written 
from scratch, so it's probably not going to be too hard for an 
experienced C++ & PostgreSQL coder.

Would anyone be interested in getting involved in doing this?  If 
anyone's up for it, the Sun StarOffice/OpenOffice DBA team in Hamburg 
Germany will be available for support etc.

Getting an SDBC driver written to connect Star/OpenOffice and PostgreSQL 
is very good step towards integrating PostgreSQL support further into 
Star/OpenOffice.

:-)

Regards and best wishes,

Justin Clift

-- 
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi

On Wed, Jan 15, 2003 at 01:20:45PM +1030, Justin Clift wrote:
> 
> Have been discussing what it would take to write an "SDBC" driver for 
> connecting StarOffice/OpenOffice to PostgreSQL with Frank Schönheit, a 
> senior member of the Sun StarOffice/OpenOffice DBA team, and a few 
> senior members of the OpenOffice project.

I think something like this is already being done based on libpqxx.
See http://gborg.postgresql.org/project/libpqxx/bugs/bugupdate.php?403
for a feature request related to this work.


Jeroen

Jeroen T. Vermeulen wrote:
> On Wed, Jan 15, 2003 at 01:20:45PM +1030, Justin Clift wrote:
> 
>>Have been discussing what it would take to write an "SDBC" driver for 
>>connecting StarOffice/OpenOffice to PostgreSQL with Frank Schönheit, a 
>>senior member of the Sun StarOffice/OpenOffice DBA team, and a few 
>>senior members of the OpenOffice project.
> 
> I think something like this is already being done based on libpqxx.
> See http://gborg.postgresql.org/project/libpqxx/bugs/bugupdate.php?403
> for a feature request related to this work.

Thanks Jeroen, it's good news.

That's a bug filed by Peter Novodvorsky, but haven't seen him using that 
email address before.  He's a pretty decent guy that started writing a 
PostgreSQL SDBC driver for OpenOffice many months ago, but seemed to 
have stopped and dropped out of sight.

Looks like he might still be working on it.

Will ask him, see how far he's gotten, how much more is needed, and so 
forth.

:-)

Regards and best wishes,

Justin Clift


> Jeroen
> 


-- 
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi