audit-trigger
audit-trigger
audit-trigger | audit-trigger | |
---|---|---|
2 | 4 | |
10 | 651 | |
- | 0.6% | |
10.0 | 2.6 | |
over 3 years ago | 8 months ago | |
PLpgSQL | PLpgSQL | |
GNU General Public License v3.0 or later | GNU General Public License v3.0 or later |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
audit-trigger
-
Postgres Auditing in 150 lines of SQL
I've been using my own audit trigger for 3 years now.
https://github.com/cmabastar/audit-trigger
It uses the old and tested http://wiki.postgresql.org/wiki/Audit_trigger_91plus
but with JSONB instead of HSTORE, and automatically creates partitioned tables by month (Requires PG11+).
audit-trigger
-
How would you build an audit log in Rails for a high-throughput API?
If that really won't do it for you, you can try to do something lower level using postgres triggers and functions. Take a look at https://github.com/2ndQuadrant/audit-trigger as a starting point.
-
Postgres Auditing in 150 lines of SQL
Related project: https://github.com/2ndQuadrant/audit-trigger
What are some alternatives?
supa_audit - Generic Table Auditing
sgr - sgr (command line client for Splitgraph) and the splitgraph Python library
Logidze - Database changes log for Rails
yugabyte-db - YugabyteDB - the cloud native distributed SQL database for mission-critical applications.
sirix - SirixDB is an an embeddable, bitemporal, append-only database system and event store, storing immutable lightweight snapshots. It keeps the full history of each resource. Every commit stores a space-efficient snapshot through structural sharing. It is log-structured and never overwrites data. SirixDB uses a novel page-level versioning approach.
pg-history-viewer - QGIS plugin that helps visualize contents of a PostgreSQL audit trigger table