Using a DB

[LouisDB]

Hi,

I'm gonna make a subgame that will be used for a (hopefully) big server on a Linux machine.
What type of database should I use to record persistent data ?
I want to be able to read it to display infos on a website and I don't care about portability since the server will run only on Linux.
I already know MySQL/MariaDB a bit.

Any suggestions ?
Thanks in advance :)

[LouisDB]

Any ideas?

[Byakuren]

Why not just use an SQL DBMS since you're already comfortable with it?

[LouisDB]

Yeah sure, can I use this : https://keplerproject.github.io/luasql/ ... #compiling ?

[rubenwardy]

tip: to require in mod security, you should use this code:

Your phone or window isn't wide enough to display the code box. If it's a phone, try rotating it to landscape mode.

Code: Select all

local env = _G
if minetest.request_insecure_environment then
    env = assert(minetest.request_insecure_environment(), "Please add <modname> to trusted mods")
end
local luasql = env.require("luasql")


[LouisDB]

Noted. Thanks

[Xudo]

I think that best option to store minetest world is noSql database like cassandra.
You need fast insert and select of blocks of data and don't really need transaction handling and table relations.

[LouisDB]

It's not to store the world. It's for mods persistent information. Especially teams and plots.
What's the point of saving the world in a DB?

[Xudo]

In this case it is better to use anything simple for a quick start. If storing data in files is easier than compiling luasql, then use files. Minetest already provides you (de)serialization functions.

[LouisDB]

Using sql is not a problem and I need to be able to access the DB with php.