Database compatibility

Unity Engine
1

Hi,
i want to create an online database for my application.
In database will be some information like user name, last enter date, etc.
Basically, it’l like an excel.

What database should i use for this?
Thx.

2

Hi.

It depends on your knowledge and usage, MySQL or MongoDB.

Thanks.

3

@hasanbayat thx for reply.

Problem is, that i don’t know any of these.
So i’k searching something simple to implement.

Thx.

4

The MongoDB is a bit simpler than MySQL.

You can contact someone that would be able to implement it for you, but it is paid for sure if you don’t know how to implement it.

Thanks.

1 Like
5

Other alternatives:

  • SQLite
  • Postgres
  • MariaDB (the non-Oracle fork of MySQL)
  • There is an asset to link C# to GoogleDocs spreadsheets, if “like Excel” is what you really want. I don’t recall the name of the asset.

The question you need to answer is, where do you want the database to live?

  • Within the same host as runs your Unity application? In that case, security constraints on mobile vs. desktop vs. console environments may limit your choices of database.
  • On a server to which your Unity app connects remotely? In that case, security constraints will limit what protocols you can use for the connection (REST, XMLRPC, ODBC, etc.) and also the remote host you are allowed to connect to.

Also, how much data do you have, in terms of:

  • How many tables do you expect to have, and will they need to be joinable to one another for complex queries?
  • How many rows per table do you expect to store?
  • Do your data columns include any long text, or BLOB, fields?

I can’t offer to do the work for you for free, but I am a database admin in my “day job” and can certainly offer some friendly advice if you can post more detailed requirements here.