Re: Best database for web backend on Linux?
--------------68A16821340EF85D7B7B5042 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Yun Ye 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 Yun, If you are looking to do development for education or hobby, then PostgreSql and MySQL are pretty good (I use them too), if however you need something sturdier with data integrity that can handle a power outage, then you need something like Sybase, Oracle, Informix. Having used and managed all three of the latter, I would say that the best all arround data server in the comercial class is Sybase. In response to your functionality requirements, watch out for row-level-locking. This feature was resisted for years in Sybase for good reason, it sucks. Row-level-locking has been known to cut the performance of an otherwise zipy Oracle server down to glacial speeds. Generaly speaking, row-level-locking is regarded to be a design flaw anyway, so you probably don't want to rate that feature too highly. -- ----==-- _ / / \\ ---==---(_)__ __ ____ __ / / /\\ \\ --==---/ / _ \\/ // /\\ \\/ / / /_/\\ \\ \\ -=====/_/_//_/\\_,_/ /_/\\_\\ /______\\ \\ \\ A proud member of TeamLinux \\_________\\/ email: carew@home.msen.com web: http://home.msen.com/~carew --------------68A16821340EF85D7B7B5042 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit <HTML> Yun Ye wrote: <BLOCKQUOTE TYPE=CITE>Now that we got all sorts of commercial and free databases available for <BR>Linux, I don't know what to use. I currently use PostgreSQL, but its SQL <BR>implementation is quite incomplete (no foreign key, alter table add <BR>constraint, etc.), and there's no row-level locking. I want to try <BR>something else but don't have much experience with other databases. Can <BR>someone summarize the pros and cons of each database as a web backend? I'm <BR>considering PostgreSQL, MySQL, Solid, Oracle, Sybase, and Informix. The <BR>features I'm most interested in are transaction support, general SQL <BR>support, good Perl DBI/DBD implementation, row-level locking, online backup, <BR>max size of VARCHAR, and persistent connection. Oh, also price. (I know <BR>Sybase for Linux is free, but what's the price for Oracle as a web backend?) <P>Thanks, <BR>Yun</BLOCKQUOTE> Yun, <P>If you are looking to do development for education or hobby, then PostgreSql and MySQL are pretty good (I use them too), if however you need something sturdier with data integrity that can handle a power outage, then you need something like Sybase, Oracle, Informix. Having used and managed all three of the latter, I would say that the best all arround data server in the comercial class is Sybase. <P>In response to your functionality requirements, watch out for row-level-locking. This feature was resisted for years in Sybase for good reason, it sucks. Row-level-locking has been known to cut the performance of an otherwise zipy Oracle server down to glacial speeds. Generaly speaking, row-level-locking is regarded to be a design flaw anyway, so you probably don't want to rate that feature too highly. <PRE>-- ----==-- _ / / \\ ---==---(_)__ __ ____ __ / / /\\ \\ --==---/ / _ \\/ // /\\ \\/ / / /_/\\ \\ \\ -=====/_/_//_/\\_,_/ /_/\\_\\ /______\\ \\ \\ A proud member of TeamLinux \\_________\\/ email: carew@home.msen.com web: <A HREF="http://home.msen.com/~carew">http://home.msen.com/~carew</A></PRE>; </HTML> --------------68A16821340EF85D7B7B5042--