Upcoming new release 1.13 offers BLOB accessibility. Multidimensional arrays
can easily stored and restored from workspace...
Examples (MATLAB scripts) and Binaries for Windows and Linux included.
- SQLite Engine updated to Version 3.7.17
- Strict field names: Only alphanumeric chars and '_' are allowed
- Parameter binding extension
- Tiny exception handling implementation
- Introducing "typed BLOBs"
Behaviour can be changed by switch mksqlite('typedBLOBs', 0|1)
(Default is OFF)
- Added two new commands:
mksqlite('version mex'): Returns the release version of mksqlite
mksqlite('version sql'): Returns the version of the used SQLite engine
- Added two SQL functions:
* pow(x,y): power function x**y
* regex(str,pattern,<repstr>): Regular expression pattern on str, replacements
by optional parameter repstr definition.
(Based on DEELX V1.2 Rev.863, see www.regexlab.com)
Including example file "test_regex.m"
- Bugfix: matlab crash when no arguments passed to mksqlite
- Insertion of svn revision number into source code for linux too, now
- Switch to return NULL as NaN applied: mksqlite('NullAsNaN', 0|1)
(Default is OFF)
You can use mksqlite like any other M-Script command:
dbid = mksqlite([dbid, ] SQLQuery [, Argument])
The parameter dbid is optional and is needed only if you want
to use several data bases at the same time. If dbid was omitted,
then the data base id 1 is used.
dbid = mksqlite(0, 'open', 'databasefile')
Opens the database "databasefile". If there is no such database, then it will
be created. If you use the db-id of an already opened database, than this db will be
closed first. If you use the db-id 0, then the next free db.id will be
used and returned by the function call.
Closes the databasefile. If you use dbid 0, then all databases will be closed.
Executes the Query and returns the results..
Parametric SQL queries are possible too, by now. You can use the
command "mksqlite" to benefit from all features of SQLite. Simply issue
the command "mksqlite('SELECT * FROM database')" and you get an array of
structures with the results of the query.
More help you get from function help...
Get the always recent version via subversion:
svn checkout svn://svn.berlios.de/mksqlite/trunk