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
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 thesqlwrite
function.
Execute Database Operations
- Create Table and Add Column in SQLite Database
Manage SQLite database structures using theCREATE
andALTER
SQL statements. - Delete Data from SQLite Database
Delete data from an SQLite database using MATLAB. - Roll Back Data in SQLite Database
Execute theROLLBACK
SQL statement to reverse changes in an SQLite database by using theexecute
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.