SQLite
Overview
SQLite is a self-contained, serverless, zero-configuration relational database engine. It stores the entire database as a single file on disk, making it ideal for embedded applications, mobile apps, desktop tools, and local development. SQLite is the most widely deployed database engine in the world.
Driver
- Crate:
rusqlite - Version:
0.32
Connection fields
| Field | Description |
|---|---|
| File | Absolute path to the .db or .sqlite database file. |
| Options | Additional connection parameters as key1=val1&key2=val2. |
Schema browser
Once connected, Arris reads the sqlite_master table and organizes objects into groups.
The schema tree displays the following object types, grouped by category:
- Tables — regular tables
- Views — views
- Indexes — indexes
- Triggers — triggers
Double-click any table or view to open it in a new tab with browse mode.
Supported SQL commands
| Command | Notes |
|---|---|
SELECT | Query data with WHERE filters, JOINs, aggregates, and window functions. |
INSERT | Insert single or multiple rows. |
UPDATE | Update existing rows. |
DELETE | Delete rows. |
CREATE / DROP | Create and drop tables, views, and other schema objects. |