Back to results
kvesteri/postgresql-audit(opens in a new tab)
Language: Python
Audit trigger for PostgreSQL
- stars
- 139
- watchers
- 9
- forks
- 27
- open issues
- 18
- Last updated
- 10/24/2026
gem-hunterLanguage: Python
Audit trigger for PostgreSQL
Auditing extension for PostgreSQL. Provides additional extensions for SQLAlchemy and Flask. PostgreSQL-Audit tries to combine the best of breed from existing solutions such as SQLAlchemy-Continuum, Papertrail and especially Audit Trigger by 2nd Quadrant.
Compared to existing solutions PostgreSQL-Audit has the following charasteristics:
pip install PostgreSQL-Audit
git clone https://github.com/kvesteri/postgresql-audit.git cd postgresql-audit pip install tox createdb postgresql_audit_test tox
from postgresql_audit.flask import versioning_manager from my_app.extensions import db versioning_manager.init(db.Model) class Article(db.Model): __tablename__ = 'article' __versioned__ = {} # <- IMPORTANT! id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String) article = Article(name='Some article') db.session.add(article) db.session.commit()
Now we can check the newly created activity.
Activity = versioning_manager.activity_cls activity = Activity.query.first() activity.id # 1 activity.table_name # 'article' activity.verb # 'insert' activity.old_data # None activity.changed_data # {'id': '1', 'name': 'Some article'}
article.name = 'Some other article' db.session.commit() activity = Activity.query.order_by(db.desc(Activity.id)).first() activity.id # 2 activity.table_name # 'article' activity.verb # 'update' activity.old_data # {'id': '1', 'name': 'Some article'} activity.changed_data # {'name': 'Some other article'}
db.session.delete(article) db.session.commit() activity = Activity.query.order_by(db.desc(Activity.id)).first() activity.id # 3 activity.table_name # 'article' activity.verb # 'delete' activity.old_data # {'id': '1', 'name': 'Some other article'} activity.changed_data # None