Track 2 · Pro Path

Persistence: cache + write-back

Reading from the database on every action is slow. Writing on every action floods your database and locks tables. The fix is the cache plus write-back pattern: keep player state in RAM, mark it dirty when it changes, flush on a timer, and flush again on disconnect and on shutdown so a restart never costs you the last few seconds. This is how every well-built FiveM economy survives a 64-player night.

You'll learn: In-memory cache, dirty flags, periodic flush, playerDropped save, txAdmin graceful shutdown
Time: ~24 minutes
Prereqs: P1 (oxmysql), P4 (promises)
Outcome: A wallet that updates 1000 times per minute in-memory and writes to the database at most once every 30 seconds, without losing data on disconnect or restart

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_persistence

Create the files

Every file named in the manifest exists.

Create this exact file layout:

code

resources/qu_persistence/
fxmanifest.lua
server.lua

Persistence: cache + write-back

Build it

Make the resource folder

Create the files

Write fxmanifest.lua

Write the lesson code

Start and test it

Keep reading the full lesson