Auditing tool for postgres best practices
Project description
PgDont
PgDont help to quickly check a database against the "Don't Do This". It's more of an audit tool than a linter, but it alse can be use this way.
Usage
pgdont --dsn "host=localhost dbname=mydb user=john password=pass"
Implemented rules
PgDont will check for the followings bad practices :
- Upper case table name
- Upper case column name
- Use of 'SQL_ASCII' encoding
- Use of Postgres Rules
- Use of inherited tables
...
Todo
- Implement missing rules
- Add config file
- Manage multi-schema
- Cleaner output summary
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
pgDont-0.0.2.tar.gz
(5.5 kB
view details)
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
pgDont-0.0.2-py3-none-any.whl
(10.3 kB
view details)
File details
Details for the file pgDont-0.0.2.tar.gz.
File metadata
- Download URL: pgDont-0.0.2.tar.gz
- Upload date:
- Size: 5.5 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.2.0 pkginfo/1.5.0.1 requests/2.24.0 setuptools/50.3.0 requests-toolbelt/0.9.1 tqdm/4.50.0 CPython/3.8.5
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
c4d0081f1ea438a6678b93bd8e0486468d2b9f0464b227e8c075df7bfe417600
|
|
| MD5 |
0434d2c756bf5d563cbcc7b75cd686fa
|
|
| BLAKE2b-256 |
9bb3e1bb9d472014bd6d66eba9048600615a1a1c2fa6bf0c5f644f1660dc6f3b
|
File details
Details for the file pgDont-0.0.2-py3-none-any.whl.
File metadata
- Download URL: pgDont-0.0.2-py3-none-any.whl
- Upload date:
- Size: 10.3 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.2.0 pkginfo/1.5.0.1 requests/2.24.0 setuptools/50.3.0 requests-toolbelt/0.9.1 tqdm/4.50.0 CPython/3.8.5
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
5f8eb34861dfb0cd7f312c269a6c6252a3d49f0ec7fd3edd5f4a159311226405
|
|
| MD5 |
58fdd710fe3badcc2135bfaf8b8f9a6e
|
|
| BLAKE2b-256 |
cfc0f6ec937ed08b45495eaea07d0250297c69078cf5a28b54c89f1d9e1fcc00
|