Open - Maple Help

Database[SQLite]

 Open
 open a new database connection

 Calling Sequence Open( filename, opts )

Parameters

 filename - string; URI of file name of database opts - (optional) equation(s) of the form option = value; specify options for the Open command

Options

 • create = truefalse
 True means create database if it does not exist; default is true.
 True means open database in read-only mode; default is false.

Description

 • The Open command opens a new database connection.
 • The filename parameter specifies the database.
 – If it is ":memory:", then a private, temporary, in-memory database is created for the connection. This in-memory database will vanish when the database connection is closed.
 – If it is an empty string, then a private, temporary, on-disk database will be created. This private database will be automatically deleted as soon as the database connection is closed.
 • The Open command can open an existing database from Workbook if the filename is a valid Workbook URI.

Examples

 > $\mathrm{with}\left(\mathrm{Database}\left[\mathrm{SQLite}\right]\right):$
 > $\mathrm{db}≔\mathrm{FileTools}\left[\mathrm{JoinPath}\right]\left(\left[\mathrm{kernelopts}\left('\mathrm{datadir}'\right),"SQLite","G20-Population.db"\right]\right):$
 > $\mathrm{connection}≔\mathrm{Open}\left(\mathrm{db}\right)$
 ${"SQLite database"}{,}{table}{}\left(\left[{"main"}{=}{"C:\Program Files\Maple 2021\data\SQLite\G20-Population.db"}\right]\right)$ (1)
 > $\mathrm{Close}\left(\mathrm{connection}\right)$
 ${"SQLite database: connection closed"}$ (2)

Compatibility

 • The Database[SQLite][Open] command was introduced in Maple 18.