---
title: Write to SQLite
description: Use sql.to() with the sqlite3 driver to write data to SQLite.
url: https://docs.influxdata.com/flux/v0/write-data/sql/sqlite/
estimated_tokens: 528
product: Flux
version: v0
publisher: InfluxData
canonical: https://docs.influxdata.com/flux/v0/write-data/sql/sqlite/
date: '2023-09-12T23:33:31-06:00'
lastmod: '2023-09-12T23:33:31-06:00'
---

To write data to [SQLite](https://www.sqlite.org/index.html) with Flux:

1. Import the [`sql` package](/flux/v0/stdlib/sql/).

2. Pipe-forward data into [`sql.to()`](/flux/v0/stdlib/sql/to/) and provide
   the following parameters:

   * **driverName**: sqlite3
   * **dataSourceName**: *See [data source name](#sqlite-data-source-name)*
   * **table**: Table to write to
   * **batchSize**: Number of parameters or columns that can be queued within
     each call to `Exec` (set to `999` or less)

```js
import "sql"

data
    |> sql.to(
        driverName: "sqlite3",
        dataSourceName: "file:/path/to/example.db?cache=shared&mode=ro",
        table: "example_table",
    )
```

> [!Note]
> #### Requires file system access
>
> To query SQLite, Flux must have access to the filesystem.
> If Flux does not have access to the file system, the query will return an error
> similar to one of the following:
>
> * `Error: unable to open database file`
> * `failed to read file: filesystem service is uninitialized`
> * `An internal error has occurred`
>
> If using **InfluxDB Cloud** or **InfluxDB OSS**, the Flux process **does not**have access to the filesystem.

## SQLite data source name

The `sqlite3` driver uses the following DSN syntax (also known as a **connection string**):

```
file:/path/to/example.db?param=value
```

## Flux to SQLite data type conversion

`sql.to()` converts Flux data types to SQLite data types.

|              Flux data type               |SQLite data type|
|-------------------------------------------|----------------|
| [float](/flux/v0/data-types/basic/float/) |     FLOAT      |
|   [int](/flux/v0/data-types/basic/int/)   |      INT       |
|  [uint](/flux/v0/data-types/basic/uint/)  |      INT       |
|[string](/flux/v0/data-types/basic/string/)|      TEXT      |
|  [time](/flux/v0/data-types/basic/time/)  |    DATETIME    |

#### Related

* [sql.to() function](/flux/v0/stdlib/sql/to/)
| Flux data type | SQLite data type |
| --- | --- |
| Flux data type | SQLite data type |
| float | FLOAT |
| int | INT |
| uint | INT |
| string | TEXT |
| time | DATETIME |
