Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

Nice! I think you could have used pg COPY .. CSV[0] plus a CREATE TABLE .. AS to avoid the custom python script and do the importing with only SQL.

Also, as others have mentioned you can generate the st_asmvt format directly from pg. This plus PostgREST binary output[1] can get you a way to query your table directly through a REST API.

[0]:https://www.postgresql.org/docs/current/sql-copy.html

[1]:http://postgrest.org/en/v5.2/api.html#binary-output



Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: