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
- stable (24/7)
- 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.