Interact with Data in SQLite Database Using MATLAB Interface to SQLite - MATLAB & Simulink - MathWorks Australia

Interact with Data in SQLite Database UsingMATLABInterface to SQLite

To analyze your data using SQL in MATLAB^®without access to any database or driver, use the MATLAB interface to SQLite. After installing Database Toolbox™, you can use the MATLAB interface to SQLite to move data between MATLAB and an SQLite database file. For details, seeMATLAB Interface to SQLite. The SQLite connection is different from a database connection created using a JDBC driver. For background information about SQLite databases, see theSQLite Home Page.

MATLABInterface to SQLite Advantages

With the MATLAB interface to SQLite, you can start working with data immediately after installing the Database Toolbox by creating an SQLite database file. No installation or administration of software or drivers required. You can share data using SQLite database files. Also, you can deploy a standalone database application without additional installation or configuration on target machines. The MATLAB interface to SQLite supports Windows^®, Linux^®, andMac.

MATLABInterface to SQLite Workflow

To connect to a database quickly and import data, use the MATLAB interface to SQLite. These steps provide a high-level workflow for using the MATLAB interface to SQLite.

Create an SQLite database file by usingsqlite. The SQLite database file has a.dbextension. Thesqliteobject signifies an SQLite database connection.
Create tables in the SQLite database file by usingexecute.
Export your data into the SQLite database file by usingsqlwrite.
Import data into MATLAB by usingsqlreadorfetch.
Perform data analysis in MATLAB.
Export results into the SQLite database file by usingsqlwrite.
Close the SQLite connection by usingclose.
与他人分享SQLite数据库文件。
Create a standalone SQLite database application and deploy it.

SQLite JDBC Connection Differences

下表描述了区别een using the MATLAB interface to SQLite and using the JDBC driver to connect to an SQLite database.

Item	SQLite Connection Using the MATLAB Interface to SQLite	SQLite Database Connection Using a JDBC Driver
Driver installation	Not required	Required
Database installation	Not required	Required
Database administration	Not required	Required
Database connection function	`sqlite`	`database`
Import data	Yes	Yes
Export data	Yes	Yes
Database operations	Yes	Yes
Database Explorer	No	Yes
Database metadata	No	Yes
Complex functionality	No	Yes

MATLABInterface to SQLite Limitations

The limitations of using the MATLAB interface to SQLite are:

NULLvalues are not supported as the first value in any column.
Database import options are not supported.
Database Explorer is not supported. Use the command line.

External Websites

SQLite Home Page