what is the best database?

Hi,



What is the best and strong free database for small and medium business?



Do you really recommend mySQL?





Best Regards,

Jassim Rahma

I have the same question, but put it in the wrong forum, so heres the link http://forums.devshed.com/showthrea...ed=1#post872603. jrahma - do you meen for a business website of for the business systems?



I require a form of data storage for an estate agent systems. i.e. resident on the computers within the office, not for their website. i no little about databases, so what would you guys recommend. i have done some mysql work, but for some reason i don't think mysql will be suitable. Please help.

If you are planning on implementing for open-source (Linux, FreeBSD, etc...) then the two major contenders for popularity are MySQL and PostgreSQL. The choice really depends on the level of importance your data takes, and the level of skill you have in database design/usage: MySQL is lightweight and easy to use, but very lacking in serious business logic capabilities, while PostgreSQL takes more time to learn, but gives you a tool that is almost on a par with Oracle or DB2.



So, I would put it this way:



- Need fast & easy -- data not too important? Use MySQL.



- Need to plan for the future -- need serious data integrity? Use PostgreSQL.



Just search this forum and the PostgreSQL/MySQL forums for "MySQL Postgres" and you will find some good discussions on the differences between these two.



P.S. -- www.firebirdsql.org is another good open-source system that is more on the "serious" side.