IDS Forum

RE: Postgres database vs Informix

Posted By: Lee Aholima
Date: Sunday, 3 October 2004, at 6:50 p.m.

In Response To: Re: Postgres database vs Informix (Jairo Gubler)

1) Is Postgres database a potential replacement for Informix. If not
why not? If it is, why?
No, checkout sybase who are coming out with a free substitute for linux
o/s. Furthermore I am sure it has a few intrinsic problems which is why
not many people have taken it up in the corporate world.

2) Are the way the developers relate to me the DBA the way developers
relate to DBA's elsewhere.
For some DBAs I guess that is the case but in general developers have a
habit of underestimating the importance of DBAs and database platforms
and it's abilities and also their understanding of how to get the best
out of databases is limited. DBAs should not be left out of any loop. If
developers control the way the database environment runs and operates
you will be having a hard time (having been a project DBA as well in the
past).

L

Lee Aholima,
Database Administrator
Thames-Coromandel District Council
Ph 07 868 6025
Email lee.aholima@tcdc.govt.nz
Mobile 0274333915

The contents of this e-mail maybe CONFIDENTIAL OR LEGALLY PRIVILEGED, &
is intended only for the persons named above. If this e-mail is not
addressed to you, you must not use, read, distribute or copy this
document. If you have received this document by mistake, please call us
and destroy the original. Thank you.
=20


-----Original Message-----
From: Jairo Gubler [mailto:jairo.gubler@digitro.com.br]=20
Sent: Saturday, 2 October 2004 1:31 a.m.
To: ids@iiug.org
Subject: Re: Postgres database vs Informix [3520]=20


We develop applications using INFORMIX, ORACLE and POSTGRES.

We are using POSTGRES (LINUX) for application with few data. For our
applications, we use a limit 2 million rows per table. Until release 7.4
POSTGRES has some problems with online backup. Another problem is the
update command that does an delete/insert. This deleted records must be
removed with an administration command (VACUUM).


Jairo Gubler
----- Original Message -----=20
From: "Peter J Dia...." <pdiazdeleon@infinityhealthcare.com>
To: <ids@iiug.org>
Sent: Friday, October 01, 2004 8:20 AM
Subject: Postgres database vs Informix [3517]



Can anyone shed some light on this for me. Some of the developers
within our company are advocating the move from Informix 9.4.x to
Postgres for no other reason (it seems) than Postgres is "free/open
source." They are of the mind set that everything should be database
agnostic and the use of SPL's, triggers and any form of business logic
in the DB is evil. There plan it to stuff all business logic etc...
into the Java App Server. For example, instead of using triggers to
create a history table to track any update that occurs they decided to
place that logic in the App Server. They use of Tapestry and Hibernate
are increasing.

They believe (the developers) should have complete say on what database
should be used and how everything should be architecture from start to
finish leaving me the DBA out of loop until they are ready to deploy.

So I guess I have really two questions.
1) Is Postgres database a potential replacement for Informix. If not
why not? If it is, why?
2) Are the way the developers relate to me the DBA the way developers
relate to DBA's elsewhere.

Thanks
Peter






----------
CONFIDENTIALITY NOTICE: This e-mail message, including any
attachments,is for the sole use of the intended recipient(s), even if
addressed incorrectly, and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or distribution
is prohibited. If you are not the intended recipient, please contact
the sender by reply e-mail and destroy or delete all copies of the
original message and all attachments, including deletion from the trash
or equivalent folder. Thank you.

Messages In This Thread

• Postgres database vs Informix
  Peter J Diaz de Leon -- Friday, 1 October 2004, at 7:20 a.m.
  • RE: IDS: Postgres database vs Informix
    Andreas.KUTSCHE@spar.at -- Friday, 1 October 2004, at 8:51 a.m.
  • Re: Postgres database vs Informix
    Obnoxio The Clown -- Friday, 1 October 2004, at 9:14 a.m.
    • Re: Postgres database vs Informix
      Jesus Antonio Santos Giraldo -- Friday, 1 October 2004, at 2:24 p.m.
    • RE: Postgres database vs Informix
      Obnoxio The Clown -- Friday, 1 October 2004, at 8:25 p.m.
      • Re: RE: Postgres database vs Informix
        Jean Sagi -- Friday, 1 October 2004, at 9:27 p.m.
  • Re: Postgres database vs Informix
    Jairo Gubler -- Friday, 1 October 2004, at 9:30 a.m.
    • RE: Postgres database vs Informix
      Lee Aholima -- Sunday, 3 October 2004, at 6:50 p.m.
  • Re: Postgres database vs Informix
    Gregory S. Williamson -- Friday, 1 October 2004, at 5:52 p.m.
  • Re: Postgres database vs Informix
    Christine Normile -- Monday, 4 October 2004, at 10:06 a.m.
  • Re: Postgres database vs Informix
    Peter J Diaz de Leon -- Thursday, 21 October 2004, at 5:36 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.