Orlando Andico wrote:

> On Thu, 6 Apr 2000, Federico Sevilla III wrote:
> ..
> > In what ways is MySQL better than PostgreSQL, and in what ways is it
> > the other way around? This also brings us to: for what applications
> > (real world) will MySQL be a better solution compared to PostgreSQL,
> > and for what applications will it be the other way around?
>
> MySQL:
>
>  - faster
>  - simpler
>  - easy to install
>  - very reliable (try www.persiankitty.com  :)
>  - very usable ODBC drivers (ODBC 2.5)
>
> but:
>
>  - no transactions
>  - no subqueries

    - no stored procedures
    - no triggers

> PostgreSQL:
>
>  - has transactions
>  - has subqueries
>  - better SQL92 conformance
>
> but:
>
>  - slower
>  - allegedly less reliable
>  - troublesome to install (until you see Oracle.. :)
>  - subpar ODBC drivers (ODBC 1.0/2.0)

    - stored procedures and triggers are pain in the ass :->

try Borland's Interbase for linux and freebsd, it will really rocks you of its rich
features! :->

fooler.


-
Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]

Reply via email to