SQLite is probably enough

For a huge class of apps — single box, modest writes, read-heavy — SQLite is not a toy, it's the right answer. No server to run, no connection pool to tune, and backups are cp.

You'll know you've outgrown it when concurrent writers start contending. Until then, the operational simplicity is a feature you get for free.