SQLite

The connection to SQLite is based on the sqlite3 library.

Dependency

• sqlite3

Parameters

Required:

• database is the path to the database file to be opened. You can pass “:memory:” to create an SQLite database existing only in memory, and open a connection to it.

Note

If the database parameter is specified, EvaDB connects to the already existing sqlite database specified. Otherwise, it automatically creates a new sqlite database named evadb.db.

Create Connection

CREATE DATABASE sqlite_data WITH ENGINE = 'sqlite', PARAMETERS = {
     "database": "evadb.db"
};