I think SQLite vs. PostgreSQL is similar to Flask+SQLAlchemy vs. Django, or similar debates. Yeah, you probably can do everything with the "simpler" stack. It

I think SQLite vs. PostgreSQL is similar to Flask+SQLAlchemy vs. Django, or similar debates. Yeah, you probably can do everything with the "simpler" stack. It might even be nominally faster in many cases. But if there's any chance you're going end up rolling your own type-validation or ORM or admin interface or GIS... Just use the battle-tested kitchen sink from the get go.