SQLite

This is the public preview documentation of Neo4j Virtual Graph. To provide feedback, please use the feedback form you were granted access to.

During the public preview, we advise you not to use sensitive or production data with Virtual Graph.

This driver is required by data source definitions of type sqlite.

SQLite is an embedded database and the most widely used database worldwide by a margin. SQLite for Java is available on GitHub. Databases can be run in pure memory ( useful for testing) or as files (useful for experimenting, as the data is persisted during restarts). The database files are created on your local machine, no database server or remote connection is required.

Direct download

curl -O https://repo.maven.apache.org/maven2/org/xerial/sqlite-jdbc/3.51.2.0/sqlite-jdbc-3.51.2.0.jar

Maven coordinates

<dependency>
  <groupId>org.xerial</groupId>
  <artifactId>sqlite-jdbc</artifactId>
  <version>3.51.2.0</version>
</dependency>

Configuration

{
  "type": "sqlite",
  "path": "/Users/msimons/tmp/ge-home/movies.sqlite"
}

The only supported secret is the anonymous secret.

Limiting the number of fetched rows

SQLite fully supports JDBC fetch size. Configure the desired number of rows being fetched via additionalProperties and the key jdbc.fetch_size:

{
  "type": "sqlite",
  "path": "/Users/msimons/tmp/ge-home/movies.sqlite",
  "additionalProperties": {
    "jdbc.fetch_size": "1000"
  }
}