Psycopg

Try it in 3 steps

1. 1

   Install the Psycopg 3.3.6 binary implementation

   Pin the reviewed Psycopg release. Python 3.10 or newer is required.

   python -m pip install "psycopg[binary]==3.3.6"Copy
2. 2

   Set a disposable PostgreSQL connection string

   Replace USER, PASSWORD, HOST, and DBNAME with a PostgreSQL database that is safe to use for verification. Do not commit real credentials.

   export DATABASE_URL='postgresql://USER:PASSWORD@HOST:5432/DBNAME'Copy
3. 3

   Connect and read the server version

   Use a read-only SELECT to verify connectivity and query execution without changing database schema or data.

   python - <<'PY' import os import psycopg with psycopg.connect(os.environ['DATABASE_URL']) as conn: print(conn.execute('select version()').fetchone()[0]) PYCopy

Built with

• Python
• PostgreSQL

Categories and tags

GitHub data

Share a guide or use case for this OSS in Markdown. Articles are published after administrator approval.

Explore next

• sqlx17,743 Stars

  3 shared tag(s) · 2 shared category(s)

  extend database/sql with struct scanning and named queries without replacing its interfaces

  Go
• Ent17,204 Stars

  3 shared tag(s) · 2 shared category(s)

  generate statically typed query APIs from Go schemas with an entity framework

  Go
• Go MySQL Driver15,278 Stars

  3 shared tag(s) · 2 shared category(s)

  connect standard database/sql applications to MySQL and MariaDB with a pure-Go driver

  Go
• Diesel14,193 Stars

  3 shared tag(s) · 2 shared category(s)

  validate SQL queries and schemas with Rust's type system through an ORM and query builder

  Rust
• SeaORM9,914 Stars

  3 shared tag(s) · 2 shared category(s)

  manage asynchronous queries, relations, and migrations with a relational ORM for Rust

  Rust
• Bun4,984 Stars

  3 shared tag(s) · 2 shared category(s)

  add SQL-first query building and model mapping to Go's database/sql layer

  Go