Best DBMS for Unity
Hi,
I'm working on a Unity Project. We have to store 3d models, textures and others in a remote db.
We are checking various solution, but we haven't decided yet.
We need a DBMS with Unity APIs, so we won't have to write db-interation code by ourselves.
We already checked:
SQLite - Good, but is used only for filesystem db, not remote ones
Amazon SimpleDB - Good, no SQL tough.
PostgreSQL - Very good, but as far i know it hasn't explicit Unity APIs
Any idea or better solution?
I don't understand why you need a DB with a "Unity API" - especially if it's a remote db. For the data you mentioned, I'd think you'd just be pushing the data into a simple table with a blob field for the actual content storage.
.NET already has very capable generic DB support via ADO.Net. You should be able to find an ADO.net driver for most popular db's - including the one's you've mentioned.
Also, SQLite can absolutely be used as a remote db if that sounds interesting.