Feature Request Unity doesn't have a good, reliable even acceptable database solution.

Hi,
SQLite is a great Database and completely free.
Why don't you have a native SQLite connection service? (I don't trust 3th party providers)
We suffer when we serialize something.
We suffer when we use dictionaries.
we suffer to save complex game data.
And the solution is just right there waiting for you to extend your arm.

 

By the way when I say support SQLite, it includes a good interface too... Not just a connection code.

 

And it's slow for game purposes. So it is not widespread. So Unity doesn't care about it.

I usually recommend iBoxDB.

 

My personal opinion is using a local SQL database for the purpose of game save files is an overly complex solution.

But as far as why Unity isn't doing it, are you sure SQLite would be supportable, reliable, and performant on all Unity target platforms? If they have to exclude platforms, Unity is less likely to want to add the feature.

 

is it slow? how can you claim that?

 

Like this.

https://sourceforge.net/p/benchmarksql3/code/ci/master/tree/

But of course, you can measure for yourself.

 

interesting

 

However, speed does not mean everything. Because in a lot of cases SQLite provides enough speed to save data. And SQLite has much more survivability and it is a trusted db. Instead of having db who is written by a man and with no clear future.

 

Whatever.

Once Unity moves to .Net Core, you will have your SQLite solution since C# actually provides it in .Net Core. Until then, write your own if you don't like the thousand other one which was written by people just like the .Net Core one.

 

if I could write one this post wouldn't have a "feature request" header

 

The database you choose greatly depends on your project requirements. Why build in one in particular when implementing one isn't that even hard?

 

Because we're just some guys on the internet and apparently what we write have no future.

Disclaimer: I am not the author of the database I recommended. I still like it and the fastest I ever saw working in Unity with (semi-)string-based query.

 

SQL just isn't a very popular choice for game developers. If they were to implement a first party solution, you would probably find that not many developers would use it.

That doesn't mean it doesn't have its uses, but I doubt it's worth the effort to implement it.

Just use a third party solution.

 

Last but not least I need it for mobile platforms which also make the subject more difficult than it was.