Package Health Score

76 / 100

security
Security review needed
popularity
Popular
maintenance
Sustainable
community
Active

Explore Similar Packages

Popularity

Popular

GitHub Stars: 439
Forks: 132
Contributors: 70

Direct Usage Popularity

Based on project statistics from the GitHub repository for the PyPI package clickhouse-sqlalchemy, we found that it has been starred 439 times.

Security

Security review needed

Security and license risk for latest version

Release Date: Jun 12, 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
1
M
0
L

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

License

MIT

Security Policy

We found a way for you to contribute to the project! Looks like clickhouse-sqlalchemy 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

Sustainable

Commit Frequency

Open Issues: 74
Open PR: 11
Last Release: 5 months ago
Last Commit: 28 days ago

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

We found that clickhouse-sqlalchemy demonstrates a positive version release cadence with at least one new version released in the past 12 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

Active

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

With more than 10 contributors for the clickhouse-sqlalchemy 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 clickhouse-sqlalchemy 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: <4,>=3.7

Age: 8 years
Latest Release: 1 month ago
Dependencies: N/A
Versions: 33
Maintainers: 1
Wheels: No

Readme

ClickHouse SQLAlchemy

ClickHouse dialect for SQLAlchemy to ClickHouse database.

Documentation

Documentation is available at .

Usage

Supported interfaces:

native [recommended] (TCP) via clickhouse-driver <https://github.com/mymarilyn/clickhouse-driver>
async native (TCP) via asynch <https://github.com/long2ice/asynch>
http via requests

Define table

> python > from sqlalchemy import create_engine, Column, MetaData > > from clickhouse_sqlalchemy import ( > Table, make_session, get_declarative_base, types, engines > ) > > uri = 'clickhouse+native://localhost/default' > > engine = create_engine(uri) > session = make_session(engine) > metadata = MetaData(bind=engine) > > Base = get_declarative_base(metadata=metadata) > > class Rate(Base): > day = Column(types.Date, primary_key=True) > value = Column(types.Int32) > > __table_args__ = ( > engines.Memory(), > ) > > Rate.__table__.create() >

Insert some data

> python > from datetime import date, timedelta > > from sqlalchemy import func > > today = date.today() > rates = [ > {'day': today - timedelta(i), 'value': 200 - i} > for i in range(100) > ] >

And query inserted data

> python > session.execute(Rate.__table__.insert(), rates) > > session.query(func.count(Rate.day)) \ > .filter(Rate.day > today - timedelta(20)) \ > .scalar() >

License

ClickHouse SQLAlchemy is distributed under the MIT license.

FAQs

What is clickhouse-sqlalchemy?

Simple ClickHouse SQLAlchemy Dialect. Visit Snyk Advisor to see a full health score report for clickhouse-sqlalchemy, including popularity, security, maintenance & community analysis.

Is clickhouse-sqlalchemy popular?

The python package clickhouse-sqlalchemy receives a total of 221,581 weekly downloads. As such, clickhouse-sqlalchemy popularity was classified as a popular. Visit the popularity section on Snyk Advisor to see the full health analysis.

Is clickhouse-sqlalchemy well maintained?

We found indications that clickhouse-sqlalchemy maintenance is sustainable demonstrating some project activity. We saw a total of 70 open source contributors collaborating on the project. See the full package health analysis to learn more about the package maintenance status.

Is clickhouse-sqlalchemy safe to use?

While scanning the latest version of clickhouse-sqlalchemy, we found that a security review is needed. A total of 0 vulnerabilities or license issues were detected. See the full security scan results.

Last updated on 22 November-2024, at 18:12 (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

clickhouse-sqlalchemy

Simple ClickHouse SQLAlchemy Dialect 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

Maintenance

Commit Frequency

Community

Embed Package Health Score Badge

Keep your project healthy

Check your requirements.txt

Snyk Vulnerability Scanner

Package

Readme

ClickHouse SQLAlchemy

Documentation

Usage

License

FAQs

What is clickhouse-sqlalchemy?

Is clickhouse-sqlalchemy popular?

Is clickhouse-sqlalchemy well maintained?

Is clickhouse-sqlalchemy 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

Readme

ClickHouse SQLAlchemy

Documentation

Usage

License

FAQs

What is clickhouse-sqlalchemy?

Is clickhouse-sqlalchemy popular?

Is clickhouse-sqlalchemy well maintained?

Is clickhouse-sqlalchemy 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