audit-trigger
Simple, easily customised trigger-based auditing for PostgreSQL (Postgres). See also pgaudit. (by 2ndQuadrant)
pg-history-viewer
QGIS plugin that helps visualize contents of a PostgreSQL audit trigger table (by qwat)
Our great sponsors
| audit-trigger | pg-history-viewer | |
|---|---|---|
| 4 | 1 | |
| 649 | 16 | |
| 0.9% | - | |
| 2.6 | 10.0 | |
| 8 months ago | over 3 years ago | |
| PLpgSQL | Python | |
| GNU General Public License v3.0 or later | - |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
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.
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
Posts with mentions or reviews of audit-trigger.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-01-27.
-
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
pg-history-viewer
Posts with mentions or reviews of pg-history-viewer.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-03-27.
-
Postgres Auditing in 150 lines of SQL
And for a practical use case for geography software, a history viewer for qgis: https://github.com/qwat/pg-history-viewer
What are some alternatives?
When comparing audit-trigger and pg-history-viewer you can also consider the following projects:
supa_audit - Generic Table Auditing
Logidze - Database changes log for Rails
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.
audit-trigger - Simple, easily customised trigger-based auditing for PostgreSQL (Postgres). See also pgaudit.