Databases in Unity

Hi,

I would like to use a local Database in my Unity project, what would be the best way to do it?

In particular I would like to use SQLite, is there some add-on that works good on all platforms? (Android, iOS,Mac,PC)

Is there an efficient way to simply use a text file as a database, if the database is not big, so I will not have problems working multiplatform?

Thanks,

 

well the way i have done it is to create two scripts, mine is called database and database_get. i used unity web request to handle the data and also i made a php script that connected to a phpmyadmn database.

https://docs.unity3d.com/ScriptReference/Networking.UnityWebRequest.Post.html

and this is a straight forward php guide where basically after the connection check you do your query
https://www.w3schools.com/php/php_mysql_connect.asp

 

Thanks fot your reply, I ment a local database like Sqlite.

 

Is there an efficient way to simply use a text file as a database, if the database is not big, so I will not have problems working multiplatform?

 

thank you