Welcome to WebmasterWorld Guest from 54.145.213.148

Forum Moderators: open

Message Too Old, No Replies

MaxDB vs MySQL vs ProstgreSQL

trying to choose a database for a 24/7 application

     
11:35 am on Oct 14, 2005 (gmt 0)

New User

10+ Year Member

joined:Oct 14, 2005
posts:2
votes: 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.

6:13 pm on Oct 14, 2005 (gmt 0)

Senior Member

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

joined:Sept 1, 2001
posts:4392
votes: 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.

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

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Nov 20, 2004
posts:879
votes: 2


Stay away from MySql.
11:22 pm on Oct 14, 2005 (gmt 0)

Senior Member

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

joined:Sept 1, 2001
posts:4392
votes: 0


Stay away from MySql.

Oh? And why would that be?

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

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:June 2, 2003
posts:1184
votes: 0


Is mysql capable of these requirements that gabDBDev listed?

- triggers
- procedures
- views

8:36 am on Oct 15, 2005 (gmt 0)

Full Member

10+ Year Member

joined:Apr 21, 2004
posts:306
votes: 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.
5:51 am on Oct 17, 2005 (gmt 0)

New User

10+ Year Member

joined:Oct 14, 2005
posts:2
votes: 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?

 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members