create = truefalse

True means create database if it does not exist; default is true.

readonly = truefalse

True means open database in read-only mode; default is false.

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.

$\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:\backslash Program\; Files\backslash Maple\; 2024\backslash data\backslash SQLite\backslash G20-Population.db''\right]\right)$

$\mathrm{Close}\left(\mathrm{connection}\right)$

$''SQLite\; database:\; connection\; closed''$

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

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

The Database[SQLite][Open] command was updated in Maple 2016.