Package Health Score

81 / 100

security
No known security issues
popularity
Small
maintenance
Healthy
community
Active

Popularity

Small

GitHub Stars: 28.64K
Forks: 809
Contributors: 250

Direct Usage Popularity

Based on project statistics from the GitHub repository for the PyPI package duckdb-appender, we found that it has been starred 28,635 times.

Security

No known security issues

Security and license risk for latest version

Release Date: Nov 20, 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

Apache-2.0

Security Policy

We found a way for you to contribute to the project! Looks like duckdb-appender 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: 994
Open PR: 75
Last Release: 1 month ago
Last Commit: 17 days ago

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

We found that duckdb-appender 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: 250
Funding: No

A good and healthy external contribution signal for duckdb-appender project, which invites more than one hundred open source maintainers to collaborate on the repository.

We found a way for you to contribute to the project! Looks like duckdb-appender 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.9

Age: 1 month
Latest Release: 1 month ago
Dependencies: 0 Direct
Versions: 1
Maintainers: 0
Wheels: OS Independent

Readme

DuckDB PyAppender

A DuckDB appender for Python.

Installation

Usage

import duckdb
from duckdb_appender import Appender

conn = duckdb.connect()

appender = Appender(conn, schema="main", table="users")
appender.append_row([1, "John"])
appender.append_row([2, "Doe"])
appender.close()

# Can also use it with context manager:
with Appender(conn, schema="main", table="users") as appender:
  appender.append_row([3, "foo"])

See more in the /examples folder.

Why use this

Much faster than simple INSERT statements.
Versus storing data in a pandas DataFrame and load into DuckDB: while pandas loads the entire dataset into memory, this appender uses SQLite as a buffer that regularly flush itself (every 204,800 rows, similar to the official C++ appender)
- This prevents memory overload on large data aggregation.
- A little bit of crash protection - since it commits data every 204,800 rows, you'll preserve most of your progress if something goes wrong.

Local development

This repo uses uv to manage dependencies and virtual environment. Dependencies are written in pyproject.toml, so other tools supporting it can be used as well.

Run test

This repo use pytest. To run tests within an uv environment, run:

uv run pytest

FAQs

What is duckdb-appender?

A DuckDB appender for Python. Visit Snyk Advisor to see a full health score report for duckdb-appender, including popularity, security, maintenance & community analysis.

Is duckdb-appender popular?

We’re still processing downloads data for the python package duckdb-appender. Visit the popularity section on Snyk Advisor to see the full popularity analysis.

Is duckdb-appender well maintained?

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

Is duckdb-appender safe to use?

The python package duckdb-appender 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 December-2024, at 09:30 (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

duckdb-appender

A DuckDB appender for Python For more information about how to use this package see README

Ensure you're using the healthiest python packages

Package Health Score

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

DuckDB PyAppender

Installation

Usage

Why use this

Local development

Run test

FAQs

What is duckdb-appender?

Is duckdb-appender popular?

Is duckdb-appender well maintained?

Is duckdb-appender 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

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

DuckDB PyAppender

Installation

Usage

Why use this

Local development

Run test

FAQs

What is duckdb-appender?

Is duckdb-appender popular?

Is duckdb-appender well maintained?

Is duckdb-appender 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