Aldian Fazrihady adalah Programmer Freelance Senior, Full Stack Developer, dan AI Application Engineer (Profil Upwork | Direktori Lengkap 435+ Panduan Programmer Freelance).
Regulated FinTech, Healthcare, LegalTech, and GovTech platforms that must answer *"Who changed this record, from what old value to what new value, at what exact microsecond, and why?"* frequently search to hire a freelance Event Sourcing, CQRS & immutable audit log programmer. I am Aldian Fazrihady, a Senior Freelance Backend & Systems Architect available via Upwork.
Core Event Sourcing, Bi-Temporal SQL & Audit Trail Capabilities
- Zero-Overhead PostgreSQL Trigger & Logical Decoding Audit Trails: Capturing `OLD` and `NEW` JSONB row diffs alongside authenticated actor ID, IP address, and request correlation ID inside partitioned append-only audit tables.
- Pragmatic Event Sourcing & CQRS in Go and Python: Persisting domain events (`OrderPlaced`, `InvoiceApproved`, `LimitAdjusted`) with optimistic concurrency version checks (`UNIQUE (stream_id, version)`) and projecting read-optimized SQL views.
- Cryptographic Hash-Chained Tamper Evidence: Linking each audit log entry to the SHA-256 hash of the preceding entry (`prev_hash`) so any unauthorized database tampering is immediately detectable during SOC 2 / HIPAA / financial audits.
Frequently Asked Questions
Do we need a specialized database for Event Sourcing, or can we use PostgreSQL?
PostgreSQL with partitioned append-only tables, `BIGSERIAL` global ordering, and transactional outbox projections is one of the most battle-tested, operationally simple Event Sourcing stores in production.
How can we hire you for Event Sourcing or compliance audit-log architecture?
Reach out on Upwork.