Re: Best database for web backend on Linux?

> In article <7076ob$suf$1@nnrp1.dejanews.com>, oliver.willandsen@sg.cec.be writes: > >In article <i5AV1.200$Rj4.1148457@news.rdc1.sfba.home.com>, > > "Yun Ye" <yye@home.com> wrote: > >> 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 > >> > >> > > > >Both Sybase and Oracle have transaction support and row-level locking ( > >Sybase only now ), Row level locking was introduced in ASE 11.9. The Linux release is only 11.0.3, so it does not include row-level locking. -- Bret Halford Imagine my disappointment Sybase Technical Support in learning the true nature 3665 Discovery Drive of rec.humor.oracle... Boulder, CO 80303