pgasync | Twisted-Based Asynchronous PostgreSQL Client Library | Reactive Programming library

pgasync is a Python library typically used in Programming Style, Reactive Programming applications. pgasync has no bugs, it has no vulnerabilities, it has build file available and it has low support. However pgasync has a Non-SPDX License. You can download it from GitHub.

pgasync fully conforms to the DB 2.0 API. In a single, dedicated thread, it generally runs about 1.8x as slow as syncronous psycopg, which is written entirely in C. However, using adbapi (psycopg's twisted.enterprise w/the overhead of threading), it runs slightly faster than psycopg + enterprise at low load, and seems to be much more stable and scalable under heavy load. All execute(), exFetch(), and fetch*() methods return a twisted.internet.defer.Deferred. Queries will be queued, so feel free to ignore these deferreds if you're not interested in the results: keep adding more queries. The one exception is connection.cursor(). No queries should execute until this function's deferred calls back. paramstyle is pyformat. types are provided. Pooling/persistence happens, and the pool grows/shrinks based on activity.