Bloxdatabase [1.0] - sql database connect with api up to 13 database server type

Resources Community Resources
#1

Bloxdatabase is one of the BloxCodeTools programming library. It use api connect thru my website, Bloxdatabase can connect up to 13 database server type (MySQL, Micresoft SQL Sever, etc.) . APIs will link my website (thondon.com). I hope you guys like it. I’m sorry but BloxCodeTools don’t have document yet. You can use the module script at BloxDatabase - Roblox. If you have any questions, suggestions, bug reports, Or want to add something, you can comment under the topic. Thank you for reading this thread till the end (I’m new at Roblox lua).

4 Likes
#2

I don’t understand what do you mean, it’s very messy, misspellings and more :confused:

1 Like
#3

I’m sorry that I’m not good at English. Simple explanation is It’s a library that can connect to sql database using api through my website. It can connect to many databases such as MySQL, Microsoft SQL Server, Firebird and 10 others.

1 Like
#4

[1.0] UPDATE Document to use

1) Require BloxDatabase to your script

local BloxDatabase = require(13126153242)

2) Set database config

BloxDatabase.config.database.server = "Your server"
BloxDatabase.config.database.username = "username"
BloxDatabase.config.database.password = "password"
BloxDatabase.config.database.name = "database-name"
BloxDatabase.config.database.type = Bloxdatabase.database.[Your database type]

3) Connect to your database

BloxDatabase:connect(BloxDatabase.default)

--If you gonna use database(name) config you can put 1 parameter (BloxDatabase.default) to connect function
--If you want to connect to new database(name) you can put name parameter to function (index: first parameter)

--If you want to custom config before connect database you can use second parameter. example: 
BloxDatabase:connect(BloxDatabase.default,
   {
      ["username"]="newUsername", 
      ["password"]="newPassword", 
      ["server"]="newServer", 
      ["database"]="newDatabaseName"
   } --You can skip table config parameter element if you gonna use default data [ 2) Set database config ]
)

4) Query SQL

4.1 Normal Query

BloxDatabase:query(sql)

4.2 Prepare Query
this query type support bindParam that will help prevent SQL Injection

BloxDatabase:prepare(sql)

Bloxdatabase:bindParam(":Parameter", "value", BloxDatabase.datatype.[your-datatype])
Bloxdatabase:bindParam(":Parameter", "value", BloxDatabase.datatype.[your-datatype])
.
.
.

BloxDatabase:execute()

5) Fetch Data

local data = BloxDatabase:fetchAll().data
local status = BloxDatabase:fetchAll().status
local message = BloxDatabase:fetchAll().message

If you have any questions, problems or comments, you can post them in this thread.

#5

Very cool, I love seeing alternate database options, my only concern is that it relies on your presumably self hosted server actually being online. Other than that this is cool :+1:

1 Like
#6

thanks for comment I will optimize my server to reduce your worries.
Including adding a feature to
save query history to recover old data.
and creating a free and business database space.