We suspect we imagine tensions that exist only because we don't see a path that "resolves" multiple needs.
Speed vs Space. The short program is the slower.
Short vs Long Term. We borrow from our own future.
Problem vs Difficulty. We savor one from which we learn.
Productivity vs Quality. Haste makes waste.
Functional vs Object Oriented. Who knows what when?
Static vs Dynamic Types. Who knows what when?
See Five Fundamental Trade-offs pdf