Upgrade the build environment.

[Avey777]

Upgrade Python 3.7 to Python 3.8 or higher
Upgrade nodejs14 to nodejs16 or higher
Upgrade postgres9.6 topostgres12 or higher
Upgrade redis to Python 5.0 or higher

[Avey777]

@justinclift
Should we decide on upgrading the version so that we can test from a higher starting point? After all, there are already many dependency packages that need to be upgraded, and it would be good for us to determine whether to abandon or continue maintaining them in the future. This way, we can make progress faster in our work.

[justinclift]

Well, I know for sure that Redis 5 and PostgreSQL 13 work with the existing libraries. I've had both of those running in production with Redash for over 12 months across several different installations. No issues from those.

The NodeJS and Python 3.8 ones I'm not real sure of for a production build though. We'll probably need to be a bit more careful with them, though it doesn't hurt is to try them in a PR and see if anything breaks right away.

What does everyone else reckon? 😄

[Avey777]

Well, I know for sure that Redis 5 and PostgreSQL 13 work with the existing libraries. I've had both of those running in production with Redash for over 12 months across several different installations. No issues from those.

The NodeJS and Python 3.8 ones I'm not real sure of for a production build though. We'll probably need to be a bit more careful with them, though it doesn't hurt is to try them in a PR and see if anything breaks right away.

What does everyone else reckon? 😄

I think we can update these two first, and the updates for these two should not have any problems. This task may require your assistance.

[Avey777]

When we update most of the dependencies to a certain stage, many interdependent issues between the dependencies are likely to be resolved.

[justinclift]

Yeah, I'm hoping that's the case as well. 😄

[justinclift]

This task may require your assistance.

Ahhh. In that case, gimme 5 minutes. I'll change the PostgreSQL PR to include a Redis update as well, then we can run the CI tests on it and merge it. 😄