Hi! I’m looking to find someone that’s good with databases to create a database and event system for a game I’m working on. It’ll need a few functions:
Create room (Inputs for Name, Description, Security, & Genre)
Search room (Search by room name/owner name)
Genre sort (Input is a genre, output is most popular rooms in that genre)
Update room (Input is # of players in room & a JSON table of the rooms’ furniture)
Favorite room (Input is room ID)
Get favorited rooms
Room knocking (Players can ask to join a room, if the room owner is in the room they receive the request & can deny or accept the player)
Request to join room. (Input is room ID, if a room allows anyone to join it’ll ask the backend servers if there’s space for the player to join & respond)
Event system (Players can pay to publish their place, kind of like an advertisement. Their room gets put to the top of an event list that players can click on to always have something to do)
It’s crucial that the backend servers perform well. The main lobby place will host ~50 players to cut down on events, but each room that players join is a seperate server that they teleport to. Room lists need to update every 10 seconds or so.
All of this needs to be done through outside databases connected to my game. All I need you to do is the backend stuff. I’ll be paying for the servers and you’ll receive either 500k R$ through group funds or $1750 through PayPal upon completion. Time frame is ASAP, no real date set, though.
Please DM me here or email genya12g@gmail.com if you are interested! Please introduce yourself, your prior work, and why I should choose you. Thank you!
I may be interested in this. Though, if you don’t mind me asking:
Why have you chosen to store room furniture on an external SQL server as opposed to built-in datastores? Your goal here should be to minimize the amount of data you’re using this SQL server for, both to reduce the amount of requests we have to send and the size of the database that you have to pay for.
Thank you for clarifying. My recommendation is, as I said, to evaluate anything that can be managed on the Roblox DataStores, and use those instead of an external server.
Additionally, an important practice is to avoid storing anything absolutely crucial to the game’s data storage on external servers. In other words, your game should not be completely crippled if an external server is temporarily unavailable, which is likely to happen at some point no matter how much you do to to make them reliable. Most of this seems like social features though, so that shouldn’t be a problem.
Do you have a preference for which programming language will be used to create this? I am most experienced with PHP, but I hear that NodeJS or some others may be more reliable for this type of service. I’m interested to hear your point of view on this.
I also usually use PHP to talk to SQL databases, but I’ve used NodeJS several times now when developing Desktop applications. It works quite well, but you’d have to install it on whatever server you’re using.
You have left out a lot of key information such as what type of SQL database you are using (are there any limitation on this external service), how long is this information held within this database and what is the expected return types for each request.
I’ve got a professional Web developer friend whose built similar features in PHP for me. He’ll be sending you an email and I’d highly suggest having him do the job! He knows his stuff and works fast!