feat(infra): integrate Cloudflare Hyperdrive with Supabase and Prisma adapter (!30) · Merge Requests · ThinhNC / finwise-miniapp-be

feat(infra): integrate Cloudflare Hyperdrive with Supabase and Prisma adapter

Overview

Integrates Cloudflare Hyperdrive (`finwise-db`, ID: `2e364c7ca4ef490da2e03e40a8b4cb32`) to provide edge-accelerated, connection-pooled database access to Supabase PostgreSQL for the FinWise backend.

Key Changes

Wrangler & Edge Configuration:
- Added wrangler.toml with [[hyperdrive]] binding and local connection string fallback.
- Added src/worker.ts as the Cloudflare Worker edge entrypoint with /health diagnostic endpoints.
- Updated .gitignore to ignore .wrangler/ build artifacts and .dev.vars.
Prisma & Database Driver Adapter:
- Enabled driverAdapters preview feature in prisma/schema.prisma.
- Installed @prisma/adapter-pg and pg for Edge runtime driver compatibility.
- Implemented dynamic runtime detection and lazy initialization in src/database/prisma.client.ts (supports both Node.js Express server and Cloudflare Edge Worker isolates).
Scripts & Environment:
- Added wrangler:dev, wrangler:dev:remote, and wrangler:deploy scripts in package.json.
- Added TypeScript environment definitions in src/types/worker-env.ts.

### Overview
Integrates **Cloudflare Hyperdrive** (`finwise-db`, ID: `2e364c7ca4ef490da2e03e40a8b4cb32`) to provide edge-accelerated, connection-pooled database access to Supabase PostgreSQL for the FinWise backend.
---
### Key Changes
1. **Wrangler & Edge Configuration**:
   - Added `wrangler.toml` with `[[hyperdrive]]` binding and local connection string fallback.
   - Added `src/worker.ts` as the Cloudflare Worker edge entrypoint with `/health` diagnostic endpoints.
   - Updated `.gitignore` to ignore `.wrangler/` build artifacts and `.dev.vars`.
2. **Prisma & Database Driver Adapter**:
   - Enabled `driverAdapters` preview feature in `prisma/schema.prisma`.
   - Installed `@prisma/adapter-pg` and `pg` for Edge runtime driver compatibility.
   - Implemented dynamic runtime detection and lazy initialization in `src/database/prisma.client.ts` (supports both Node.js Express server and Cloudflare Edge Worker isolates).
3. **Scripts & Environment**:
   - Added `wrangler:dev`, `wrangler:dev:remote`, and `wrangler:deploy` scripts in `package.json`.
   - Added TypeScript environment definitions in `src/types/worker-env.ts`.