homepage Welcome to WebmasterWorld Guest from 54.211.7.174
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Subscribe to WebmasterWorld
Visit PubCon.com
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

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




msg:1580828
 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




msg:1580829
 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




msg:1580830
 9:55 pm on Oct 14, 2005 (gmt 0)

Stay away from MySql.

txbakers




msg:1580831
 11:22 pm on Oct 14, 2005 (gmt 0)

Stay away from MySql.

Oh? And why would that be?

Easy_Coder




msg:1580832
 3:47 am on Oct 15, 2005 (gmt 0)

Is mysql capable of these requirements that gabDBDev listed?

- triggers
- procedures
- views

roldar




msg:1580833
 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




msg:1580834
 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