The SQL library allows you to access powerful database software included with Garry's Mod. It is the preferred and fastest method of storing large amounts of data. The database is located in sv.db serverside and cl.db clientside, both in the Garry's Mod base folder. SQL is a whole scripting language in itself although relatively simple, it's something you'll need to read up on before using this library.
For setup, complete steps:
- Download the latest module for your server's operating system and architecture using the links from this page: https://github.com/FredyH/MySQLOO (most often required gmsv_mysqloo_win32.dll).
- Download zip and copy catalog
luafrom archive to
addons/darkrpmodification/lua/darkrp_configand set need parameters in
Known GMod SQL settings:
SQLITE_OMIT_ATTACH = 1)
- No Virtual Tables (
SQLITE_OMIT_VIRTUALTABLE = 1)
- Temp files are stored in memory (
SQLITE_TEMP_STORE = 3)