Hello Vag forum members, I wanted to share a new system that I came across, I hope you like it.
Discussion about fix of this performance loss can be found
set mysql_slow_query_warning 100
oxmysql is a database wrapper for FiveM.
Calling the JS exports will result in async behaviour, or you can use the Lua exports to return a promise and await the response.
database wrapper for FiveM. Contribute to overextended/oxmysql development by creating an account on GitHub.
Overextended has 3 repositories available. Follow their code on GitHub.
Introduction
Lightweight database middleware for FXServer which utilises
Hidden link for visitors, to see
Log in or register now.
to communicate with a database and respond with the query results.Motivation
You may know that the existing wrappers (
Hidden link for visitors, to see
Log in or register now.
/
Hidden link for visitors, to see
Log in or register now.
) utilises unmaintained
Hidden link for visitors, to see
Log in or register now.
which has issue with MySQL 8`s authentication as it was never merged in this
Hidden link for visitors, to see
Log in or register now.
. and they are experiencing performance loss due to scheduling result on next tick which is about 50ms.Discussion about fix of this performance loss can be found
Hidden link for visitors, to see
Log in or register now.
.Features
- Improved performance and compatibility
- Resolves issues when using MySQL 8.0
- Returns callbacks immediately, removing up to 50ms overhead
- Lua sync wrappers utilise promises to remove additional overhead
Installation
- Download oxmysql.zip from
Hidden link for visitors, to see Log in or register now.
- Put oxmysql in the resources folder
- Configure in server.cfg
- Put ensure oxmysql before your resources
Configuration
set mysql_connection_string "mysql://user: password@host/database?charset=utf8mb4"set mysql_slow_query_warning 100
Documentation & Usage
Hidden link for visitors, to see
Log in or register now.
oxmysql is a database wrapper for FiveM.Calling the JS exports will result in async behaviour, or you can use the Lua exports to return a promise and await the response.