SQLite is enough, more often than you think
Most of my side projects store a few thousand rows. For years I set up a full database server for each of them, with users, backups and a monitoring check that nobody read.
Then I tried the opposite: one file next to the application. Backups became cp. Migrations became a short script. The whole thing fits in a container volume.
What to turn on
PRAGMA journal_mode = WAL;
PRAGMA synchronous = NORMAL;
PRAGMA foreign_keys = ON;
Write-ahead logging lets readers and one writer coexist, which covers the vast majority of small web apps. When you outgrow it, you will know, and the schema moves over without drama.