Forum Moderators: open
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.
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.
Stay away from MySql.
Oh? And why would that be?
- triggers
- procedures
- views
I'm looking for something open source. SQL Server or DB2 are too expensive even though they do meet the requirements.
How about PostgreSQL?
