Re: Best database for web backend on Linux?

On Fri, 16 Oct 1998 04:38:38 GMT, Yun Ye <yye_at_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

PostgreSQL actually has a more complete SQL implementation than most of the other free-to-low-cost database systems. For example, I use MySQL as a web backend because it is blazingly fast -- but it doesn't have stored procedures or other such nicities, not even cursors (although it has a "LIMIT" clause which can be used to emulate cursors).

Try http://linas.org/linux/db.html for a long list of databases available for Linux.

You may wish to reconsider some of your requirements. A web backend used in a CGI-type environment has some pretty intense time constraints. Most of the features you mention (foreign key, transactions, constraints, etc.) reduce the speed of the database considerably without being of any help in the web environment (due to its stateless nature).

--
Eric Lee Green         eric@linux-hw.com     http://www.linux-hw.com/~eric
"To call Microsoft an innovator is like calling the Pope Jewish ..." 
            -- James Love (Consumer Project on Technology)