Hello. Recommend a plugin for connecting online games to a database, for example Mysql, sql and the like. I found several on github, but which one is better?
“best” and “better” depends on your project. is up to you which one is better.
afaik unreal has sqlite integrated i think.
there are other types of databases that don’t use sql that are worth checking.
but also more importantly is to know why you want to use a database.
can a datatable suffice? (they can be updated at runtime and in packaged builds)
Something more serious is needed here. I need a database for online multiplayer with a dedicated server
It is very difficult to find information about mysql integration
Have you worked with VRlxtech/MySQLDatabaseConnector plugin? Did everything work?
don’t underestimate sqlite, it’s quite performant, mysql is popular but it’s not super and has a lot of overhead comparatively. if you really want something professional i’d use postgres.
it depends on how you set it up. and what does your game needs. how many servers you’re spawning.
if you have only one server, then sqlite might be good enough.
also how many players you actually have? might not be worth wasting time with that until you really need it.
i haven’t used any mysql connector. i would use stuff from fab before using git. there are a few db connectors there.
using sql or any other database is a lot of extra work. you have to set up the infrastructure and the servers, and pay and maintain that. it’s super expensive for an indie.
what most games use, professionally, are 3rd party backends. there’s one i used that was good i can’t find the real page, might be dead or i forgot the name. was something like gamespark, there’s also playfab (which does much more than that). but there are a few really simple ones with free tiers, i would check those.
i think you could also use firebase. i’ve also used firebase professionally. Firebase for games | Supercharge your games with Firebase
most of those things have a free tier.
really random page i found just as an example:
actually the more professional/wise thing to do is to avoid having to handle it yourself and just use a 3rd party solution, like gamespark, playfab, firebase, back4app, nakama, etc.
1 Like
nakama is really good. i’ve used it. Nakama: The leading open source game server for studios and publishers - Heroic Labs and it’s open source.
back4app seems to be good, never used it but seems popular and the web indicates it might be useful to you.
here obviously need mysql. There are thousand of players at the same time on the same server, who frequently access the database
thousands on the same server? i don’t think ue can handle that. in fact it has a low limit preconfigured. less than 60, maybe around 16.
check nakama, playfab, and back4app. all those are as performant or more than sql.
otherwise just create a sql server yourself in aws or gcloud or whatever. and use whatever plugin you like.