Store telemetry data locally in SQLite, a lightweight embedded database. Outbound targets write to the ProxusDeviceData table.
open_in_new
Official Documentation
sqlite.org
Configuration Parameters
| Parameter | Required | Type | Description |
|---|---|---|---|
| Database | Yes | string | Path to the SQLite database file. |
Example Configuration
Database=/var/proxus/proxus.dbUse Cases
- Edge buffering: Store data locally when offline
- Development: Test without external database
- Low-resource devices: Minimal memory footprint
Data Schema
CREATE TABLE ProxusDeviceData (
Oid INTEGER PRIMARY KEY AUTOINCREMENT,
DeviceId INTEGER NOT NULL,
DeviceName TEXT,
Key TEXT NOT NULL,
Value TEXT NOT NULL,
DataType TEXT NOT NULL,
Time TEXT NOT NULL
);
CREATE INDEX idx_device_time ON ProxusDeviceData(DeviceId, Time);Limitations
- Single-writer at a time
- Not suitable for high-concurrency scenarios
- File size limited by filesystem