MATLAB Interface to SQLite

Interact with an SQLite database using the MATLAB^® interface to SQLite

Without installing a database, configuring a driver, or creating a data source, connect to an SQLite database, create database tables, and load data into the tables. Import data into MATLAB from the SQLite database. Export data from MATLAB into the SQLite database. Then, create a standalone SQLite database application and deploy it.

Objects

sqlite SQLite connection

Functions

expand all

SQLite Database Connection

`close`	Close SQLite connection
`isopen`	Determine if SQLite connection is open (Since R2022a)

Import Data into MATLAB

`fetch`	Import data into MATLAB workspace using SQLite connection
`sqlread`	Import data into MATLAB from SQLite database table (Since R2022a)

Customize Options for Data Import from Database

databaseImportOptions Define import options for database data

Export Data from MATLAB

sqlwrite Insert MATLAB data into SQLite database table (Since R2022a)

Database Operations

`commit`	Make changes to SQLite database file permanent (Since R2022a)
`execute`	Execute SQL statement using SQLite database connection (Since R2022a)
`rollback`	Undo changes to SQLite database file (Since R2022a)
`sqlupdate`	Update rows in SQLite database table (Since R2023a)

Topics

MATLAB Interface to SQLite Workflow

Interact with Data in SQLite Database Using MATLAB Interface to SQLite
Analyze data without access to a database or driver by using the MATLAB interface to SQLite.

Import Data into MATLAB

Import Data Using MATLAB Interface to SQLite
Load data from MAT-files into an SQLite database without additional installation or configuration.

Export Data from MATLAB

Insert Data into SQLite Database Table
Perform calculations on data and insert the results into an SQLite database using the sqlwrite function.

Execute Database Operations

Create Table and Add Column in SQLite Database
Manage SQLite database structures using the CREATE and ALTER SQL statements.
Delete Data from SQLite Database
Delete data from an SQLite database using MATLAB.
Roll Back Data in SQLite Database
Execute the ROLLBACK SQL statement to reverse changes in an SQLite database by using the execute function.

Deploy Standalone Database Application

Deploy MATLAB Interface to SQLite Database Application with MATLAB Compiler
Write a MATLAB script that connects to an SQLite database and deploy the script as a standalone database application to other machines.