Or Will I need to get the enterprise version?
This is because I found this on MySQL's site:
If you are running a MySQL production level system, we would like to direct your attention to the product description of MySQL Enterprise Edition at:
When I check the features, it seems like the community edition does not support transactions, while the enterprise version does.
If it is true that the community edition is not right for production, then it seems like posgresql may be my way out, for it supports transactions and it is fully opensource.
Will the sql syntax need to change (much) if I have to change?