Write to SQLite

To write data to SQLite with Flux:

1. Import the sql package.

2. Pipe-forward data into sql.to() and provide the following parameters:

   • driverName: sqlite3
   • dataSourceName: See 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)

import "sql"

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

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.