oxmysql
A FiveM resource to communicate with a MySQL database using node-mysql2.
📚 Documentation
https://overextended.dev/oxmysql
💾 Download
https://github.com/overextended/oxmysql/releases/latest/download/oxmysql.zip
✨ Features
- 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.
npm Package
https://www.npmjs.com/package/@overextended/oxmysql
Lua Language Server
- 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"