"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

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: