Re: Best database for web backend on Linux?

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 ), Perl implementations exist for both - SybasePerl and OraPerl, max size of varchar is bigger for Oracle, both ( as development editions ) are free - Sybase will remain free, but without any support from Sybase, Oracle as a deployment database will cost something similar to the product on other platforms. Regards -- Oliver Willandsen European Commission http://europa.eu.int All comments represent my own opinion and may not in any circumstance be regarded as stating an official position of the European Commission -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own