clickhouse-sqlalchemy

v0.2.1

Simple ClickHouse SQLAlchemy Dialect

PyPI

README

GitHub

MIT

Latest version published 14 days ago

    pip install clickhouse-sqlalchemy

We couldn't find any similar packages Browse all packages

Package Health Score

85 / 100

Security
No known security issues
Popularity
Popular
Maintenance
Healthy
Community
Active

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

Secure Your Project

Find & fix vulnerable dependencies and insecure code

Popularity

Popular

Total Weekly Downloads (154,047)

Dependents: 0
GitHub Stars: 257
Forks: 65
Contributors: 40

Direct Usage Popularity

The PyPI package clickhouse-sqlalchemy receives a total of 154,047 downloads a week. As such, we scored clickhouse-sqlalchemy popularity level to be Popular.

Based on project statistics from the GitHub repository for the PyPI package clickhouse-sqlalchemy, we found that it has been starred 257 times, and that 0 other projects in the ecosystem are dependent on it.

The download numbers shown are the average weekly downloads from the last 6 weeks.

Security

No known security issues

Security and license risk for latest version

Release Date: Jun 13, 2022
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

Healthy

Commit Frequency

Open Issues: 29
Open PR: 0
Last Release: 14 days ago
Last Commit: 10 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 Healthy.

We found that clickhouse-sqlalchemy 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

Active

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

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

Package

Python Versions Compatibility: >=3.6, <4

Age: 5 years
Latest Release: 14 days ago
Dependencies: 16 Total
Versions: 23
Maintainers: 1
Wheels: No

Readme

ClickHouse SQLAlchemy

ClickHouse dialect for SQLAlchemy to ClickHouse database.

Documentation

Documentation is available at https://clickhouse-sqlalchemy.readthedocs.io.

Usage

Supported interfaces:

native [recommended] (TCP) via clickhouse-driver
http via requests

Define table

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

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

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 154,047 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 that clickhouse-sqlalchemy demonstrated a healthy version release cadence and project activity. It has a community of 40 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?

The python package clickhouse-sqlalchemy 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 24 June-2022, at 14:43 (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

Package Health Score

Keep your project healthy

Check your requirements.txt

Snyk Vulnerability Scanner

Secure Your Project

Total Weekly Downloads (154,047)

Direct Usage Popularity

Security and license risk for latest version

Commit Frequency

Embed Package Health Score Badge

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