Skip to main content

New level of functionality and performance in data access via Python

Project description

Python Connector for PostgreSQL

Python Connector for PostgreSQL is a connectivity solution for accessing PostgreSQL databases from Python applications. It fully implements the Python DB API 2.0 specification. The connector is distributed as a wheel package for Windows, macOS, and Linux.

Direct connection

The connector enables you to establish a direct connection to PostgreSQL from a Python application via TCP/IP, eliminating the need for the database client library. A direct connection increases the speed of data transmission between the application and PostgreSQL database server. It also streamlines the deployment process since you don't have to distribute any client libraries with the application.

Secure communication

The connector supports encrypted communications using SSL/TLS, SSH tunneling, and HTTP/HTTPS tunneling.

Using the connector

To retrieve data from a database:

Import the module.

import devart.postgresql

Connect to a database using the connect() module method and obtain a connection object.

my_connection = devart.postgresql.connect(
    Server="your_server",
    Database="your_database",
    UserId="your_username",
    Password="your_password"
)

Create a cursor object using the cursor() connection method.

my_cursor = my_connection.cursor()

Execute the SQL statement using the execute() cursor method.

my_cursor.execute("SELECT * FROM employees")

Retrieve the result set using one of the fetch*() cursor methods.

for row in my_cursor.fetchall(): 
    print(row)

Ordering and activating the license

You can purchase a license for the connector on the ordering page:
https://www.devart.com/python/postgresql/ordering.html

To activate the license, follow the instructions in the documentation:
https://docs.devart.com/python/postgresql/activate-a-license.htm

What's new

Python Connector for PostgreSQL 1.2

  • Added support for Python 3.13
  • Added support for PostgreSQL 17
  • Added support for the pgvector extension
  • Added Read Only mode for connection

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distributions

No source distribution files available for this release.See tutorial on generating distribution archives.

Built Distributions

devart_postgresql_connector-1.2.0-cp313-cp313-win_amd64.whl (1.1 MB view details)

Uploaded CPython 3.13 Windows x86-64

devart_postgresql_connector-1.2.0-cp313-cp313-win32.whl (897.7 kB view details)

Uploaded CPython 3.13 Windows x86

devart_postgresql_connector-1.2.0-cp313-cp313-manylinux_2_34_x86_64.whl (2.2 MB view details)

Uploaded CPython 3.13 manylinux: glibc 2.34+ x86-64

devart_postgresql_connector-1.2.0-cp313-cp313-macosx_10_13_universal2.whl (4.1 MB view details)

Uploaded CPython 3.13 macOS 10.13+ universal2 (ARM64, x86-64)

devart_postgresql_connector-1.2.0-cp312-cp312-win_amd64.whl (1.1 MB view details)

Uploaded CPython 3.12 Windows x86-64

devart_postgresql_connector-1.2.0-cp312-cp312-win32.whl (897.7 kB view details)

Uploaded CPython 3.12 Windows x86

devart_postgresql_connector-1.2.0-cp312-cp312-manylinux_2_34_x86_64.whl (2.2 MB view details)

Uploaded CPython 3.12 manylinux: glibc 2.34+ x86-64

devart_postgresql_connector-1.2.0-cp312-cp312-macosx_10_9_universal2.whl (4.1 MB view details)

Uploaded CPython 3.12 macOS 10.9+ universal2 (ARM64, x86-64)

devart_postgresql_connector-1.2.0-cp311-cp311-win_amd64.whl (1.1 MB view details)

Uploaded CPython 3.11 Windows x86-64

devart_postgresql_connector-1.2.0-cp311-cp311-win32.whl (897.7 kB view details)

Uploaded CPython 3.11 Windows x86

devart_postgresql_connector-1.2.0-cp311-cp311-manylinux_2_34_x86_64.whl (2.2 MB view details)

Uploaded CPython 3.11 manylinux: glibc 2.34+ x86-64

devart_postgresql_connector-1.2.0-cp311-cp311-macosx_10_9_universal2.whl (4.1 MB view details)

Uploaded CPython 3.11 macOS 10.9+ universal2 (ARM64, x86-64)

devart_postgresql_connector-1.2.0-cp310-cp310-win_amd64.whl (1.1 MB view details)

Uploaded CPython 3.10 Windows x86-64

devart_postgresql_connector-1.2.0-cp310-cp310-win32.whl (897.4 kB view details)

Uploaded CPython 3.10 Windows x86

devart_postgresql_connector-1.2.0-cp310-cp310-manylinux_2_34_x86_64.whl (2.2 MB view details)

Uploaded CPython 3.10 manylinux: glibc 2.34+ x86-64

devart_postgresql_connector-1.2.0-cp310-cp310-macosx_10_9_universal2.whl (4.1 MB view details)

Uploaded CPython 3.10 macOS 10.9+ universal2 (ARM64, x86-64)

devart_postgresql_connector-1.2.0-cp39-cp39-win_amd64.whl (1.1 MB view details)

Uploaded CPython 3.9 Windows x86-64

devart_postgresql_connector-1.2.0-cp39-cp39-win32.whl (897.5 kB view details)

Uploaded CPython 3.9 Windows x86

devart_postgresql_connector-1.2.0-cp39-cp39-manylinux_2_34_x86_64.whl (2.2 MB view details)

Uploaded CPython 3.9 manylinux: glibc 2.34+ x86-64

devart_postgresql_connector-1.2.0-cp39-cp39-macosx_10_9_universal2.whl (4.1 MB view details)

Uploaded CPython 3.9 macOS 10.9+ universal2 (ARM64, x86-64)

devart_postgresql_connector-1.2.0-cp38-cp38-win_amd64.whl (1.1 MB view details)

Uploaded CPython 3.8 Windows x86-64

devart_postgresql_connector-1.2.0-cp38-cp38-win32.whl (897.8 kB view details)

Uploaded CPython 3.8 Windows x86

devart_postgresql_connector-1.2.0-cp38-cp38-manylinux_2_34_x86_64.whl (2.2 MB view details)

Uploaded CPython 3.8 manylinux: glibc 2.34+ x86-64

devart_postgresql_connector-1.2.0-cp38-cp38-macosx_10_9_universal2.whl (4.1 MB view details)

Uploaded CPython 3.8 macOS 10.9+ universal2 (ARM64, x86-64)

devart_postgresql_connector-1.2.0-cp37-cp37m-win_amd64.whl (1.1 MB view details)

Uploaded CPython 3.7m Windows x86-64

devart_postgresql_connector-1.2.0-cp37-cp37m-win32.whl (897.8 kB view details)

Uploaded CPython 3.7m Windows x86

devart_postgresql_connector-1.2.0-cp37-cp37m-manylinux_2_34_x86_64.whl (2.2 MB view details)

Uploaded CPython 3.7m manylinux: glibc 2.34+ x86-64

devart_postgresql_connector-1.2.0-cp37-cp37m-macosx_10_9_x86_64.whl (2.2 MB view details)

Uploaded CPython 3.7m macOS 10.9+ x86-64

File details

Details for the file devart_postgresql_connector-1.2.0-cp313-cp313-win_amd64.whl.

File metadata

File hashes

Hashes for devart_postgresql_connector-1.2.0-cp313-cp313-win_amd64.whl
Algorithm Hash digest
SHA256 7fb32f5f362d74cbc5190512600a6707856c16bf90ad21b99b49f732323f6373
MD5 b7676a1c71f1051f4d725fd9c40aa044
BLAKE2b-256 fe5f6c979b5ebd4566cb095726f7c6178dc576571928b41a4709b5bbfcbf06cf

See more details on using hashes here.

File details

Details for the file devart_postgresql_connector-1.2.0-cp313-cp313-win32.whl.

File metadata

File hashes

Hashes for devart_postgresql_connector-1.2.0-cp313-cp313-win32.whl
Algorithm Hash digest
SHA256 6474aa2bc15e7549497768ea8d239c766981282eb91da99a4393870a228c6adb
MD5 8ff59f2c9a7307302ed8ed3fde2ed451
BLAKE2b-256 c980fafe7fa07103daee84f20d7dd80cbca97646a74fc3b1166aeb4fcf8db095

See more details on using hashes here.

File details

Details for the file devart_postgresql_connector-1.2.0-cp313-cp313-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_postgresql_connector-1.2.0-cp313-cp313-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 95302be21d17612a3a28429609fa765e6103a43b57355c3b250d44deb974a8c6
MD5 49c841a5c48c7d5a4d75564dbd7c89c7
BLAKE2b-256 fd1b34a5467712e168f5e30b30302acf1b2dfdda7fd187109672e007f795288b

See more details on using hashes here.

File details

Details for the file devart_postgresql_connector-1.2.0-cp313-cp313-macosx_10_13_universal2.whl.

File metadata

File hashes

Hashes for devart_postgresql_connector-1.2.0-cp313-cp313-macosx_10_13_universal2.whl
Algorithm Hash digest
SHA256 9d86a9bc8cf972428174f5d95f9e20a7e18aa1309c3b331e7a34987781ca16a5
MD5 550ac5d85977b8d5fa28f60a22462b1b
BLAKE2b-256 a42c283428011f4b23a6eaa41ba54077d4c9b59d3c8e2716ace307d030bde23f

See more details on using hashes here.

File details

Details for the file devart_postgresql_connector-1.2.0-cp312-cp312-win_amd64.whl.

File metadata

File hashes

Hashes for devart_postgresql_connector-1.2.0-cp312-cp312-win_amd64.whl
Algorithm Hash digest
SHA256 676448b426f31508a3f310162420fcfaf501b727adeb280c27267481bcc78025
MD5 3e3436ac8c449d425ceaf883d17ac699
BLAKE2b-256 767614bcb912738f3bb7550fb288772fb54f6248b9ac2ea67643b066a4df2450

See more details on using hashes here.

File details

Details for the file devart_postgresql_connector-1.2.0-cp312-cp312-win32.whl.

File metadata

File hashes

Hashes for devart_postgresql_connector-1.2.0-cp312-cp312-win32.whl
Algorithm Hash digest
SHA256 c5ebac6b5e591bcf57de57f2096d21a33a747bd06dd92c5438e0a7eb068611b0
MD5 b43df3b3299e0a39b8a802ce2496c0a8
BLAKE2b-256 3b24e17d1839d7bea13e5d187f07761ac1d407950dee8b83788063621a624f7e

See more details on using hashes here.

File details

Details for the file devart_postgresql_connector-1.2.0-cp312-cp312-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_postgresql_connector-1.2.0-cp312-cp312-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 606e3a459ff0697eabd5e133ce59c1a9d07579d27a88f1fa8d32ab6802a7d3a2
MD5 2fbe39bf060deb6a5058a9351ee89b85
BLAKE2b-256 982fe337f78ef5d1ee6459abab2ce65643f181326e4eec67f1d20210271c6465

See more details on using hashes here.

File details

Details for the file devart_postgresql_connector-1.2.0-cp312-cp312-macosx_10_9_universal2.whl.

File metadata

File hashes

Hashes for devart_postgresql_connector-1.2.0-cp312-cp312-macosx_10_9_universal2.whl
Algorithm Hash digest
SHA256 5f8c2ca9e8bddd1ebba9464281e6bbf1a3934513b25b0f27e197a1eaed94cdac
MD5 9a4b95accb07e6907d6d19adce8e6d44
BLAKE2b-256 1dfff611a731c5a3dba2e46af872d436de65996dc0f849e44316bdd0637e3d4d

See more details on using hashes here.

File details

Details for the file devart_postgresql_connector-1.2.0-cp311-cp311-win_amd64.whl.

File metadata

File hashes

Hashes for devart_postgresql_connector-1.2.0-cp311-cp311-win_amd64.whl
Algorithm Hash digest
SHA256 55d0f1e6c9bc4cc3db64963e569414ee21f142e5a683c9e7473695b7e476972d
MD5 4a68dcc0361a88fcb80e8f11991e86fa
BLAKE2b-256 822312ce8b838b94bcbf5bfc30e92ed06a01cd4ae55bfab373bce5c6b7e37bac

See more details on using hashes here.

File details

Details for the file devart_postgresql_connector-1.2.0-cp311-cp311-win32.whl.

File metadata

File hashes

Hashes for devart_postgresql_connector-1.2.0-cp311-cp311-win32.whl
Algorithm Hash digest
SHA256 6a1e610837e70c11a530a41de0bdb1fa38c1ba63891b58c52d57214fefaa7620
MD5 aa7ad50bc7f9d5f98409f8bf2fbccd5f
BLAKE2b-256 858adcdf89d07977233365e8c00c16fab908098f0167bbdfc3a38d002ab08aea

See more details on using hashes here.

File details

Details for the file devart_postgresql_connector-1.2.0-cp311-cp311-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_postgresql_connector-1.2.0-cp311-cp311-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 c1c375e0e4616bc043970b8e19420a50bd890d9e6df254ac539669a2935e4e87
MD5 8c6935172eca90f5b7b4ea36a9778822
BLAKE2b-256 be241eb2b01e889d0c650fb00a900a0c7f1858d6e134a61ef3242d276a3c0a9d

See more details on using hashes here.

File details

Details for the file devart_postgresql_connector-1.2.0-cp311-cp311-macosx_10_9_universal2.whl.

File metadata

File hashes

Hashes for devart_postgresql_connector-1.2.0-cp311-cp311-macosx_10_9_universal2.whl
Algorithm Hash digest
SHA256 5925b108dd16308e15a9138f39943c2b8d9bf656168075247fc4ab773bfb3585
MD5 6bfc93f67da311afdfbbfd3865259262
BLAKE2b-256 e754baf933656c82864cd31ec45ddab562c85868fcfc8c6ff58653706121a69c

See more details on using hashes here.

File details

Details for the file devart_postgresql_connector-1.2.0-cp310-cp310-win_amd64.whl.

File metadata

File hashes

Hashes for devart_postgresql_connector-1.2.0-cp310-cp310-win_amd64.whl
Algorithm Hash digest
SHA256 0fff3c7337c606ce3d8e70e3ef831264eeaf45ee23bb2b1d8a1d5a9c9657b3f9
MD5 53eadceb7c7a3ef999ab59a2d63de911
BLAKE2b-256 24114117df9c1f6f321f744ffc006e142a3e59fc955f034e15222ffcaa7cf32f

See more details on using hashes here.

File details

Details for the file devart_postgresql_connector-1.2.0-cp310-cp310-win32.whl.

File metadata

File hashes

Hashes for devart_postgresql_connector-1.2.0-cp310-cp310-win32.whl
Algorithm Hash digest
SHA256 77cc29c371d09c3346c055b6340ea67cb27ee23d2724d2c94ffbcba0ebc192bc
MD5 de4c60092a7f535af2b4a3d9c4858980
BLAKE2b-256 a167d458687886c5f04d7f52eb0abe921e6d794b887d7a23141cf793d15eddb9

See more details on using hashes here.

File details

Details for the file devart_postgresql_connector-1.2.0-cp310-cp310-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_postgresql_connector-1.2.0-cp310-cp310-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 b975873710ae085f24aef1f2d039dba5ee1ddcca59d8999a7c033acd54262dd3
MD5 2cff2a0f88e86048fe208aa17b5551de
BLAKE2b-256 adcdf71305bf983c8d2a9ef5652e723aefc449ba2e10e2264908d1646754d273

See more details on using hashes here.

File details

Details for the file devart_postgresql_connector-1.2.0-cp310-cp310-macosx_10_9_universal2.whl.

File metadata

File hashes

Hashes for devart_postgresql_connector-1.2.0-cp310-cp310-macosx_10_9_universal2.whl
Algorithm Hash digest
SHA256 06e2f7de0a7e92b10ccc61efb0771526567ecf05fa95422f44eea5d66405e5ca
MD5 6de839593f1c3e6558540904b8bf9b20
BLAKE2b-256 b7a3e199a43477fecafcabf94d2d75c331ffbe11f4ac949db04cea4a29ec9cc6

See more details on using hashes here.

File details

Details for the file devart_postgresql_connector-1.2.0-cp39-cp39-win_amd64.whl.

File metadata

File hashes

Hashes for devart_postgresql_connector-1.2.0-cp39-cp39-win_amd64.whl
Algorithm Hash digest
SHA256 346937bf6014dbf16cced5be88fa6a0e71f52001b33b3e187fa52a9638c63449
MD5 796ced7c7429b17a9d2905fd28fd8539
BLAKE2b-256 fa1bcc3bf5073f42967b069dad9501fed6755df407f3756dd3d9e3fce0d54227

See more details on using hashes here.

File details

Details for the file devart_postgresql_connector-1.2.0-cp39-cp39-win32.whl.

File metadata

File hashes

Hashes for devart_postgresql_connector-1.2.0-cp39-cp39-win32.whl
Algorithm Hash digest
SHA256 8f129143b25b29f800f12a3ff8dcc54c069145de9c43f33edc9c9461d7964053
MD5 e09ea44f07068a8a611d615ca1f2e358
BLAKE2b-256 989ca56dc3c71d8253000ed32187740959f0a8e2093f94c653e26716961b6e4f

See more details on using hashes here.

File details

Details for the file devart_postgresql_connector-1.2.0-cp39-cp39-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_postgresql_connector-1.2.0-cp39-cp39-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 4dde4084ac148e2e2018527c468cf745352e1a7fb2d02cf2d941db169dfedc26
MD5 9d200fa86b19a4d99720b5d20d1e3a11
BLAKE2b-256 13127c8435938ae394863262b5d860a92e577f7b09a2a10099c4e8063c0deab9

See more details on using hashes here.

File details

Details for the file devart_postgresql_connector-1.2.0-cp39-cp39-macosx_10_9_universal2.whl.

File metadata

File hashes

Hashes for devart_postgresql_connector-1.2.0-cp39-cp39-macosx_10_9_universal2.whl
Algorithm Hash digest
SHA256 ead024d7ab0e9f2faec224bb5645afdce58527d8a9b02d8ccddf12be86ee6e9d
MD5 5a702601125544e1d163eb653337c713
BLAKE2b-256 6122fa777cc829272ea3bcf4be3dda29e354e1e84642aaffb4adf58df8d5568d

See more details on using hashes here.

File details

Details for the file devart_postgresql_connector-1.2.0-cp38-cp38-win_amd64.whl.

File metadata

File hashes

Hashes for devart_postgresql_connector-1.2.0-cp38-cp38-win_amd64.whl
Algorithm Hash digest
SHA256 8634ee5a2a9501e2400e36cbf407d6950e17270ba3ba28568e4e1577c2ead63e
MD5 86a28f182b18a77cbaf29b009418ac05
BLAKE2b-256 d792ebbb32be7cc5f5a2399bf6e4e9772fb62e9d2f365a716a69e8a912049a8f

See more details on using hashes here.

File details

Details for the file devart_postgresql_connector-1.2.0-cp38-cp38-win32.whl.

File metadata

File hashes

Hashes for devart_postgresql_connector-1.2.0-cp38-cp38-win32.whl
Algorithm Hash digest
SHA256 20cc4fb9eb962398b1a47c565fa293718cbc59be5494a7da9055a195ade0c5bd
MD5 c3c16f739519f945c12b49a588087658
BLAKE2b-256 0c3885d32f4c9d9b6d21c6ec582829f469727b2b366f32be342fd77857347811

See more details on using hashes here.

File details

Details for the file devart_postgresql_connector-1.2.0-cp38-cp38-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_postgresql_connector-1.2.0-cp38-cp38-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 b5a188cced7436860b063004e42613fe3857c8797c9c0e58b510c33b898fc90a
MD5 fbb1d3998a06a25c3f97f04fc4a74a2c
BLAKE2b-256 47a64f2fbc5754cfe30eed15c83c43d08d4f9ba96c328b8f7cd5bda3ae812ea0

See more details on using hashes here.

File details

Details for the file devart_postgresql_connector-1.2.0-cp38-cp38-macosx_10_9_universal2.whl.

File metadata

File hashes

Hashes for devart_postgresql_connector-1.2.0-cp38-cp38-macosx_10_9_universal2.whl
Algorithm Hash digest
SHA256 d954fb7e6c55ebf0890056d82c2ab47a4397ae98d0638b3615114fc77aa4cbe0
MD5 d2f16b5fe33bfa830222fed49a9ea401
BLAKE2b-256 d005bfbf86cd88fb3d2ade5a86b52b10e701f456ede073b9150268221b400787

See more details on using hashes here.

File details

Details for the file devart_postgresql_connector-1.2.0-cp37-cp37m-win_amd64.whl.

File metadata

File hashes

Hashes for devart_postgresql_connector-1.2.0-cp37-cp37m-win_amd64.whl
Algorithm Hash digest
SHA256 24d75397bc9651a4c0f3cfaa112c5292c1795ee9854255a95935ebc303b893c6
MD5 558f2e232e4d4c2285d21a746d2385a8
BLAKE2b-256 7127934f19a6fc3dee1389a5ad250ece0717f8538984bd254ee63085b0f3ea37

See more details on using hashes here.

File details

Details for the file devart_postgresql_connector-1.2.0-cp37-cp37m-win32.whl.

File metadata

File hashes

Hashes for devart_postgresql_connector-1.2.0-cp37-cp37m-win32.whl
Algorithm Hash digest
SHA256 066204e4d0ae4b109026ad8e47b2bf3c4fa73ffe5cb7748d4ae01c9b5f07123b
MD5 9ebaa41113f817406dee4cc67ba6416e
BLAKE2b-256 3b607c17134ed8d1e0c1ead9f3757954b1f0122843ba648a6f3a581b042cc685

See more details on using hashes here.

File details

Details for the file devart_postgresql_connector-1.2.0-cp37-cp37m-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_postgresql_connector-1.2.0-cp37-cp37m-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 2782695f2b59d03ce70c6f70712e4c27eabb7d03c8b128f6e73fb36d28278b31
MD5 ea5145641996f9f27ec231b4cd66f926
BLAKE2b-256 2bbdf1fc679ede9957476bae0cf501259141b8050b41fa34d07a41d8f1cccc5c

See more details on using hashes here.

File details

Details for the file devart_postgresql_connector-1.2.0-cp37-cp37m-macosx_10_9_x86_64.whl.

File metadata

File hashes

Hashes for devart_postgresql_connector-1.2.0-cp37-cp37m-macosx_10_9_x86_64.whl
Algorithm Hash digest
SHA256 e9816bb4b4475c4647b7b6e8119c60f55dc5328952921a057bde01d96db072c2
MD5 27ef404c032b71f96c3136ee17ecf24b
BLAKE2b-256 229d3c41eb56110ead1cd9eec611d99047bf733ae0ad85bb5c628f52162fac32

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page