On Thu, 6 Apr 2000, brianb wrote:
..
> PostgreSQL is a full featured RDBMS that supports transactions, subselects,
> views and (coming soon) outer joins. It's much closer to fulfulling the
> ACID requirements than MySQL is, but it's not quite there yet either (it's
> missing the C), as of 6.5.*.
consistency? I though PG had multiversioning?
In all honesty, if I were to choose.. I'd use PG if I really needed
transactions. But another feature you'll really want if you're using a MS
Access97 frontend is constraints (for implementing entity relationships).
I dont know if PG supports it.
With the costing of Oracle Workgroup Server nowadays, I'd recommend you
buy it if your data is worth anything (e.g. company records, etc). You can
come in under 30K (pesos) for a 5-seat license. Thats cheaper than MS SQL
7.0 and I'd put my money on Oracle..
Note that if you use Oracle on the web.. the licensing fees are absolutely
horrendous (something like 42K USD for a single-processor, unlimited user
license). Oracle considers a web-connected Oracle database to be unlimited
user even if you use a multiplexer to limit the number of direct
connections to Oracle (e.g. mod_fcgi or a small number of mod_perl-enabled
httpd's).
So in short: for intranet, Oracle is a good buy (whats 30K pesos if your
company depends on your data? thats just one cheap clone PC) but for
internet... look elsewhere! (Sybase 11.9.2 is about 4K USD for unlimited
user, single processor, which is 1/10th the price of Oracle).
---------------------------------------------------------------------
Orlando Andico <[EMAIL PROTECTED]> +63 (2) 937-2293
Mosaic Communications, Inc. +63 (917) 531-5893
Any sufficiently perverted technology is indistinguishable from Perl.
-
Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
