My solution path for databases has been like this for a good decade:
1) Sqlite
2) Self-hosted Postgres
3) Big Boy Database, with an $$$ cost. (AWS Aurora, Oracle, etc).
Most projects never leave the Sqlite level. Only one has left the Postgres level so far.