Panduan Backend Engineer: Buku Besar Poin Loyalitas Double-Entry & Dompet Digital Multi-Mata Uang di Go & PostgreSQL

Menyimpan saldo dompet digital atau poin loyalitas hanya sebagai satu kolom angka tanpa tabel jurnal mutasi yang bersifat append-only sangat rentan terhadap kondisi balapan (race condition) saat penukaran poin berlangsung bersamaan. Sebagai Senior Backend Engineer di Go (Golang) dan PostgreSQL, saya merancang mesin buku besar dengan kunci baris `SELECT ... FOR UPDATE`, kunci idempotensi unik, serta konsumsi poin kedaluwarsa berbasis antrean FIFO.


⚡ Sewa Aldian Fazrihady — Senior Cloud, GCP, Backend, AI Application & Full Stack Engineer

Butuh arsitektur cloud, infrastruktur GCP/AWS, sistem backend berkecepatan tinggi, agen AI, atau pengembangan web full stack? Pesan Layanan Pemrograman 1 Hari seharga Rp 1.000.000 (QRIS / Virtual Account Bank) atau $100 USD (Kartu Internasional), atau sewa melalui Upwork:

Pesan Sprint 1 Hari (Rp 1 Juta / $100) → Sewa di Upwork (100% Job Success) →

Implementasi Kode Produksi & Konfigurasi Teknis

Berikut adalah implementasi kode produksi lengkap dan konfigurasi teknis untuk arsitektur Panduan Backend Engineer: Buku Besar Poin Loyalitas & Dompet Digital di Go & PostgreSQL:

package ledger

import (
	"context"
	"database/sql"
	"errors"
)

var ErrInsufficientFunds = errors.New("insufficient wallet balance")

func RedeemPointsTx(ctx context.Context, db *sql.DB, idempotencyKey string, accountID int64, amount int64) error {
	tx, err := db.BeginTx(ctx, &sql.TxOptions{Isolation: sql.LevelReadCommitted})
	if err != nil {
		return err
	}
	defer tx.Rollback()

	var currentBalance int64
	err = tx.QueryRowContext(
		ctx,
		`SELECT balance FROM wallet_accounts WHERE id = $1 FOR UPDATE`,
		accountID,
	).Scan(&currentBalance)
	if err != nil {
		return err
	}
	if currentBalance < amount {
		return ErrInsufficientFunds
	}

	_, err = tx.ExecContext(
		ctx,
		`INSERT INTO wallet_ledger_entries (idempotency_key, account_id, delta_amount, created_at)
		 VALUES ($1, $2, $3, NOW())`,
		idempotencyKey, accountID, -amount,
	)
	if err != nil {
		return err
	}

	_, err = tx.ExecContext(
		ctx,
		`UPDATE wallet_accounts SET balance = balance - $1, updated_at = NOW() WHERE id = $2`,
		amount, accountID,
	)
	if err != nil {
		return err
	}
	return tx.Commit()
}

Checklist Arsitektur Produksi (Backend Engineer)

Dalam menerapkan solusi Panduan Backend Engineer: Buku Besar Poin Loyalitas & Dompet Digital di Go & PostgreSQL (Backend Engineer, Golang Backend Engineer, PostgreSQL, FinTech Ledger, Digital Wallet, Concurrency Control, Distributed Systems, Aldian Fazrihady) pada lingkungan produksi berskala enterprise sebagai Backend Engineer, pastikan standar rekayasa berikut terpenuhi:


About the Author — Hire Aldian Fazrihady (Cloud Engineer, GCP Professional Cloud Architect, GCP Professional Data Engineer, Backend, AI & Full Stack Engineer)

Aldian Fazrihady is a Top-Rated Senior Cloud Engineer, GCP Professional Cloud Architect (Google Cloud Certified), GCP Professional Data Engineer (Google Cloud Certified), Backend Engineer (Python, Django, FastAPI, Go, PostgreSQL), AI Application Engineer (LLMs, RAG, MCP, Google ADK, LangGraph), and Full Stack Engineer (React, Next.js, TypeScript) with 15+ years of production software engineering experience.

Hire Aldian Fazrihady on Upwork | Book 1-Day Programming Service ($100 USD / Rp 1.000.000) | View Live AI Portfolio | Send a Direct Message

Related Engineering Articles

Engineering Role Pillar Guides & Category Hubs