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 database connection
`isopen`	Determine if database connection is open

Import Data into MATLAB

`sqlread`	Import data into MATLAB from SQLite database table (Since R2022a)
`fetch`	Import data from execution of SQL statement

Customize Options for Data Import from Database

databaseImportOptions Define import options for database data

Export Data from MATLAB

sqlwrite Insert MATLAB data into database table

Database Operations

`commit`	Make changes to database permanent
`execute`	Execute SQL statement on database
`rollback`	Revert changes made to database
`sqlupdate`	Update rows in 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.