On 1 GB RAM edge instances, running a dedicated PostgreSQL or MySQL daemon consumes precious memory better spent on page caches and network buffers. SQLite configured with Write-Ahead Logging (WAL) and synchronous = NORMAL easily sustains 25,000+ reads/sec and batched metric writes with sub-millisecond latency.
PRAGMA journal_mode = WAL;
PRAGMA synchronous = NORMAL;
PRAGMA busy_timeout = 5000;
PRAGMA temp_store = MEMORY;