Welcome to WebmasterWorld Guest from 54.163.168.15

Forum Moderators: open

MaxDB vs MySQL vs ProstgreSQL

trying to choose a database for a 24/7 application

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

5+ Year Member



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)

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



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)

WebmasterWorld Senior Member 10+ Year Member



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

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



Stay away from MySql.

Oh? And why would that be?

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

WebmasterWorld Senior Member 10+ Year Member



Is mysql capable of these requirements that gabDBDev listed?

- triggers
- procedures
- views

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

10+ Year Member



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)

5+ Year Member



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?

 

Featured Threads

My Threads

Hot Threads This Week

Hot Threads This Month