Skip to main content

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


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)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

pgDont-0.0.2-py3-none-any.whl (10.3 kB view details)

Uploaded Python 3

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

Hashes for pgDont-0.0.2.tar.gz
Algorithm Hash digest
SHA256 c4d0081f1ea438a6678b93bd8e0486468d2b9f0464b227e8c075df7bfe417600
MD5 0434d2c756bf5d563cbcc7b75cd686fa
BLAKE2b-256 9bb3e1bb9d472014bd6d66eba9048600615a1a1c2fa6bf0c5f644f1660dc6f3b

See more details on using hashes here.

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

Hashes for pgDont-0.0.2-py3-none-any.whl
Algorithm Hash digest
SHA256 5f8eb34861dfb0cd7f312c269a6c6252a3d49f0ec7fd3edd5f4a159311226405
MD5 58fdd710fe3badcc2135bfaf8b8f9a6e
BLAKE2b-256 cfc0f6ec937ed08b45495eaea07d0250297c69078cf5a28b54c89f1d9e1fcc00

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page