Blog

Technical writing on Web3, AI, and building things. Written by Uvin Vindula.

130 articles · 5 in Supabase & PostgreSQL

Supabase Realtime in Next.js: Building Live Features

A hands-on guide to building live features with Supabase Realtime in Next.js — database change subscriptions, Presence for online status, Broadcast for custom events, RLS gotchas, cleanup patterns, and the live notification system I built for uvin.lk and EuroParts Lanka.

U

Uvin Vindula·June 23, 2025

Supabase & PostgreSQL12 min

IAMUVIN

PostgreSQL Query Optimization in Supabase: Practical Patterns

A field guide to making PostgreSQL fly inside Supabase — EXPLAIN ANALYZE workflows, indexing strategies, N+1 prevention, cursor pagination, materialized views, and the exact optimization checklist I run on every project before it hits production.

U

Uvin Vindula·February 17, 2025

Supabase & PostgreSQL10 min

IAMUVIN

Supabase Edge Functions: When and How to Use Them

A practical guide to Supabase Edge Functions — when they make sense over Next.js API routes, how to set them up, writing Deno-based serverless functions for webhooks, scheduled tasks, and custom backend logic, with real examples from production projects.

U

Uvin Vindula·October 14, 2024

Supabase & PostgreSQL11 min

IAMUVIN

Supabase Row Level Security: The Patterns That Actually Work

A battle-tested guide to Supabase Row Level Security policies — SELECT, INSERT, UPDATE, DELETE patterns, auth-based policies, role-based access, multi-tenant RLS, performance tuning, and the mistakes I have made so you do not have to.

U

Uvin Vindula·August 12, 2024

Supabase & PostgreSQL12 min

IAMUVIN

Supabase Authentication: The Complete Guide for Next.js Apps

A hands-on guide to implementing Supabase Auth in Next.js 16 apps — email/password flows, OAuth providers, server-side middleware, Row Level Security, and the production gotchas I learned building uvin.lk, EuroParts Lanka, and FreshMart.

U

Uvin Vindula·July 15, 2024