Show HN: 1M rows/s from Postgres to Python

Re:Show HN: 1M rows/s from Postgres to Python by jamiesonbecker on Thursday August 04, 2016 @10:15PM (#12229672)

Would this work/be binary-compatible with Amazon Red Shift?

[ Parent | on HN ]

Re:Show HN: 1M rows/s from Postgres to Python by 1st1 on Thursday August 04, 2016 @10:22PM (#12229692)

Should be. AFAIK psycopg2 works with Redshift just fine, so should asyncpg.

The only thing I'm not sure about is what kind of authentication mode Redshift is using. asyncpg doesn't support all of them, but that's easy to fix.

[ Parent | on HN ]

Re:Show HN: 1M rows/s from Postgres to Python by RedCrowbar on Thursday August 04, 2016 @10:24PM (#12229701)

Haven't tried, but, AFAIK, redshift speaks the standard PostgreSQL protocol, so asyncpg should work.

[ Parent | on HN ]