1M rows/s from Postgres to Python

Datetime:2016-08-23 02:18:57          Topic: Python  PostgreSQL           Share

Why asyncpg?

We are building EdgeDB —the next generation object database with PostgreSQL as a backing store. We need high-performance, low-latency access to the advanced features of PostgreSQL.

The most obvious option was psycopg2—the most popular Python driver for PostgreSQL. It is well-supported, stable, proven technology. There is also aiopg, which provides async interface on top of psycopg2. With that there is an obvious question: why reinvent the wheel? Short answer is twofold: features and performance . We will cover each item in detail below.





About List