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 hashes)

Uploaded Source

Built Distribution

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

Uploaded Python 3

Supported by

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