Track 2 · Pro Path

Database with oxmysql: CRUD without the footguns

Almost every server you build will save state. Bans, money, garages, jobs, all of it lives in a database. oxmysql is the modern async driver the FiveM community has standardised on, and it ships from Overextended, the same group behind ox_lib and ox_inventory. This lesson builds insert, read, and update as a working resource, then walks the code line by line so you understand the mental model instead of copying it.

You'll build: A working resource named qu_oxmysql_crud that inserts a row, reads it back, and updates it, all from one command.
Time: ~25 minutes
You need: A running MariaDB database wired to oxmysql, your resources folder open, and txAdmin Live Console ready.
You'll learn: The four oxmysql helpers, what the question mark placeholders do, why await blocks the right way, and when to reach for a database at all.

BEFORE YOU START

Build it

Make the resource folder

The server has one folder for this lesson.

Inside your server's resources folder, create this folder:

code

resources/qu_oxmysql_crud

Create the files

Every file named in the manifest exists.

Database with oxmysql: CRUD without the footguns

Build it

Make the resource folder

Create the files

Write fxmanifest.lua

Write the lesson code

Start and test it

See your write land in HeidiSQL

Keep reading the full lesson

id	name	amount
1	lesson	150
2	lesson	150