Just like the title says, I want Unity to read content from a database and I wanted to know which database works best with Unity whether its Access, Excel, MySQL or SQL. Then I wanted to know how does unity read the contents of that database. Many thanks in advance!
Look, you can use whatever databases you’re familiar with. At the point where a combination of the scope of your project and your skill level actually makes the differences between the different kinds of databases matter, you already know enough about them that you wouldn’t need to ask this question.
As for how to use them, you use them like you would with any other C# application. You grab some library or plugin that allows you to speak with the database of your choice, and then you use that. Nothing fancy Unity-specific needed.
If you want something really fast, just grab a package of the unity asset store. Just do a search for database. There are some free ones, like this one. Have fun.
You can also do a custom one , but SQL seems a good one