ConnectorX¶
ConnectorX enables you to load data from databases into Python in the fastest and most memory-efficient way.
Install
pip install --upgrade connectorx
Synopsis
import connectorx as cx
cx.read_sql(
"postgresql://username:password@server:port/database",
"SELECT * FROM lineitem",
partition_on="l_orderkey",
partition_num=10,
)
See also
Documentation
The full documentation for ConnectorX.
Example
An executable example using ConnectorX.