SQLite - Maple Help

SQLite (.db) File Format

SQLite file format

Description

 • 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.

Notes

 • Content-Type: application/x-sqlite3

Examples

 > $\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]$ (1)
 > $\mathrm{db}≔\mathrm{FileTools}\left[\mathrm{JoinPath}\right]\left(\left["SQLite","G20-Population.db"\right],\mathrm{base}=\mathrm{datadir}\right)$
 ${"C:\Program Files\Maple 2016\data\SQLite\G20-Population.db"}$ (2)
 > $\mathrm{connection}≔\mathrm{Open}\left(\mathrm{db}\right)$
 ${"SQLite database"}{,}{table}{}\left(\left[{"main"}{=}{"C:\Program Files\Maple 202\data\SQLite\G20-Population.db"}\right]\right)$ (3)