Meta Information
API Usage
PostgresMessage
QueryResultMessage
ParameterStatus
ParameterStatus.name
ParameterStatus.value
ErrorOrNoticeResponse
ErrorOrNoticeResponse.notice
ErrorOrNoticeResponse.recoverable
ReadyForQuery
ReadyForQuery.state
ReadyForQueryState
ReadyForQueryState.IDLE
ReadyForQueryState.IN_TRANSACTION
ReadyForQueryState.ERRORED_TRANSACTION
AuthenticationRequest
AuthenticationRequest.method
AuthenticationRequest.md5_salt
AuthenticationRequest.sasl_methods
AuthenticationMethod
AuthenticationMethod.CLEARTEXT
AuthenticationMethod.MD5
AuthenticationMethod.SASL
BackendKeyData
BackendKeyData.pid
BackendKeyData.secret_key
AuthenticationCompleted
ColumnDescription
ColumnDescription.name
ColumnDescription.table_oid
ColumnDescription.column_index
ColumnDescription.type_oid
ColumnDescription.column_length
ColumnDescription.type_modifier
RowDescription
RowDescription.columns
DataRow
DataRow.description
DataRow.data
DataRow.to_dict()
CommandComplete
CommandComplete.tag
CommandComplete.row_count
ParseComplete
ParameterDescription
ParameterDescription.oids
PreparedStatementInfo
PreparedStatementInfo.name
PreparedStatementInfo.parameter_oids
PreparedStatementInfo.row_description
BindComplete
SansIOClient
SansIOClient.__init__()
SansIOClient.encoding
SansIOClient.timezone
SansIOClient.dead
SansIOClient.ready
pg_purepy.NO_DATA
SansIOClient.next_event()
SansIOClient.get_needed_synchronisation()
SansIOClient.receive_bytes()
SansIOClient.do_startup()
SansIOClient.do_simple_query()
SansIOClient.do_create_prepared_statement()
SansIOClient.do_bind_execute()
SansIOClient.do_terminate()
SansIOClient.state
ProtocolState
open_database_connection()
AsyncPostgresConnection
AsyncPostgresConnection.ready
AsyncPostgresConnection.in_transaction
AsyncPostgresConnection.dead
AsyncPostgresConnection.connection_parameters
AsyncPostgresConnection.server_timezone
AsyncPostgresConnection.fetch()
AsyncPostgresConnection.execute()
AsyncPostgresConnection.fetch_one()
AsyncPostgresConnection.query()
QueryResult
QueryResult.row_count()
AsyncPostgresConnection.lowlevel_query()
BaseDatabaseError
RecoverableDatabaseError
UnrecoverableDatabaseError
AsyncPostgresConnection.with_transaction()
pool.open_pool()
PooledDatabaseInterface
PooledDatabaseInterface.max_connections
PooledDatabaseInterface.idle_connections
PooledDatabaseInterface.waiting_tasks
PooledDatabaseInterface.execute()
PooledDatabaseInterface.fetch()
PooledDatabaseInterface.fetch_one()
PooledDatabaseInterface.checkout_in_transaction()
PooledDatabaseInterface.add_converter()
PooledDatabaseInterface.add_converter_with_array()
EnumConverter
ArrayConverter
hstore
Converter
Converter.oid
Converter.from_postgres()
Converter.to_postgres()
ConversionContext
ConversionContext.client_encoding
ConversionContext.timezone
AsyncPostgresConnection.add_converter()
SansIOClient.add_converter()
pg-purepy can be found on PyPI.
pg-purepy
$ poetry add pg-purepy
pg-purepy requires Python 3.11 or newer.
Whilst pg-purepy has no C dependencies, it does have some external Python dependencies.
anyio is used for connecting to the database asynchronously.
scramp is used for SASL authentication.
attrs is used to create the message object classes.
arrow is used for better datetime types.