Iurii Uses: #Drizzle ORM

kri.rocks – Booking Website and Online Scheduling SaaS for Beauty Businesses

Vertical SaaS that gives a salon, barbershop or solo beauty specialist their own booking website in minutes.

HTPBE.TECH – Internal Admin Dashboard

Role-gated admin dashboard for the HTPBE? SaaS platform – real-time KPIs, per-user quota tracking, and a zero-dependency bar chart.

vatnode.dev – EU VAT Validation API

Developer-first SaaS API for EU VAT validation via VIES with Redis caching, change monitoring, and webhook notifications.

HTPBE.TECH – Has This PDF Been Edited?

SaaS platform for PDF authenticity verification with a public REST API.

Prevent double booking in PostgreSQL without UNIQUE or EXCLUDE: advisory locks, an overlap check, and when EXCLUDE is the right choice.

Race condition testing with real PostgreSQL: readiness gates, observed lock waits, provider stubs, and the false confidence a timed assertion can give.

API key management for a public SaaS: hashing keys at rest, prefix + last-4 display, fail-closed validation, and revocation.

Build an internal CRM on Supabase: schema, RLS policies, Next.js App Router frontend, realtime subscriptions, and an honest look at where the weekend ends.

Multi-tenant SaaS database design: shared schema with RLS, schema-per-tenant, and database-per-tenant – trade-offs, real pitfalls, and when to use each.

PostgreSQL production patterns: UUID v7, soft deletes, RLS for multi-tenant SaaS, partial and covering indexes, PgBouncer pooling and migration discipline.

Real-time Next.js admin dashboard: TanStack Query polling, Zustand for filter state, Sentry error boundaries per panel, and a zero-dependency bar chart.

UUID v7 vs v4 in PostgreSQL: why random UUIDs fragment B-tree indexes, how UUID v7 fixes it, benchmarks at 5M rows, and Drizzle ORM migration steps.

40+ point production SaaS checklist: auth, Stripe billing, PostgreSQL, rate limiting, email, monitoring, and security – with honest 8-week build estimates.

Stripe webhook production architecture: idempotency keys in PostgreSQL and Redis, a BullMQ queue, and signature verification in Next.js App Router.

Turborepo monorepo with Next.js and Hono, sharing one set of TypeScript types across frontend and backend.