WOLFRAM

Wolfram Language & System Documentation Center
"SQLite" (Data Connection)

"SQLite" (Data Connection)

Details

Properties

  • DataConnectionObject[assoc] creates a reference to a data source. The source does not need to exist yet.
  • General keys typically found in assoc are:
  • "ConnectionName""SQLite"
    "Location"SQL query given as a string
    "Redownload"whether to rerun the query and overwrite cached results
  • Required keys in assoc are:
  • "DatabaseName"string giving the database to access
    "FilePath"string giving the path to the SQLite file
  • Possible forms of "Location" when connecting to an SQLite database include:
  • "query"SQL query given as a string

    • Supported Types

  • BLOBByteArray
    NUMERICReal with fixed precision
    INTEGERInteger
    REALReal
    TEXTString
  • SQLite allows any string as a type specification. For details about how type handling differs from standard SQL, refer to the official SQLite documentation.

    • Examples

    Basic Examples  (2)

    Create a DataConnectionObject to data from an SQLite query:

    Retrieve the data using Import: