koobas.hobune.stream
Unity 3d cross-platform data storage (standalone, android)
I have designed a database structure of 6 tables including two m:n relationship. In fact I need only to load data.. so it can be static. Although, I need to keep the relationships between the tables. What is the best way to store this type of data? My main target platforms are: standalone (Windows, Linux) and Android.
Firstly, I thought that the SQLite as a local database could be a solution. Then I found out that Unity Free does not allow to use System.data while exporting to Android.
Do I really have to use XML and hardly connect the tables that way or is there any other possibility?
The game access the server to retrieve the data or ir must be available offline?
I Need something offline avaliabe
Unity free now have almost no limitation relative to pro, so you probably can do it now.
The usual solution is always embedded using XML, JSON or binary serialized data instead embed a full sql engine.
It is a piece of cake to create a unity editor window (http://docs.unity3d.com/Manual/ExtendingTheEditor.html) that in a click load all your sql data into a ValueObject or basic type (dictionary) and then export into a file that easy to read (http://docs.unity3d.com/ScriptReference/Resources.Load.html).
Depending of you data could be more interesting import it into many gameobjects/prefabs or scripts values, so you can see, edit and reference using editor.
