Example: full app with SQLite store (single binary, zero deps) #27

New issue

Open

opened 2026-02-19 22:28:39 +00:00 by ash · 0 comments

ash commented

2026-02-19 22:28:39 +00:00

Owner

What

Complete working example app using SQLite store. The simplest possible deployment — one Go binary, one SQLite file.

Must Demonstrate

All 3 event modeling patterns (state change, state view, automation)
CommandBus with single writer (in-process)
EventSubscription with guaranteed delivery
SQLiteNotifier for real-time updates
Projections → read models
Automations with TodoList pattern
GDPR forget flow
Schema evolution (v1 → v2 event)
HTTP API (Chi router)
SSE live updates via Datastar + Templ
go run main.go and it works

Stack

Go + Templ + Datastar + Open Props + SQLite + Chi

Why

This is the "getting started" example. If someone can't get this running in 30 seconds, we've failed.

## What Complete working example app using SQLite store. The simplest possible deployment — one Go binary, one SQLite file. ## Must Demonstrate - All 3 event modeling patterns (state change, state view, automation) - CommandBus with single writer (in-process) - EventSubscription with guaranteed delivery - SQLiteNotifier for real-time updates - Projections → read models - Automations with TodoList pattern - GDPR forget flow - Schema evolution (v1 → v2 event) - HTTP API (Chi router) - SSE live updates via Datastar + Templ - `go run main.go` and it works ## Stack Go + Templ + Datastar + Open Props + SQLite + Chi ## Why This is the "getting started" example. If someone can't get this running in 30 seconds, we've failed.