SQLite databases can be created and edited with the functions described here. SQLite is a public domain SQL database embedded in UniPlot. More information can be found at http://www.sqlite.org.
More information at SQLite (SQL).
| sqlite Functions | |
|---|---|
| sqlite_busy_timeout | sqlite_busy_timeout sets the time limit to open a locked SQLite database. |
| sqlite_close | sqlite_close closes the open SQLite database. |
| sqlite_execute | sqlite_execute executes an SQL command. |
| sqlite_last_insert_rowid | sqlite_last_insert_rowid returns the integer primary key of the last INSERT command. |
| sqlite_libencoding | sqlite_libencoding returns the SQLite database string coding. In this version it returns iso8859. |
| sqlite_libversion | sqlite_libversion returns the SQLite library version. |
| sqlite_open | sqlite_open opens an SQLite database. If the database does not exist it will be created. |
Documentation for SQLite 3, see http://sqlite.org/docs.html.
| sqlite3 Functions | |
|---|---|
| sqlite3_busy_timeout | sqlite3_busy_timeout sets the time limit to open a locked SQLite database. |
| sqlite3_close | sqlite3_close closes the open SQLite database. |
| sqlite3_execute | sqlite3_execute executes an SQL command. |
| sqlite3_last_insert_rowid | sqlite3_last_insert_rowid returns the integer primary key of the last INSERT command. |
| sqlite3_libencoding | sqlite3_libencoding returns the SQLite database string coding. In this version it returns utf-8. |
| sqlite3_libversion | sqlite3_libversion returns the SQLite library version. |
| sqlite3_open | sqlite3_open opens an SQLite database. If the database does not exist it will be created. |
See also
Overview PostgreSQL, Overview Files, Overview UniPlot Data Files, Overview Binary and Text Files, UniScript Functions Overview
id-276952