On Wed, 19 Nov 2003 13:47:51 -0600 "Andrew L. Gould" <[EMAIL PROTECTED]> wrote:
> On Wednesday 19 November 2003 10:39 am, Matthew Carpenter wrote: > > What is the key piece of MSOffice which is not readily available as > > Open Source? [snip] > > To say that a front-end for database administration or queries is a > replacement for MS Access is to say that you haven't used all of the > facets of MS Access: > [snip Access plug] All the above said, Access is a _toy_. If you need a database (of more than about 100 rows) you really need a SQL database like PostgreSQL. It does all you mentioned and more. It also supports multiple users (hundreds of simultaneous selects), supports transactions, foreign keys, outer joins, and is fast (particularly searches on indexed columns). It is also ACID. I'm putting together yet another database and front end for a gov't agency here. They'll use a web browser. I'm still writing the Perl script to provide the various queries and inserts/updates. But it will get thousands of entries per year. If you want to see a _good_ web -> postgresql app, try SQL-Ledger (http://www.sql-ledger.com/). Besides, OO supports ODBC queries of PostgreSQL. Poorly documented, yes. But I have done it (once, and maybe never again; psql is a _lot_ easier, especially if views are properly constructed.) Ciao, David A. Bandel -- Focus on the dream, not the competition. Nemesis Racing Team motto GPG key autoresponder: mailto:[EMAIL PROTECTED]
pgp00000.pgp
Description: PGP signature
_______________________________________________ Linux-users mailing list [EMAIL PROTECTED] Unsubscribe/Suspend/Etc -> http://smtp.linux-sxs.org/mailman/listinfo/linux-users
