Details

Use DataConnectionObject to represent data located in an SQLite database in Wolfram Language.
Import can be used to retrieve data from a DataConnectionObject .
RelationalDatabase can be used to represent the schema of an "SQLite" database.

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

BLOB ByteArray

NUMERIC Real with fixed precision

INTEGER Integer

REAL Real

TEXT String

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:

Wolfram Language code:

DataConnectionObject[
	<|"ConnectionName" -> "SQLite", "FilePath" -> FindFile["ExampleData/ecommerce-database.sqlite"], "Location" -> "SELECT * FROM customers"|>]

Retrieve the data using Import :

Wolfram Language code:

Import@DataConnectionObject[
	<|"ConnectionName" -> "SQLite", "FilePath" -> FindFile["ExampleData/ecommerce-database.sqlite"], "Location" -> "SELECT * FROM customers"|>]