pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Shane Ambler <pgsql@007Marketing.com>
To: PostgreSQL Mailing lists <pgsql-general@postgresql.org>
Subject: Re: Database Selection
Date: Tue, 25 Apr 2006 05:42:15 +0930
Message-ID: <C0736737.3FB17%pgsql@007Marketing.com> (raw)
In-Reply-To: <1145863743.280424.116910@y43g2000cwc.googlegroups.com>

On 24/4/2006 16:59, "IvoD" <gordion@quick.cz> wrote:
> For the first app I wanted to use MySQL, for the second one I wanted
> the Sybase SQL Anywhere. But now I am in doubt. I'm playing with the
> idea to substitute the Sybase SQL Anywhere by the PostgreSQL or MySQL.
> I need all the SQL decorations (stored procedures, stored functions,
> triggers, declarative referential integrity (foreign
> keys), ...) I'm playing with the idea to unify the database environment
> (use only one db engine and two databases, not two different db engines
> for two databases), too.

If you want the full SQL decorations then you will want PostgreSQL.

The newest version of MySQL has started to implement stored proc's  - as
this is a new addition to MySQL I wouldn't count on full support just yet.

> Is the MySQL or (preferably-IMHO) PostgreSQL database engine stable,
> robust, safe, ..... in order to use it for these company very sensitive
> data, for heavy data mining app, ... ? Is it safe to unify the database
> engine types and use only one engine for these two apps/dbs? Can I rely
> on the MySQL and/or PostgreSQL engines? Do you suggest me to use (one
> of/both) these two db engines for the main company data presentation
> database?
> 
PostgreSQL is considered stable and is used in production environments.


If you look at the history of PostgreSQL you will find that the development
at Berkley started with Ingres and after the code was used to start
Relational Technologies/Ingres Corporation the Postgres project was born.
A later version of Postgres was used by Illustra Information Technologies
which later merged into Informix and is now owned by IBM.
This gives you some some indication of the quality - two commercial
databases have been started with PostgreSQL code.




view thread (27+ messages)  latest in thread

Message-ID: <C0736737.3FB17%pgsql@007Marketing.com>
Permalink:  ../C0736737.3FB17%25pgsql@007Marketing.com/
Also on:    postgresql.org/message-id/C0736737.3FB17%pgsql@007Marketing.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: pgsql@007Marketing.com
  Subject: Re: Database Selection
  In-Reply-To: <C0736737.3FB17%pgsql@007Marketing.com>
  References: <1145863743.280424.116910@y43g2000cwc.googlegroups.com> <C0736737.3FB17%pgsql@007Marketing.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox