- Home /
How to integrate SQL database in game?
So i will study a course named Database Management System (DBMS) next semester and i MUST use SQL in my project for the course.....So is there a software or plugin which writes SQL and integrates it into Unity.....I simply want SQL code in my game in short.....So any suggestions ?
It should have SQL writing capability and integrating it with Unity......any help would be greatly appreciated :)
Thank You.
Answer by Landern · Dec 26, 2014 at 05:13 PM
If you want it "integrated" in your game, use something like SQLite, click for more details.
If you want to do something online, chances are you don't want the direct layer to your database in Unity, but you want some api. Generally using a type of restful(ish) service with bunch of URI endpoints front end that can be called with WWW class would generally work. Security of course depends on the implementation.
Thanks but SQLite uses javascript ....from your link i see that....but i want to use SQL language in my game for the data base.....not a javascript language....so any other recommendations where i can show my $$anonymous$$cher that hey here i have used SQL in my game.....$$anonymous$$y aim simply is to use SQL in my game
Thanks but SQLite uses javascript ....from your link i see that....but i want to use SQL language in my game for the data base.....not a javascript language.
SQLite does NOT use javascript/unityscript, you saw an implementation of the data access layer in unityscript, the calls were to SQLite. The code is portable to c# with ease.
so any other recommendations where i can show my $$anonymous$$cher that hey here i have used SQL in my game.....$$anonymous$$y aim simply is to use SQL in my game
What does this mean, SQL is just a querying language. If you want to use databases and tables that conform to SQL, then unity does not have an API for that. You WILL have to implement it yourself. If the same is to use SQL, does that mean you want a data access layer making connections to a $$anonymous$$SSQL/$$anonymous$$YSQL endpoint and you want to use SQLConnection classes to interact with it, perhaps exec sprocs?
If you LITERALLY mean you want "$$anonymous$$y aim simply is to use SQL in my game".... i'm sorry you're going to have to qualify that statement.
Your answer
Follow this Question
Related Questions
SqlConnection Error con.Open() 0 Answers
Sql Server Compact 4.0 error 2 Answers
Can't connect from Unity 3.1 to SQL Server Express 8 Answers
Any good tutorials for using databases with unity? 0 Answers
Android | online database 2 Answers