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