Stable Versions for carto, SQL-API, Windshaft-cartodb

[enriquetuya]

Hi all, I'm trying to move away from cloning the master branches of al repos: cartodb, cartodb-postgresql, Windshaft-cartodb, CartoDB-SQL-API and start using some fixed tags so I can guarantee that on each build I have the same results. I was wondering if anyone has done the same in the past few months. I've seen a couple of comments on some issues about Windshaft version but that's it. I've already tried using the latest versions on each repo but that does not work.

Thanks to Everyone.

[sabman]

I'm running into similar problems. How are your efforts going?

[enriquetuya]

@sabman I had to pause them, I may have some news later next week. If you manage to work on this yourself, please let me know.

[enriquetuya]

Experiment 1 (Failure)

ENV cartodb_postgresql_version=0.21.0
ENV cartodb_version=v4.11.59
ENV cartodb_windshaft_version=5.0.0
ENV cartodb_sql_api_version=2.1.0

Results:

• [x] Build success
• [ ] Try out builder

Errors:

When trying to see the dataset rows: /user/admin/api/v2/sql?sort_order=asc&rows_per_page=0&page=0&api_key=68b96c0f27375f2d74fc270eb8b8315005bf96f5&q=SELECT+*+FROM+(SELECT+*+FROM+table_182anp_geo_itrf08_noviembre_2017)+__wrapped I get {"error":["Unauthorized"]}

Experiment 2 (Success)

Using versions from Jan 2018:

ENV cartodb_postgresql_version=0.21.0
ENV cartodb_version=v4.11.59
ENV cartodb_windshaft_version=5.0.0
ENV cartodb_sql_api_version=1.48.1

Results:

• [x] Build success
• [x] Try out builder
• [x] Try uploading a dataset.

[enriquetuya]

@sabman @Prindle19 I've tried out the versions I mention above and work. You can also find some changes on the Dockerfile that allow quicker iteration over version changes here: https://github.com/GlobalFishingWatch/docker-cartodb-1/commit/d4288b1d1b0f6a9a559c1c08f0ef377773187877

If you get latest versions working properly, please let me know.