> For the complete documentation index, see [llms.txt](https://orkhan.gitbook.io/typeorm/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://orkhan.gitbook.io/typeorm/docs/docs/drivers/sqlite.md).

# SQLite

## Installation

* for **Better SQLite**:

```shell
npm install better-sqlite3
```

* for **sql.js**:

```shell
npm install sql.js
```

* for **Capacitor**, **Cordova**, **Expo**, **NativeScript** and **React Native**, check the [supported platforms](/typeorm/docs/docs/help/2-supported-platforms.md).

## Data Source Options

See [Data Source Options](/typeorm/docs/docs/data-source/2-data-source-options.md) for the common data source options.

### `better-sqlite3` data source options

* `database` - Database path. For example, `"mydb.sqlite"`.
* `enableWAL` - Enables WAL mode (default `false`). See [SQLite WAL mode](https://www.sqlite.org/wal.html).
* `fileMustExist` - If the database does not exist, an Error will be thrown instead of creating a new file. Does not affect in-memory or readonly connections (default `false`).
* `key` - Encryption key for SQLCipher.
* `nativeBinding` - Relative or absolute path to the native addon (`better_sqlite3.node`).
* `prepareDatabase` - Function to run before a database is used in typeorm. You can access the original better-sqlite3 Database object here.
* `readonly` - Open the database connection in readonly mode (default `false`).
* `statementCacheSize` - Cache size of the SQLite statement to speed up queries (default `100`).
* `timeout` - The number of milliseconds to wait when executing queries on a locked database, before throwing a SQLITE\_BUSY error (default `5000`).
* `verbose` - A function that gets called with every SQL string executed by the database connection.

### `sql.js` data source options

* `database`: The raw UInt8Array database that should be imported.
* `sqlJsConfig`: Optional initialize config for sql.js.
* `autoSave`: Enable automatic persistence of database changes, requires either `location` or `autoSaveCallback`. When set to `true`, every change is saved to the file system (Node.js) or to `localStorage`/`indexedDB` (browser) if `location` is specified, or the `autoSaveCallback` is invoked otherwise.
* `autoSaveCallback`: A function that gets called when changes to the database are made and `autoSave` is enabled. The function gets a `UInt8Array` that represents the database.
* `location`: The file location to load and save the database to.
* `useLocalForage`: Enables the usage of the [localforage library](https://github.com/localForage/localForage) to save and load the database asynchronously from the indexedDB instead of using the synchrony local storage methods in a browser environment. The localforage node module needs to be added to your project, and the localforage.js should be imported in your page.

### `capacitor` data source options

* `database` - Database name (capacitor-sqlite will add the suffix `SQLite.db`)
* `driver` - The capacitor-sqlite instance. For example, `new SQLiteConnection(CapacitorSQLite)`.
* `mode` - Set the mode for database encryption: "no-encryption" | "encryption" | "secret" | "newsecret"
* `version` - Database version
* `journalMode` - The SQLite journal mode (optional)

### `cordova` data source options

* `database` - Database name
* `location` - Where to save the database. See [cordova-sqlite-storage](https://github.com/litehelpers/Cordova-sqlite-storage#opening-a-database) for options.

### `expo` data source options

* `database` - Name of the database. For example, "mydb".
* `driver` - The Expo SQLite module. Optional — TypeORM loads `expo-sqlite` automatically. Pass explicitly only when you need a custom instance (for example, a patched fork).

### `nativescript` data source options

* `database` - Database name

### `react-native` data source options

* `database` - Database name
* `location` - Where to save the database. See [react-native-sqlite-storage](https://github.com/andpor/react-native-sqlite-storage#opening-a-database) for options.

## Column Types

`int`, `int2`, `int8`, `integer`, `tinyint`, `smallint`, `mediumint`, `bigint`, `decimal`, `numeric`, `float`, `double`, `real`, `double precision`, `datetime`, `varying character`, `character`, `native character`, `varchar`, `nchar`, `nvarchar2`, `unsigned big int`, `boolean`, `blob`, `text`, `clob`, `date`, `json`, `jsonb`

TypeORM supports both `json` and `jsonb` types in SQLite:

* `json` is stored as `TEXT`.
* `jsonb` is stored as SQLite's binary JSON format. TypeORM automatically wraps values with the `jsonb()` function during persistence and with the `json()` function during retrieval for transparent support and better performance.

JSONB support requires SQLite 3.45.0 or newer. When using the `jsonb` column type, TypeORM will use the `jsonb` type in your database schema, which SQLite handles as a binary `BLOB` internally.