In R2018b and later, the data exploration buttons (zoom in, zoom out, etc.) were moved from the figure toolbar to the axes toolbar. I use those buttons all the time, so this change is really annoying. What is relieving is that you can use the addToolbarExplorationButtons and removeToolbarExplorationButtons functions to bring the buttons back to the figure toolbar.

fig = figure;
surf(peaks);

addToolbarExplorationButtons(fig);     % add zoom buttons to the figure toolbar
removeToolbarExplorationButtons(fig);  % Remove the buttons from the figure toolbar

The functions work for the specified figure only. If you want to open all figures with the data exploration buttons, put the following code in the startup.m

set(groot,'defaultFigureCreateFcn',@(fig,~)addToolbarExplorationButtons(fig));
set(groot,'defaultAxesCreateFcn',@(ax,~)set(ax.Toolbar,'Visible','off'));

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.)