Online Help

SQLite is a database file format associated with the SQLite relational database management system. It is widely used as an embedded database format for client-based storage in web browsers and other desktop programs.

The Database[SQLite] subpackage can read and write archive files in this format.

Content-Type: application/x-sqlite3

$\mathrm{with}\left(\mathrm{Database}\left[\mathrm{SQLite}\right]\right)$

$\left[\mathrm{Attach}\,\mathrm{Bind}\,\mathrm{ClearBindings}\,\mathrm{Close}\,\mathrm{ColumnCount}\,\mathrm{ColumnNames}\,\mathrm{Execute}\,\mathrm{Fetch}\,\mathrm{FetchAll}\,\mathrm{FetchRow}\,\mathrm{Finalize}\,\mathrm{Open}\,\mathrm{Opened}\,\mathrm{Prepare}\,\mathrm{RESULT\_BUSY}\,\mathrm{RESULT\_DONE}\,\mathrm{RESULT\_ROW}\,\mathrm{Reset}\,\mathrm{Step}\right]$

$\mathrm{db}≔\mathrm{FileTools}\left[\mathrm{JoinPath}\right]\left(\left[''SQLite''\,''G20-Population.db''\right]\,\mathrm{base}=\mathrm{datadir}\right)$

$''C:\backslash Program\; Files\backslash Maple\; 2016\backslash data\backslash SQLite\backslash G20-Population.db''$

$\mathrm{connection}≔\mathrm{Open}\left(\mathrm{db}\right)$

$''SQLite\; database'',table\left(\left[''main''=''C:\backslash Program\; Files\backslash Maple\; 202\backslash data\backslash SQLite\backslash G20-Population.db''\right]\right)$