Database - Maple Programming Help

Online Help

All Products    Maple    MapleSim


Home : Support : Online Help : Connectivity : Database Package : SQLite : Database/SQLite

Database

  

SQLite

 

Calling Sequence

Description

List of Database[SQLite] Package Commands

Data Types

Compatibility

Calling Sequence

Database[SQLite][command](arguments)

command(arguments)

Description

• 

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.

List of Database[SQLite] Package Commands

Attach

Bind

ClearBindings

Close

ColumnCount

ColumnNames

Execute

Fetch

FetchAll

FetchRow

Finalize

Open

Opened

Prepare

Reset

Step

Data Types

• 

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 Maple integers are stored as integers in SQLite table and read back as integers.

Compatibility

• 

The Database[SQLite] package was introduced in Maple 18.

• 

For more information on Maple 18 changes, see Updates in Maple 18.