sqlite3

Version 3.1.0.0 (4.36 MB) by Rik
Matlab and Octave interface to the SQLite engine.
607 Downloads
Updated 14 Jun 2023

View sqlite3 on File Exchange

This function is a wrapper for a mex interface. The mex files were compiled for most operating systems for Matlab. For Octave an internal function will download the source files and compile it (or copy them if you download this as a zip), since the resulting mex files are less portable than Matlab mex files.

The CLI is removed from this version, but may be back in a future update. When it is back, the CLI may have inconsistent effects across different operating systems. The test suite will only test basic functionality for the CLI.

Sources:
The basis for the interface is the SQLite3 project itself. The sqlite3.c and sqlite3.h files can be downloaded from an archived zip file here. The originals for sqlite3_interface.c, structlist.c, and structlist.h can be found on GitHub. These 3 files were edited to make them conform to the stricter standards of older compilers and to remove a message: mexPrintf("binding params %d of %zu\n", i, mxGetM(params)); The files were further edited to deal with column names that are not valid Matlab field names and to make sure the database file is closed whenever an error occurs. Additionally a converter file was written to deal with UTF-16 char encoding.

Licence: CC by-nc-sa 4.0

Cite As

Rik (2024). sqlite3 (https://github.com/thrynae/sqlite3/releases/tag/v3.1.0), GitHub. Retrieved .

MATLAB Release Compatibility
Created with R2021b
Compatible with R13SP1 and later releases
Platform Compatibility
Windows macOS Linux

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!
Version Published Release Notes
3.1.0.0

See release notes for this release on GitHub: https://github.com/thrynae/sqlite3/releases/tag/v3.1.0

3.0.0

See release notes for this release on GitHub: https://github.com/thrynae/sqlite3/releases/tag/v3.0.0

2.0

See release notes for this release on GitHub: https://github.com/thrynae/sqlite3/releases/tag/2.0

1.0.0

To view or report issues in this GitHub add-on, visit the GitHub Repository.
To view or report issues in this GitHub add-on, visit the GitHub Repository.