Input · Files

SQLite Reader

Reads one table from a local SQLite database file (.sqlite, .sqlite3 or .db). You pick the table from the file's list of tables.

Also known as: Embedded database

How it works

The drone attaches the database file and lists its tables. File path names the .sqlite, .sqlite3 or .db file and is always typed; Table picks the table to read and is the one field you can bind to a column of the Loop's Current item, so a loop reads several tables from the same file. SQLite has a single main schema, so the table name alone identifies it. The node does not run until both fields are set.

Inputs and outputs

Settings

Example

A mobile app's app.sqlite with the tables users, events and purchases. Set File path to the file and Table to events. To export all three, put the reader in a Loop over a Constant Table of the three names and bind Table to that column.

More in Files

• CSV Reader — Reads a CSV or other delimited text file, such as a TSV. Column types are detected for you, and you can override them or read every column as text.
• Fixed-width Reader — Reads a text file whose columns sit at fixed character positions, such as a mainframe export or a legacy feed, slicing each line at the positions you set on a ruler over the file's first lines. Header row, start line, encoding and row limit work as in the CSV Reader.
• JSON Reader — Reads a .json, .jsonl or .ndjson file as a table. A JSON array of objects and one-object-per-line files are both detected automatically.
• Parquet Reader — Reads a Parquet file and keeps the column types stored in it.
• Excel Reader — Reads one worksheet of an Excel workbook, the first sheet unless you pick another.
• Geo Reader — Reads a map file with its geometry: GeoJSON, Shapefile (also zipped), GeoPackage, GML, KML/KMZ, GPX, FlatGeobuf or MapInfo TAB. For a file with several layers, you pick which layer to read.
• XML Reader — Reads an XML file into a table. It finds the repeating record element for you, so each record becomes a row.
• Locra Table Reader — Reads a .ddtable file saved by Write Locra Table, in this project or another one. The column formats come back too, so everything prints as it did.