supa_audit
bemi
Our great sponsors
| supa_audit | bemi | |
|---|---|---|
| 4 | 4 | |
| 610 | 135 | |
| 2.5% | 65.2% | |
| 5.0 | 8.2 | |
| 4 months ago | 2 days ago | |
| PLpgSQL | TypeScript | |
| Apache License 2.0 | 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.
supa_audit
-
Implementing system-versioned tables in Postgres
this approach is also available as an extension here:
https://github.com/supabase/supa_audit
it uses a slightly more generic implementation so that you can easily turn on/off auditing. i.e.
select audit.enable_tracking('public.account'::regclass); - Table Auditing in PostgreSQL with Supa_audit
- Postgres Auditing in 150 lines of SQL
bemi
-
The Guide to PostgreSQL Data Change Tracking
Hey I'm one of the maintainers of https://github.com/BemiHQ/bemi that was recommended in the article. Please feel free to ask me any questions!
- Bemi: Automatic data change tracking for PostgreSQL
-
Implementing system-versioned tables in Postgres
This is actually what we're @ Bemi https://bemi.io/
We're hoping to make it so that this becomes automatic with Postgres vs moving to specialized databases.
We recently open sourced the core tech that implements system versioned tables https://github.com/BemiHQ/bemi, check it out if interested :)
What are some alternatives?
audit-trigger - Simple, easily customised trigger-based auditing for PostgreSQL (Postgres). See also pgaudit.
supabase - The open source Firebase alternative.
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.
drizzle-pg-notify-audit-table - example project of using pg-notify and custom trigger for audit table
audit-trigger - Simple, easily customised trigger-based auditing for PostgreSQL (Postgres). See also pgaudit.
bemi-prisma - Automatic data change tracking for Prisma
sgr - sgr (command line client for Splitgraph) and the splitgraph Python library