MATLAB Interface to SQLite - MATLAB & Simulink (original) (raw)

Main Content

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

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

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

Execute Database Operations

Create Table and Add Column in SQLite Database
Manage SQLite database structures using the CREATE andALTER 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.