Blockchain Audit System

Name: Blockchain Audit System
Author: Harshil Patel

Full-Stack Developer · Database Design · 2026

Blockchain-inspired DBMS audit dashboard with controlled transactions, hash-linked blocks, and integrity verification.

Problem

A normal transaction table records the latest database state but does not make silent historical changes obvious. The academic brief called for a database-centered audit trail where tampering could be detected instead of merely logged.

Approach

Built a React dashboard and Node.js backend around PostgreSQL/Supabase functions. Transactions are written through controlled operations, converted into hash-linked audit blocks, and checked by a verification function that detects a broken chain. This is a blockchain-inspired database design, not a decentralized blockchain network.

Features

Hash-linked audit blocks — Each audit block stores its own hash and the previous block hash, making historical changes detectable.
Controlled fund transfers — Wallet and transfer operations validate balances before writing the transaction and its audit record.
Database integrity checks — PostgreSQL functions create blocks and verify the full chain instead of leaving core rules in the interface.
Operational dashboard — Wallets, transactions, blocks, fraud signals, and quick transfers are presented in one inspectable interface.

Outcome

Delivered a working academic DBMS system with a public dashboard and source repository, while keeping the blockchain claim scoped to tamper-evident database auditing.

Stack

React 19, Node.js, Supabase, PostgreSQL

Links

Live site · GitHub

All projects · Harshil Patel

Blockchain Audit System — Harshil Patel