Hi I’m working in this project by myself and I got stuck when I had to choose the ORDBMS. I have to develop an app for managing Requests for Payment Instrument (RPI), this doc is used to generate paychecks for paying bills in my company. The users that will use my app are stored in a LDAP server, so I only have to assign them roles in my database. I had planned to use MySQL as the ORDBMS but I found that in the community server, one can’t create roles. So I do some digging and found that PostgreSQL does have this feature.
Right now I can only choose between MySQL 5.5 y PostgreSQL 8.4.9, both services are running on Centos 5.8. Would you please help me decide what service should I use for my app? For now my app will be deployed for windows, XP mostly.
I had never used Postgre so I would have to start learning how to work with it, no problem but I will still appreciate any feedback since this is my first time developing a large project.
I apologize if my English writing isn’t the best. I’m from Cuba, so this is not my native language.