open a new database connection
Open( filename, opts )
string; URI of file name of database
(optional) equation(s) of the form option = value; specify options for the Open command
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.
db ≔ FileToolsJoinPath⁡kernelopts⁡'datadir',SQLite,G20-Population.db:
connection ≔ Open⁡db
SQLite database,table⁡main=C:\Program Files\Maple 2023\data\SQLite\G20-Population.db
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.
Download Help Document