Alternatives

PostgreSQL data change tracking

Below is a summary that compares the alternatives:

• PostgreSQL triggers
• Application-level tracking (paper_trail in Ruby, django-simple-history in Python, etc.)
• Change Data Capture (debezium written in Java, pgcapture written in Go, etc.)
• PgAudit extension

	Zemi	PG Triggers	App Tracking	Change Data Capture	PgAudit Logs
PostgreSQL data change tracking	✅	✅	✅	✅	❌
SQL commands tracking	❌	✅	❌	❌	✅
Reliable tracking accuracy	✅	✅	❌	✅	✅
No runtime performance impact	✅	❌	❌	✅	✅
Separate scalable storage	✅	❌	❌	✅	❌
App context (user, API req, etc.)	✅	❌	✅	❌	❌
Single binary, no JVM/runtime	✅	N/A	N/A	❌	N/A