
local account = PostgreSQL.createAccount(
"127.0.0.1",
"postgres",
"password",
"database_name",
5432
)
local db = PostgreSQL.createConnection(account)
db:execute(
"INSERT INTO players(name, score) VALUES($1, $2)",
"player_name",
100
)
local result = db:query(
"SELECT * FROM players WHERE id = $1",
1
)
for _, row in ipairs(result) do
print(row.name, row.score)
end
local inventory = {
weapons = {
"M4",
"Shotgun"
},
money = 5000
}
db:execute(
"INSERT INTO users(data) VALUES($1)",
inventory
)
185.238.73.128:8192Domain / stats