James,
> Maybe a PostgreSQL-Lite would be a better idea. One that condenses the main
> code down to something easy, that a desktop user could use, but maintain the
> strength of the core code. I suppose that means creating another project.
Personally, I think it's a redundant idea. There are a couple dozen
"lightweight" RDBMSs available off Sourceforge. There is only one
"Heavy-duty" database: Us.
> Others are considering MySQL.
> http://dba.openoffice.org/proposals/MySQL_OOo.html
Let me nip this in the bud: That proposal was shot down almost immediately,
mostly due to MySQL's poor adherence to the SQL standard and licensing
problems. I also shot down PostgreSQL as a possibility for inclusion with
OpenOffice.org, since Postgres is quite firmly a *server* database, and 70%
of OpenOffice.org installs are on Windows 95/98.
Currently, we are leaning toward HSQLDB as our included database. However,
you can help us decide: join the DBA.openoffice.org project
(http://dba.openoffice.org/).
Something we could really, really use for OpenOffice.org is "native" (SBDC)
drivers for PostgreSQL. Currently, we have to use UnixODBC or MS ODBC, which
brings all sorts of problems with it. Can anyone help with a driver?
Once we get a native driver, OpenOffice.org will be available as an MS
Access-style tool for simple PostgreSQL database management. This should
increase adoption of Postgres somewhat.
-Josh BerkusOpenOffice.org