[plug] [CC of Letter to Editor] OpenOffice.org does do databases

Leon Brooks leon at brooks.fdns.net
Tue Aug 6 11:31:36 WST 2002


[ re: http://www.latimes.com/business/la-fi-techgear5aug05.story?null ]

Matthew Fordahl's AP story on OpenOffice.org that you copied has a copyright 
problem, and a technical inaccuracy.

The office suite is called OpenOffice.org, plain OpenOffice is owned by 
somebody else who might cut crook at your misrepresentation of their product. 
(-:

OpenOffice.org does indeed have a database interface. PostgreSQL 
(http://www.postgresql.org/) is an example of a free, Open Source database 
which also runs on Windows (and practically everything else too), and with 
which OpenOffice.org will do instant point-and-click robust data management.

Should you require it, PostgreSQL will scale up so that the toy demo database 
you threw together with OpenOffice.org can be transferred to a real Internet 
or Intranet host, even stretching as far as cluster-sized installations with 
features like replication. For free.

PostgreSQL is in a way a poster child for Open Source. I had it running on a 
baby gateway machine with only 12MB or RAM (yes, twelve, that's no typoe) and 
a 250MB hard disk until recently (now it's a P166 with 64MB and 6GB), and at 
the other end of the scale places like observatories use it for indexing and 
processing squillions of large, irreplaceable images. It sticks closely to 
the SQL standards, and was the first SQL-compliant database in the world to 
offer Object Oriented features. Unlike Oracle and SQL Server, it doesn't cost 
you an arm and a leg, doesn't lock you in to secret technologies, and doesn't 
require a monster server to deliver reliable performance.

OpenOffice.org does require significant resources, I wouldn't run it in 
anything less than 64MB of RAM. On the other hand, it can load and recover 
Word and Excel files that crash MS-Office, is better at many things like HTML 
tables, and it is immune to the common macro viruses. Definitely worth a 
look.

Cheers; Leon Brooks
Perth, Western Australia

-- 
http://www.cyberknights.com.au/  Modern tools, traditional dedication
http://slpwa.linux.org.au/       Member, Linux Professionals West Aus
http://conf.linux.org.au/        THE Australian Linux Technical Conf:
                                 22-25 January 2003, Perth: be there!



More information about the plug mailing list