Package Health Score

60 / 100

security
No known security issues
popularity
Small
maintenance
Inactive
community
Active

Explore Similar Packages

PyMySQL
93

Popularity

Small

GitHub Stars: 7.68K
Forks: 1.43K
Contributors: 120

Direct Usage Popularity

Based on project statistics from the GitHub repository for the PyPI package dictmysql, we found that it has been starred 7,676 times.

Security

No known security issues

Security and license risk for latest version

Release Date: Jul 16, 2018
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

MIT

Security Policy

Yes

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

Inactive

Commit Frequency

Open Issues: 14
Open PR: 4
Last Release: 6 years ago
Last Commit: 2 months ago

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

An important project maintenance signal to consider for dictmysql is that it hasn't seen any new versions released to PyPI in the past 12 months, and could be considered as a discontinued project, or that which receives low attention from its maintainers.

In the past month we didn't find any pull request activity or change in issues status has been detected for the GitHub repository.

Community

Active

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

A good and healthy external contribution signal for dictmysql 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 dictmysql 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: ==2.6.*, ==2.7.*, ==3.1.*, ==3.2.*, ==3.3.*, ==3.4.*, ==3.5.*, ==3.6.*

Age: 9 years
Latest Release: 6 years ago
Dependencies: N/A
Versions: 23
Maintainers: 0
Wheels: No

Readme

DictMySQL

PyPI page:

Documentation:

Introduction

DictMySQL is a MySQL query builder on the top of PyMySQL. It allows convenient database manipulation with Python dictionary.

DictMySQL simplifies and unifies the input/output of MySQL queries, by allowing passing values and conditions in dictionary into database. With DictCursor, you can even have a dict-in, dict-out mysql connector.

To install:

pip install dictmysql

Quick example:

from dictmysql import DictMySQL
db = DictMySQL(db='occupation', host='127.0.0.1', user='root', passwd='')

db.select(table='jobs',
          columns=['id','value'],
          where={'$OR': [{'value': {'$LIKE': 'Artist%'}}, {'id': 10}]})
# SELECT `id`, `value` FROM `jobs` WHERE (`value` LIKE "Artist%") OR (`id` = 10);

With DictCursor:

from dictmysql import DictMySQL, cursors
db = DictMySQL(db='occupation', host='127.0.0.1', user='root', passwd='', 
               cursorclass=cursors.DictCursor)

db.select(table='jobs',
          columns=['id','value'],
          limit=2)
# returns [{u'id': 1, u'value': u'Artist'}, {u'id': 2, u'value': u'Engineer'}]

Future Works

Full support of CRUD
Better documents

License

DictMySQL uses the MIT license, see LICENSE file for the details.

FAQs

What is dictmysql?

A MySQL class for more convenient database manipulations with Python dictionary. Visit Snyk Advisor to see a full health score report for dictmysql, including popularity, security, maintenance & community analysis.

Is dictmysql popular?

The python package dictmysql receives a total of 152 weekly downloads. As such, dictmysql popularity was classified as small. Visit the popularity section on Snyk Advisor to see the full health analysis.

Is dictmysql well maintained?

We found indications that dictmysql is an Inactive project. See the full package health analysis to learn more about the package maintenance status.

Is dictmysql safe to use?

The python package dictmysql 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 19 December-2024, at 13:40 (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

dictmysql

A MySQL class for more convenient database manipulations with Python dictionary. 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

DictMySQL

Introduction

Future Works

License

FAQs

What is dictmysql?

Is dictmysql popular?

Is dictmysql well maintained?

Is dictmysql 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

DictMySQL

Introduction

Future Works

License

FAQs

What is dictmysql?

Is dictmysql popular?

Is dictmysql well maintained?

Is dictmysql 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