The SQLite 3 API provides making prepared statements, managing backups, working with shared caches and providing mutexes to implement multi threading. The current implementation at some well known multiplayer mod misses a lot of useful features. So that is why I want propose additional natives for the database API.
-
SQLite:SQLite_Open(const path[], SQLiteOpenMode:openModeFlags)
:Open a SQLite database with support for file open mode flags and opening databases in a shared cache mode -
SQLite:SQLite_OpenLegacy(const path[])
: This function exists to be compatible withdb_open
-
SQLite_Close(SQLite:database)
: Closes a SQLite database (db_close
) -
SQLite_CloseAll
: Closes all SQLite databases -
SQLite_CreateStatement(SQLite:database, const sql[])
: Creates a prepared statement -
SQLiteStatement:SQLite_CreateStatementThreaded(SQLite:database, const sql[], const callback[])
: Creates a prepared statement in another thread - `SQLite_DestroyStatement(SQLiteStatement:statement