Sandro Santilli
Sandro Santilli
Even better would be to finally implement it ! :)
it used to be implemented in the rails app: https://github.com/CartoDB/cartodb/blob/1.0/lib/importer/lib/cartodb-exporter/exporter.rb#L49 should be simple to port that code to sql api, as long as we can count on pg_dump being available.
Being a new support this should go in 1.6. Will use a feature/sql-export branch for this
it looks like ogr2ogr supports a "PGDump" format, this is good news as we already have all the infrastructure ready for any ogr2ogr output
This is ready for test here: https://github.com/CartoDB/CartoDB-SQL-API/tree/feature/sql-export
@lorenzoplanas how's the importer going ? anything you think should be changed in the exporter ?
@lorenzoplanas any news on this ?
Note that latest GDAL version supports cartodb via SQL-API, so you should be able to migrate away with ogr2ogr (confirmation welcome).
Worth experimenting with the core `zlib` support in node for this. Need this fix first: https://github.com/wdavidw/node-csv-parser/issues/63
Is `application/zip; charset=utf-8` a good Content-Type for this ?