SQLITE database access for GNU Octave
This is a basic sqlite toolkit using and interface similar to the Matlab Native SQLITE interface.
It provides functionality for the following functions:
- sqlite - create a sqlite database connection
- close - close a sqlite database connection
- fetch - fetch data from a connection using sql
- execute - execute a non selecting sql statement
- sqlread - read a sqlite table
- sqlwrite - write to a sqlite table
- commit - commit transaction when not in autocommit mode
- rollback - rollback a transaction when not in autocommit mode
- isopen - verify the database is open
The toolkit can be installed in Octave 6.0 and greater. It has a dependency on the SQLITE library (https://www.sqlite.org/), so it must be installed in order to successfully install the toolkit.
The toolkit can be installed in Octave 7.2+ using the command:
pkg install -forge sqlite
On older versions of Octave, install the package using the full path to the latest released version:
pkg install "https://github.com/gnu-octave/octave-sqlite/releases/v0.0.1/octave-sqlite-0.0.1.tar.gz"
After installation, load the package in order to use it.
pkg load sqlite
Note: The package needs to loaded each time Octave is run in order to use the package.
On newer versions of Octave, on loading the package the documentation will be available in the Octave documentation pages.
The Documentation is also installed as a pdf in the installed package folder.
An online summary of the documentation is also available at https://github.com/gnu-octave/octave-sqlite/wiki/Octave-SQLITE-Toolkit
Bugs can be filed on the issue tracker.