Category:sql

From Garry's Mod
(Difference between revisions)
Jump to: navigation, search
m
m
 
Line 1: Line 1:
 
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.
 
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.
  
GMod SQL is built with these settings:
+
Known GMod SQL settings:
<pre>SQLITE_OMIT_ATTACH = 1
+
* No ATTACH and DETACH operations (SQLITE_OMIT_ATTACH = 1)
SQLITE_OMIT_LOAD_EXTENSION = 1
+
* No Virtual Tables (SQLITE_OMIT_VIRTUALTABLE = 1)
SQLITE_OMIT_VIRTUALTABLE = 1
+
* Temp files are stored in memory (SQLITE_TEMP_STORE = 3)
SQLITE_OMIT_SHARED_CACHE = 1
+
* No VACUUM operation
SQLITE_THREADSAFE = 0
+
SQLITE_TEMP_STORE = 3</pre>
+

Latest revision as of 20:25, 6 January 2020

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.

Known GMod SQL settings:

  • No ATTACH and DETACH operations (SQLITE_OMIT_ATTACH = 1)
  • No Virtual Tables (SQLITE_OMIT_VIRTUALTABLE = 1)
  • Temp files are stored in memory (SQLITE_TEMP_STORE = 3)
  • No VACUUM operation

Pages in category "sql"

The following 8 pages are in this category, out of 8 total.

Personal tools
Navigation