Hi.
I’m now using at my project sqlite database, But the game it’s multiplayer and allows 4 players at same time to regitrate. And i’m afraid to have problems if try to acced database at same time.
I’m thinking to change to other dabatase with server system like mysql or postgresql.
Whats the Best choice? any tutorial or guide?
Thanks!!
Use what ever did you want, the easy one, if your project go further and start to bottle neck, so you can invest deep in a better solution.
Its really depends a lot of you needs, if you can support downtime, eventual consistency, queries, etc…
Relational databases (like mysql and postgresql) are good for cohesion, but they are not very friendly when you need to scale. But it should be a problem only with some hundred inserts por second.
Take a look into MongoDB, it is good nosql scalable friendly. If you want to pay without bother, could use a SimpleDB from amazon Aws. Very fast edit, Redis DB. For infinite write scale with high avaiability Cassandra.
If you only really need to write, the best service that you could have is a single service that append into a file (with proper assyncronos io api and buffers).
It it common practise to NEVER give the client a direct connection to the database, as they’d be able to edit stuff they shouldn’t.
Instead, I’d suggest you write a server trough which the players can interface with the database. This way only one connection to the database is required (server-database) and you can prevent any unwanted modifications.