> If the project requires me to locally install a database, configure ports, or anything of the like, that's a shining red flag that things are very wrong
I disagree here slightly. I think it's reasonable that a database setup may be necessary, especially if abstraction layers (ie. ORMs) aren't being used for SQL, and SQLite is not your database of choice. Sure, you could set up docker, but not every project adopts or even likes docker.