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

Unity Engine
1

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.

2

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

3

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

I usually recommend iBoxDB.

4

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.

2 Likes
5

is it slow? how can you claim that?

6

Like this.

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

But of course, you can measure for yourself.

2 Likes
7

interesting

8

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.

9

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.

10

if I could write one this post wouldn’t have a “feature request” header

11

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

1 Like
12

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

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.

1 Like
13

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.

1 Like
14

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

15

year 2024 Database backend is still A VERY BIG PROBLEM.

16

Problem for who?!!

I posted this to you in 2021 and it still will only take you a few minutes to bring up:

This SQLite package works on Android, iOS, MacOSX and Windows:

https://github.com/codecoding/SQLite4Unity3d

Read these SQLite considerations carefully:

https://discussions.unity.com/t/794574/3

1 Like
17

Only for people who don’t understand that the database you choose depends on your requirements. One size legitimately doesn’t fit all in this case unlike many things that the company could stand to do for us.

1 Like