I was wondering if Lua can work with external databases. What do I mean? For example if I make a Database can I access it in Roblox? I do know we can work with JSON but not sure for external databases. Thanks!
1 Like
I don’t know. But you can email roblox or looking it up.
Yes you can, I’m pretty sure jailbreak did it or some sort of big game
Will Roblox reply back? They already have tons of requests to reply back to and I don’t see why they would help in a question like this.
I am a lover of Jailbreak but I don’t think they access data from another database. I can get JSON data yet I don’t know about it in Databases that I create with SQL.
You just need to use http post and whatever is the other one to recieve data
Encode it with json and retrieve with decode
The easiest way to do it is using a website as a proxy, so your game interacts with the website, and the website interacts with the database.
EDIT:
I use a custom database for my game. The game uses the HttpService to interact with my website which in turn fetches/updates the data in the database.
I dont know about sql, I know that you can do it with your own website, I dont know if sql is supported for retrieving the data tho, you could prob do it but too hard for me
As he said you can do a website that retrieves the data puts it into a file, and then another thingy reads the file, and uploads it to sql
SQL is a query language, not something that stores data. Its used for interacting with databases.
I am wondering how exactly will I fetch the data from the website? I can put the data in apps like Heroku or even Github. Not sure how I will fetch the data the website displays.
Edit: Would it be better to just put JSON data and fetch it?
Of course you can, the more important question is whether it’s worth it. Ask yourself about the benefits of using an external database? Security? Roblox has high security standards? As a step to prevent data loss? Perhaps, althougt DataStores are pretty secure, and a developer can do a lot with resources that Roblox already provides.
Ask yourself whether you can simplify the process and use currently available data storing services and modules. DataStore, DataStore2, ProfileService etc.
If you are still interested in setting up own external data base (at your own expenses of course), you can take a look at these posts, that explain the use of HttpService and give you a good start.
An example of game with external database is Royal High, although many games rely on default options, which are pretty trustworthy and have relatively wide variety of tools needed.
EDIT
@PandaLikesCaps sure, you can probably wrap everything in JSON and work with Python. I can’t give you a complete advice, as I mostly don’t work with external databases in Roblox environment a lot. Personally, I find classical data stores and modules that take even further precautions against data loss good enough. Definitely take a good look at how data saving works in general, and find all the details around the process. Perhaps hire a professional for assistance (it doesn’t necessary have to be someone knowing Roblox services, since we are talking about data storing and data accessing in general). When I’m personally in doubt about data saving, I turn to someone whose job is to work on that area.
For the start, you can take a look at “Anti-bot modules”. There are a couple of modules here around the Dev Forum that involve connecting module with external, always accessible web pages displaying data in JSON format (e.g. lists with “banned false free Robux generating advertisements”).
Hopefully this information gives you some head start.
Answer is yes, but external datas are kinda broken and working slow.
Would it be better just to display JSON data? I can easily work with them using Python and I can fetch the data in Lua.