Databases

SQL Server, Postgres, Supabase, and data sync architecture

Databases

Building a Windows Service for Bidirectional SQL Server ↔ Supabase Sync

This is the technical sequel to my SQL Server to Supabase post. There I argued that coexistence — both databases live, data flowing between them — deserves its own workstream. This is what that workstream looks like as an actual build: a VB.NET Windows Service that syncs bidirectionally between an on-

Migrations

SQL Server to Supabase: What Nobody Tells You

Supabase pitches itself as the fastest way to get a Postgres backend, and it mostly delivers. But if your starting point is SQL Server — as it is for a lot of Microsoft-stack teams — the migration guides skip over the parts that actually consume your week. Having gone through this