Overview of the Database:-SQLite Package
Calling Sequence
Description
List of Database:-SQLite Package Commands
Data Types
Compatibility
Database:-SQLite:-command(arguments)
command(arguments)
The SQLite package provides access to SQLite databases.
SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.
Attach
attach a new database to the opened connection
Bind
bind value to a parameter in a prepared SQL statement
ClearBindings
reset bindings in a prepared SQL statement
Close
close database connection
ColumnCount
get number of columns in a prepared statement
ColumnNames
get names of columns in a prepared statement
Execute
execute SQL statement
Fetch
fetch value of a single column from a prepared SQL statement
FetchAll
fetch all rows from a prepared SQL statement
FetchRow
fetch row from a prepared SQL statement
Finalize
finalize a prepared SQL statement
Open
open a new database connection
Opened
list opened databases
Prepare
prepare an SQL statement
Reset
reset a prepared SQL statement
Step
evaluate a prepared SQL statement
The following data types are supported
SQLite
Maple
valuetype option
BLOB
rtable with datatype=integer[1], order=C_order
"blob"
FLOAT
HFloat
"float"
INTEGER
integer[8]
"integer"
TEXT
string
"text"
When valuetype option is set to "auto", types are automatically mapped between Maple and SQLite based on the above table, so that, for example, Maple integers are stored as integers in the SQLite table and read back as integers.
The Database[SQLite] package was introduced in Maple 18.
For more information on Maple 18 changes, see Updates in Maple 18.
See Also
Database
Download Help Document
