postgresql-audit | Audit trigger for PostgreSQL | SQL Database library

by kvesteri Python Version: 0.17.1 License: BSD-2-Clause

X-Ray Key Features Code Snippets Community Discussions(1)Vulnerabilities Install Support

kandi X-RAY | postgresql-audit Summary

postgresql-audit is a Python library typically used in Database, SQL Database, PostgresSQL applications. postgresql-audit has no bugs, it has no vulnerabilities, it has build file available, it has a Permissive License and it has low support. You can install using 'pip install postgresql-audit' or download it from GitHub, PyPI.

Audit trigger for PostgreSQL

Support

Quality

Security

License

Reuse

Support

postgresql-audit has a low active ecosystem.

It has 105 star(s) with 30 fork(s). There are 10 watchers for this library.

It had no major release in the last 12 months.

There are 16 open issues and 14 have been closed. On average issues are closed in 36 days. There are 1 open pull requests and 0 closed requests.

It has a neutral sentiment in the developer community.

The latest version of postgresql-audit is 0.17.1

Quality

postgresql-audit has 0 bugs and 0 code smells.

Security

postgresql-audit has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

postgresql-audit code analysis shows 0 unresolved vulnerabilities.

There are 0 security hotspots that need review.

License

postgresql-audit is licensed under the BSD-2-Clause License. This license is Permissive.

Permissive licenses have the least restrictions, and you can use them in most projects.

Reuse

postgresql-audit releases are not available. You will need to build from source code and install.

Deployable package is available in PyPI.

Build file is available. You can build the component from source.

postgresql-audit saves you 841 person hours of effort in developing the same functionality from scratch.

It has 1930 lines of code, 162 functions and 17 files.

It has medium code complexity. Code complexity directly impacts maintainability of the code.

Top functions reviewed by kandi - BETA

kandi has reviewed postgresql-audit and discovered the below as its top functions. This is intended to give you an instant insight into postgresql-audit implemented functionality, and help decide if they suit your requirements.

Get event listeners
Render a template file
Read file contents
Configures all pending classes
Audits a table
Assign an actor
Default actor id
Returns True if the current context is available
Create Activity model
Create activity base
Return a new instance of the transaction model
Create the transaction base
Attach event listeners
Attach table listeners
Creates the audit table
Create the Operator Executor
Get the version number of the Postgres server
Default client address

Get all kandi verified functions for this library.

postgresql-audit Key Features

No Key Features are available at this moment for postgresql-audit.

postgresql-audit Examples and Code Snippets

No Code Snippets are available at this moment for postgresql-audit.

Community Discussions

Trending Discussions on postgresql-audit

Adding JSON data in audit table

QUESTION

Adding JSON data in audit table

Asked 2020-Jun-15 at 13:33

I am creating audit tables for my database using sqlalchemy-postgresql-audit but the issue is that it creates a separate audit_table for every table and I wan't to create a common audit_table for all which contains

...

ANSWER

Answered 2020-Jun-15 at 13:33

I got the answer for this When trigger is applies a RECORD for the OLD ROW in case of UPDATION and DELETION and NEW ROW in case of UPDATION and INSERTION is created i.e we can access values using

Source https://stackoverflow.com/questions/62325460

Community Discussions, Code Snippets contain sources that include Stack Exchange Network

Vulnerabilities

No vulnerabilities reported

Install postgresql-audit

You can install using 'pip install postgresql-audit' or download it from GitHub, PyPI.
You can use postgresql-audit like any standard Python library. You will need to make sure that you have a development environment consisting of a Python distribution including header files, a compiler, pip, and git installed. Make sure that your pip, setuptools, and wheel are up to date. When using pip it is generally recommended to install packages in a virtual environment to avoid changes to the system.

Support

For any new features, suggestions and bugs create an issue on GitHub. If you have any questions check and ask questions on community page Stack Overflow .

Find more information at: