For all those are intersted in my project. It is an embedded SQLite databases with capabilities to connect to an external MySQL database, realised via DLLBind.
Download last release: SQLProject3102.zip (version: 3.1.0.2)
Download sources: DLLBindProjects.zip (version: 3.1.0.2)
Sources are available under the NewBSD license.
Download older releases:
- SQLProject3101.zip (version: 3.1.0.1)
- SQLProject2010.zip (version: 2.0.1.0)
- SQLProject1051.zip (version: 1.0.5.1)
The zipped release packages contains a small example how to use the interface functions.
Core features:
- Common statement syntax from SQLite including prepared statements, savepoints, transactions, rollbacks (see http://www.sqlite.org for further informations)
- Multiple databases in memory
- Load database from file into memory
- Save database from memory to file
- Supported types on UScript side: int, float, string
Note: Please check out READ_ME_FIRST.txt before usage
CHANGELOG:
Version 3.1.0.1 to 3.1.0.2:
- Fixed MySQL Driver Bugs (thx to Dan Cowell)
Version 2.0.1.3 to 3.1.0.1:
- Added MySQL Driver, allows connection to a remote database (need to be open for remote access)
- Huge refactoring, older code won't compile with this version due to function signature changes
- Adding DataProviders to make lot of things easier
- Handling multiple result sets
- Added function wrappers in DB_DLLAPI allowing to have multiple database drivers instantiate (for example if you want to
connect to 2 different MySQL databases on 2 different servers)
- Various new functions for general table management:
- untested: 128-bit TEA file encryption
- MD5 Hash implementation
Version 2.0.1.2 to 2.0.1.3:
- Hotfix: Crash when restarting map PIE
Version 2.0.1.0 to 2.0.1.2:
- Fixed directoryDeletion using IO_DeleteDirectory
Version 2.0.0.0 to 2.0.1.0:
- Added additional function to get last inserted row of selected database:
Version 1.0.5.1 to 2.0.0.0:
- Release under NewBSD license
Version 1.0.5.0 to 1.0.5.1:
- Added additional function to access query result values:
Version 1.0.4.0 to 1.0.5.0:
- Added function for directory and file access:
Kind regards,
BlackHornet
Download last release: SQLProject3102.zip (version: 3.1.0.2)
Download sources: DLLBindProjects.zip (version: 3.1.0.2)
Sources are available under the NewBSD license.
Download older releases:
- SQLProject3101.zip (version: 3.1.0.1)
- SQLProject2010.zip (version: 2.0.1.0)
- SQLProject1051.zip (version: 1.0.5.1)
The zipped release packages contains a small example how to use the interface functions.
Core features:
- Common statement syntax from SQLite including prepared statements, savepoints, transactions, rollbacks (see http://www.sqlite.org for further informations)
- Multiple databases in memory
- Load database from file into memory
- Save database from memory to file
- Supported types on UScript side: int, float, string
Note: Please check out READ_ME_FIRST.txt before usage
CHANGELOG:
Version 3.1.0.1 to 3.1.0.2:
- Fixed MySQL Driver Bugs (thx to Dan Cowell)
Version 2.0.1.3 to 3.1.0.1:
- Added MySQL Driver, allows connection to a remote database (need to be open for remote access)
- Huge refactoring, older code won't compile with this version due to function signature changes
- Adding DataProviders to make lot of things easier
- Handling multiple result sets
- Added function wrappers in DB_DLLAPI allowing to have multiple database drivers instantiate (for example if you want to
connect to 2 different MySQL databases on 2 different servers)
- Various new functions for general table management:
dllimport final function int SQL_getTableCount();
dllimport final function SQL_getTableName(int aTableIdx, string aValue);
dllimport final function int SQL_getColumnCount(int aResultIdx);
dllimport final function SQL_getColumnInfo(int aResultIdx, int aColumnIdx, out string aColumnName, out int aColumnType, out int aColumnDetail);
- untested: 128-bit TEA file encryption
- MD5 Hash implementation
Version 2.0.1.2 to 2.0.1.3:
- Hotfix: Crash when restarting map PIE
Version 2.0.1.0 to 2.0.1.2:
- Fixed directoryDeletion using IO_DeleteDirectory
Version 2.0.0.0 to 2.0.1.0:
- Added additional function to get last inserted row of selected database:
int SQL_lastInsertID();
Version 1.0.5.1 to 2.0.0.0:
- Release under NewBSD license
Version 1.0.5.0 to 1.0.5.1:
- Added additional function to access query result values:
SQL_getIntVal(string aParamName, out int aValue);
SQL_getFloatVal(string aParamName, out float aValue);
SQL_getStringVal(string aParamName, out string aValue);
All these functions work on the column name of a result defined my the query expression (aParamName is case in-sensitive).
- Previous getter functions are still available but marked as deprecated, being removed in a future release.Version 1.0.4.0 to 1.0.5.0:
- Added function for directory and file access:
bool IO_directoryExists(string aDirectoryPath);
Return true if given path is a valid directory.
Return true if given path is a valid directory.
bool IO_createDirectory(string aDirectoryPath);Return true if for given path a directory is created successfully.
bool IO_deleteDirectory(string aDirectoryPath, int aRecursive);
If aRecursiv is 1, all subdirectories and containing files will be removed to, regardless of read-only file attribute.
Return true if deletion of given path was successful.
If aRecursiv is 1, all subdirectories and containing files will be removed to, regardless of read-only file attribute.
Return true if deletion of given path was successful.
bool IO_fileExists(string aFilePath);
Return true if given path is a valid file.
Return true if given path is a valid file.
bool IO_deleteFile(string aFilePath);
Return true if given file was successfully removed.
Return true if given file was successfully removed.
Kind regards,
BlackHornet
Comment