I’m going to start development on a multiplayer RPG-FPS in the near future, and i was wondering what type of database would be better for this? I have a lot experience with MySQL but none at all with PostgreSQL but I’ve always been told to use PostgreSQL for games because it’s more developed and has more features, but for use with this kind of game using Unity3d would I even need these features?
No one seems to have replied but the poll suggests MYSQL.
I’m quite curious about what will happen to mySQL after Oracle finally swallows Sun. I just can’t imagine that Oracle continues one of its largest (plus free) competitors while their own software still sucks and still costs a lot.
If you cannot yourself name a feature that you have to have - then its because there isnt one.
Both are super capable and can do more or less the same (especially the latest years where MySQL closed the gap).
So use the one you got most experience with is my recommendation.
/Thomas
(Personally using MySQL)
I prefer mySQL
I use mysql and it works perfect.
They both get the job done. Use the one you know.
there is no option for them.
they can
- continue it
- fight the already breanched out 5.0 opensource base as many hate the 5.1 base (incompatible db stuff hardly never fiends friends).
I personally would go with mysql myself. nothing against postgre but even at worst, mysql seems to be half a hell less resource hungry than postgre.
MySQL and PostgreSQL have different licenses. This may not affect you, but I did have work on one project where we chose PostgreSQL because of that.
This wouldn’t affect me because I’m not making changes to either of them.
MySQL’s license pretty much says you can’t change it then sell it commercially, PostgreSQL’s license says you can do this as along as you maintain credits.
mysql though will affect you if you want to distribute an app that uses mysql, as you must get a license then too, independent of if you used sources or not, just for utilizing it in a commercial application that primarily uses it.