"SQLite" (.sqlite)

Listing of Supported Databases »

Details

  • SQLite is a relational database management system contained in a C programming library. SQLite is not a clientserver database engine, it is embedded into the end program.

Connecting & Authenticating

  • When configuring SQLite using DatabaseReference[File["path"]], "path" is the location of the database file.
  • In DatabaseReference[assoc], typical elements of assoc include:
  • "Backend"the type of SQL backend used
    "Name"the path to the database

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  (1)

Create an SQLite connection using the File wrapper:

The canonical form of a DatabaseReference for SQLite uses Association:

Introduced in 2020
 (12.1)