This MEX package enables MATLAB to access SQLite databases via SQL queries. I wrote it because previous solutions did not do what I wanted in a simplistic way. The zip file below contains source code and 32-bit & 64-bit binaries for MS Windows.

Download: sqlite.zip (2.32MB)

The code was tested with SQLITE 3.11.0, MATLAB 2015b and Visual Studio Community 2015. You may need to install Visual C++ Redistributable Packages for Visual Studio 2015 from the Microsoft website to run the included MEX binaries. This program is distributed in the hope that it will be useful, but without any warranty.

db = sqlite;  % create a class object
db.version    % SQLite version
db.connect('test.db');
db.query('CREATE TABLE Test (Subject TEXT, Score INTEGER);');
db.query('INSERT INTO Test (Subject,Score) VALUES (''English'',50);');
db.query('INSERT INTO Test (Subject,Score) VALUES (?,?);','Math',90); % bind parameter
db.query('UPDATE Test SET Score=80 WHERE Subject=''English'';');
table = db.query('SELECT * from Test;');
db.query('DELETE FROM Test WHERE Score<90;');

cell_mat = { uint8('A byte stream in a cell matrix is considered a blob.') };
db.query('CREATE TABLE BinaryLargeOBject (Object BLOB);');
db.query('INSERT INTO BinaryLargeOBject (Object) VALUES (?);',cell_mat); % handle blob

clear db;  % This also disconnect DB

In order to control NI devices with Data Acquisition Toolbox in MATLAB, you first need to run MATLAB as administrator and execute the DAQREGISTER command. (See this.) However, running MATLAB as administrator is not possible, if you have to log in with a different username to be an administrator and your MATLAB activation type is Standalone Named User. MATLAB just won’t start when you switch to your admin account, because the Standalone Named User license does not allow anyone to use MATLAB but the licensed named user. You can bypass this problem by giving your non-admin MATLAB user write permission for the following two registry entries so that you can execute DAQREGISTER as a standard user. This was tested on 64-bit Windows 7 with MATLAB 2015a.

HKEY_LOCAL_MACHINE\SOFTWARE\Classes
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Classes

To change permissions for registry, you need to run REGEDIT as administrator. (Or open a command window as administrator and type REGEDIT.)