A FiveM resource to communicate with a MySQL database using node-mysql2.
https://overextended.dev/oxmysql
https://github.com/overextended/oxmysql/releases/latest/download/oxmysql.zip
- Support for mysql-async and ghmattimysql syntax.
- Promises / async query handling allowing for non-blocking and awaitable responses.
- Improved performance and stability compared to other options.
- Support for named and unnamed placeholders, improving performance and security.
- Support for URI connection strings and semicolon separated values.
- Improved parameter checking and error handling.
https://www.npmjs.com/package/@overextended/oxmysql
- Install Lua Language Server to ease development with annotations, type checking, diagnostics, and more.
- Install cfxlua-vscode to add natives and cfxlua runtime declarations to LLS.
- You can load oxmysql into your global development environment by modifying workspace/user settings "Lua.workspace.library" with the resource path.
- e.g. "c:\fxserver\resources\oxmysql\lib\define.lua"