Re: Best database for web backend on Linux?

ORACLE is a good choice. There are many apps that use ORACLE as the back-end. ORACLE has very good performance, lot's of tweaking ability, lot's of flexibility in configuration, etc., and you can certainly build a career off of ORACLE knowledge. The quality of the products leave a bit to be desired in many cases, though.

I'm not extremely familiar with later versions of Sybase, but before choosing Sybase over ORACLE, I would suggest that you consider Informix. Companies that use Informix tend to swear by it, and wouldn't consider any other database engine. Informix has had features for years that are only starting to show up in ORACLE8.0 and ORACLE8.1, and features that Sybase, DB2, etc., will probably never have. However, there aren't a lot of packaged applications that are targeted for Informix as the back-end.

Good luck,
Dave

Yun Ye wrote in message ...
>Now that we got all sorts of commercial and free databases available for
>Linux, I don't know what to use. I currently use PostgreSQL, but its SQL
>implementation is quite incomplete (no foreign key, alter table add
>constraint, etc.), and there's no row-level locking. I want to try
>something else but don't have much experience with other databases. Can
>someone summarize the pros and cons of each database as a web backend? I'm
>considering PostgreSQL, MySQL, Solid, Oracle, Sybase, and Informix. The
>features I'm most interested in are transaction support, general SQL
>support, good Perl DBI/DBD implementation, row-level locking, online
 backup,
>max size of VARCHAR, and persistent connection. Oh, also price. (I know
>Sybase for Linux is free, but what's the price for Oracle as a web
 backend?)
>
>Thanks,
>Yun
>
>
Received on Fri Oct 16 1998 - 00:00:00 CDT