Package Health Score

88 / 100

security
No known security issues
popularity
Key ecosystem project
maintenance
Healthy
community
Sustainable

Explore Similar Packages

Popularity

Key ecosystem project

GitHub Stars: 1.78K
Forks: 168
Contributors: 70

Direct Usage Popularity

Based on project statistics from the GitHub repository for the PyPI package psycopg, we found that it has been starred 1,780 times.

Security

No known security issues

Security and license risk for latest version

Release Date: Sep 29, 2024
Direct Vulnerabilities: 0
C
0
H
0
M
0
L
Indirect Vulnerabilities: 0
C
0
H
0
M
0
L
License Risk: 0
H
0
M
0
L

All security vulnerabilities belong to production dependencies of direct and indirect packages.

License

LGPL-3.0

Non-Permissive License

We noticed that this project uses a license which requires less permissive conditions such as disclosing the source code, stating changes or redistributing the source under the same license. It is advised to further consult the license terms before use.

Security Policy

We found a way for you to contribute to the project! Looks like psycopg is missing a security policy.

You can connect your project's repository to Snyk to stay up to date on security alerts and receive automatic fix pull requests.

Keep your project free of vulnerabilities with Snyk

Maintenance

Healthy

Commit Frequency

Open Issues: 27
Open PR: 7
Last Release: 2 months ago
Last Commit: 5 days ago

Further analysis of the maintenance status of psycopg based on released PyPI versions cadence, the repository activity, and other data points determined that its maintenance is Healthy.

We found that psycopg demonstrates a positive version release cadence with at least one new version released in the past 3 months.

As a healthy sign for on-going project maintenance, we found that the GitHub repository had at least 1 pull request or issue interacted with by the community.

Community

Sustainable

Readme: Yes
Contributing.md: No
Code of Conduct: No
Contributors: 70
Funding: Yes

With more than 10 contributors for the psycopg repository, this is possibly a sign for a growing and inviting community.

We found a way for you to contribute to the project! Looks like psycopg is missing a Code of Conduct.

Embed Package Health Score Badge

Keep your project healthy

Check your requirements.txt

Ensure all the packages you're using are healthy and well-maintained

Snyk Vulnerability Scanner

Get health score & security insights directly in your IDE

Package

Python Versions Compatibility: >=3.8

Age: 3 years
Latest Release: 2 months ago
Dependencies: 0 Direct
Versions: 45
Maintainers: 1
Wheels: OS Independent

Not sure how to use psycopg?

To help you get started, we've collected the most common ways that psycopg is being used within popular public projects.

odoo / odoo / doc / migrate / 3.4.0-4.0.0 / post.py View on Github

if not (hasattr(options, name) and getattr(options, name)):
            if value in ('true', 'True'):
                value = True
            if value in ('false', 'False'):
                value = False
            setattr(options, name, value)

# -----

host = hasattr(options, 'db_host') and "host=%s" % options.db_host or ''
port = hasattr(options, 'db_port') and "port=%s" % options.db_port or ''
name = "dbname=%s" % options.db_name
user = hasattr(options, 'db_user') and "user=%s" % options.db_user or ''
password = hasattr(options, 'db_password') and "password=%s" % options.db_password or ''

db = psycopg.connect('%s %s %s %s %s' % (host, port, name, user, password), serialize=0)
cr = db.cursor()

# ---------------------------------------------------------------- #
# move user id from hr_analytic_timesheet to account_analytic_line #
# ---------------------------------------------------------------- #

cr.execute("UPDATE account_analytic_line SET user_id = hr_analytic_timesheet.user_id FROM hr_analytic_timesheet WHERE hr_analytic_timesheet.line_id = account_analytic_line.id")
cr.commit()

# --------------- #
# remove old menu #
# --------------- #

while True:
    cr.execute("select id from ir_ui_menu where (id NOT IN (select parent_id from ir_ui_menu where parent_id is not null)) and (id NOT IN (select res_id from ir_values where model='ir.ui.menu'))")
    if not cr.rowcount:

View more ways to use psycopg

Psycopg 3: PostgreSQL database adapter for Python

Psycopg 3 is a modern implementation of a PostgreSQL adapter for Python.

This distribution contains the pure Python package psycopg.

Note

Despite the lack of number in the package name, this package is the successor of psycopg2.

Please use the psycopg2 package if you are maintaining an existing program using psycopg2 as a dependency. If you are developing something new, Psycopg 3 is the most current implementation of the adapter.

Installation

In short, run the following:

pip install --upgrade pip           # to upgrade pip
pip install "psycopg[binary,pool]"  # to install package and dependencies

If something goes wrong, and for more information about installation, please check out the Installation documentation.

Hacking

For development information check out the project readme.

FAQs

What is psycopg?

PostgreSQL database adapter for Python. Visit Snyk Advisor to see a full health score report for psycopg, including popularity, security, maintenance & community analysis.

Is psycopg popular?

The python package psycopg receives a total of 1,671,285 weekly downloads. As such, psycopg popularity was classified as a key ecosystem project. Visit the popularity section on Snyk Advisor to see the full health analysis.

Is psycopg well maintained?

We found that psycopg demonstrated a healthy version release cadence and project activity. It has a community of 70 open source contributors collaborating on the project. See the full package health analysis to learn more about the package maintenance status.

Is psycopg safe to use?

The python package psycopg was scanned for known vulnerabilities and missing license, and no issues were found. Thus the package was deemed as safe to use. See the full health analysis review.

Last updated on 21 November-2024, at 13:26 (UTC).

Build a secure application checklist

Select a recommended open source package

Minimize your risk by selecting secure & well maintained open source packages

DONE

Scan your app for vulnerabilities

Scan your application to find vulnerabilities in your: source code, open source dependencies, containers and configuration files

SCAN NOW

Fix identified vulnerabilities

Easily fix your code by leveraging automatically generated PRs

AUTO FIX

Monitor for new issues

New vulnerabilities are discovered every day. Get notified if your application is affected

MONITOR APP

psycopg

PostgreSQL database adapter for Python For more information about how to use this package see README

Ensure you're using the healthiest python packages

Package Health Score

Explore Similar Packages

Popularity

Direct Usage Popularity

Security

Security and license risk for latest version

Non-Permissive License

Maintenance

Commit Frequency

Community

Embed Package Health Score Badge

Keep your project healthy

Check your requirements.txt

Snyk Vulnerability Scanner

Package

Not sure how to use psycopg?

Psycopg 3: PostgreSQL database adapter for Python

Installation

Hacking

FAQs

What is psycopg?

Is psycopg popular?

Is psycopg well maintained?

Is psycopg safe to use?

Build a secure application checklist

Select a recommended open source package

Scan your app for vulnerabilities

Fix identified vulnerabilities

Monitor for new issues

Package Health Score

Explore Similar Packages

Direct Usage Popularity

Security and license risk for latest version

Commit Frequency

Embed Package Health Score Badge

Keep your project healthy

Check your requirements.txt

Snyk Vulnerability Scanner

Not sure how to use psycopg?

Psycopg 3: PostgreSQL database adapter for Python

Installation

Hacking

FAQs

What is psycopg?

Is psycopg popular?

Is psycopg well maintained?

Is psycopg safe to use?

Build a secure application checklist

Select a recommended open source package

Scan your app for vulnerabilities

Source Code

Open Source

Container

Config

Fix identified vulnerabilities

Monitor for new issues