"SQLite" (.sqlite)   

Listing of Supported Databases »

Details

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

Connecting & Authenticating

The form DatabaseReference[File["path"]], where "path" is the path to an SQLite database file, is equivalent to DatabaseReference[<|"Backend""SQLite","Name""path"|>].
The form DatabaseReference[<|"Backend""SQLite"|>] represents an in-memory SQLite database, with no file backing.
In DatabaseReference[assoc], typical elements of assoc include:
"Backend" the type of SQL back end used

"Name" the path to the database

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

Create an SQLite connection using a sample database file:

The canonical form of a DatabaseReference for SQLite uses Association:

Top

Enable JavaScript to interact with content and submit forms on Wolfram websites. Learn how