"SQLite" (.sqlite)
"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
Examples
Basic Examples (1)
Create an SQLite connection using a sample database file:
The canonical form of a DatabaseReference for SQLite uses Association :
History
Introduced in 2020 (12.1)