homepage Welcome to WebmasterWorld Guest from 54.237.78.165
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
MaxDB vs MySQL vs ProstgreSQL
trying to choose a database for a 24/7 application
gabDBDev

5+ Year Member



 
Msg#: 92 posted 11:35 am on Oct 14, 2005 (gmt 0)

Hi,

I have been going through documentation and articles. I've also tried testing the databases, but I am sill not sure what to choose.

We would like to develop an application which needs to run 24/7. The system would have rich clients and web clients for reporting.

We know pretty well MySQL and now thought about going to MaxDB because it is sold as being the "database for enterprise". After installing MaxDB, I found it was quite complicated with poor documentation. There are also very few books on the subject.

Then I heard more about PostgreSQL. The only problem I see with this database would be the support. There is no company which offers the support apart from independant consulting companies.

I would like to have your feed-back or experiences with any of these databases.

Our needs would be:
- ~500 Mb data
- triggers
- procedures
- views
- stable (24/7)
- support

Optional requirements:
- redundancy
- interesting tools for admin and development (if possible)

By the way, we usually develop using java (J2EE technologies).

Thank you in advance for your feed-back.

 

txbakers

WebmasterWorld Senior Member txbakers us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 92 posted 6:13 pm on Oct 14, 2005 (gmt 0)

mySQL 5.0 would be the best of the three.

second choice would be SQL Server (Microsoft) or DB2.

With the level of your need, you want support available and you want it when you need it.

eeek

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 92 posted 9:55 pm on Oct 14, 2005 (gmt 0)

Stay away from MySql.

txbakers

WebmasterWorld Senior Member txbakers us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 92 posted 11:22 pm on Oct 14, 2005 (gmt 0)

Stay away from MySql.

Oh? And why would that be?

Easy_Coder

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 92 posted 3:47 am on Oct 15, 2005 (gmt 0)

Is mysql capable of these requirements that gabDBDev listed?

- triggers
- procedures
- views

roldar

10+ Year Member



 
Msg#: 92 posted 8:36 am on Oct 15, 2005 (gmt 0)

The upcoming version of mySQL (5) is supposed to have all three of those features. Whether or not you want to be an early adopter when your main requirement is 24/7 uptime is another matter.

gabDBDev

5+ Year Member



 
Msg#: 92 posted 5:51 am on Oct 17, 2005 (gmt 0)

I've heard that MySQL 5 triggers and procedures are difficult to implement. Has anyone had any experience with these?

I'm looking for something open source. SQL Server or DB2 are too expensive even though they do meet the requirements.

How about PostgreSQL?

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved