Engineering

Local-First Data Architectures for Vue 3, Nuxt 4 and Postgres

A structured learning plan covering sync engines, CRDTs, client-side storage, authorization, and schema design for building local-first applications with Vue 3, Nuxt 4, and Postgres.

8 modules

Local-First Foundations

What it means for data to live on the client, and why sync becomes your new architecture

Sync Engines for Postgres: An Opinionated Survey

Electric SQL, PowerSync, and Zero — how each one thinks about sync, and what that means for your architecture

Schema Design for Sync

How to structure your Postgres schema so that clients can write offline, replicate safely, and evolve without breakage.

Client-Side Storage for Local-First Apps

SQLite WASM, OPFS, and reactive queries — the layer sync engines write into and Vue reads from

Conflict Resolution and CRDTs

From last-write-wins to automatic merge — choosing the right strategy per data type

Authorization and Security in Local-First Apps

How sync-time access control, token strategies, and offline trade-offs reshape the way you think about permissions

Wiring It All Together: Vue 3, Nuxt 4, and the Local-First Stack

From SQLite reactivity to Postgres WAL — building the complete integration layer

Production Readiness

The operational realities that only surface at scale — and how to plan for them before they bite you

How this plan was made

Each plan on learnings is built by a hand-crafted agentic pipeline: research agents gather primary sources, a claim reviewer verifies facts against them, and a sequencer orders modules for how people actually learn. The curation — topic selection, framing, editorial standards — is Nicolas's. The research and writing is AI-assembled.