Re: Best database for web backend on Linux?

I'm using Mysql and believe, as advertised, it is probably one of the fastest. Since I'm just now getting into this, I'm not sure it will support all of the features you desire. It _does_, however, have a great Perl interface, with which I've written routines to access several databases I have and it also has the PHP3 with Apache. I've written front ends similar to the Perl, but using html format allowing users to access the database using simple TCP/IP connections and a web browser. As I said it _is_ extremely fast.

Probably the best thing to do is to go to their home page and download the text version of the manual. This should tell you all you wish to know.

...Edwin

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
>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
>
>

-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~   Edwin Johnson.........elj_at_prysm.net   ~
~        http://www.prysm.net/~elj        ~
~                                         ~
~ "Once you have flown, you will walk the ~
~ earth with your eyes turned skyward,    ~
~ for there you have been, there you long ~
~ to return." -- da Vinci                 ~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~