koobas.hobune.stream
Unity3d and Database and MultiPlayer Games
Hi All,
I have two questions
First
I'm learning Unity3D now and I just want to know what is the best DBMS that works fine with unity? Or how can I choose the DBMS from all alternative that I have (SQL , MySql , etc)
Second
If I'm going to make multi-player online game that will allow different users to connect to main server and update their info's (Positions of players) and so on , what is the servers that I can use to help me in that , I heard about (SmartFox , Electrotank) , I don't know what is the best choice for my game , so please if any one can provide me some useful information about those two things I will be thankful
Thanks in Advance
I am using Photon for my MMO server side apps and I chose to use Raven DB for my database system. Both are easy, fast and cheap to use. I prefer to use Raven because its a document based database which has advantages over relational databases like SQL. Its fairly new and getting good buzz.
Raven in embedded mode says it requires .NET 4.0, but Unity 3D is currently is on .NET 3.5. $$anonymous$$aybe you are using Raven in client mode, with some external server? Raven in embedded mode also requires 512 $$anonymous$$B RA$$anonymous$$, and 150 $$anonymous$$B disk. Outrageous requirements for a mobile device, which rules Raven out for a Unity 3D client-side embedded DB.
I wouldn't be so quick to kill off relational databases. They're far more mature and sport a lot of advantages over 'NoSQL' databases, especially when concerning speed and availability.
Unity has a problem connecting to SQL Server, but seems to be pretty easy with $$anonymous$$ySQL and SQLite (Unity's Asset Server is actually postreSQL, but don't touch postgreSQL - it's architecture is... quite a mess...)
NoSQLs (document- or object-based) can be convenient - and are often far cheaper than professional versions of say, Oracle or SQL Server - but it really depends on your needs.
Check this thread for more info on servers, as that too greatly depends on your specific needs and skills (preferred program$$anonymous$$g language, communication types etc.): http://forum.unity3d.com/threads/95277-Networking-Server-Comparison-Chart
