SQL → JSON → TypeScript types → runtime fetch → React props 

SQL → sqlc (compile-time Go structs) → domain types → templ (compile-time HTML) 

workshop/ ├── main.go # 9 lines: hands off to internal/cmd ├── migrations/ # goose migrations (0001_init.sql, 0002_weather.sql) ├── queries/ # sqlc query files, one per table ├── sqlc.yaml # sqlc configuration ├── templier.yml # templier (hot reload) configuration ├── Makefile # dev workflows: web, web-hot, templ, sqlc, test, load, etc. ├── internal/ │ ├── cmd/ # CLI commands and interactive menu (urfave/cli + huh) │ │ ├── cmd.go # Root command, bootstrap, interactive menu loop │ │ ├── app.go # Wiring: services, stores, clients │ │ ├── web.go # `workshop web` command │ │ ├── sightings.go # `workshop sightings` (find, list, ingest) │ │ ├── species.go # `workshop species` │ │ ├── animals.go # `workshop animals` │ │ ├── stats.go # `workshop stats` │ │ ├── db.go # `workshop db` (migrate, seed, reset, ping) │ │ ├── migrate.go # migration status/version/up/down + checkMigrations │ │ ├── flags.go # shared CLI flags │ │ └── internal/ │ │ ├── prompt/ # interactive forms (huh wrappers) │ │ ├── lookup/ # UUID prefix lookup │ │ └── view/ # CLI rendering (tables, cards, hints) │ ├── domain/ # THE RULES: what's true if you delete the DB and API │ │ ├── sighting/ # Sighting entity, Store interface, Service, ingest, validate │ │ │ ├── sighting.go # Store interface, Service, observers() formatting │ │ │ ├── model.go # Sighting, Location, Coordinates, CreateParams, Media │ │ │ ├── ingest.go # GBIF → sighting pipeline (Ingest, speciesPerSighting, etc.) │ │ │ ├── filter.go # ListFilter, TaxonKeys() │ │ │ ├── validate.go # CreateParams.Validate(): invariants │ │ │ ├── summary.go # sighting summaries │ │ │ ├── country/ # country.Code type with parsing │ │ │ └── stores/ │ │ │ └── sightingsqlite/ # sqlc-backed implementation of sighting.Store │ │ │ ├── store.go # Find, FindByGbifKey, List, Create │ │ │ └── transform.go # db.SightingListRow → sighting.Sighting │ │ ├── species/ # Species entity, Store, Service, Animal catalog │ │ │ ├── species.go # Store interface, Service │ │ │ ├── model.go # Species struct │ │ │ ├── animal.go # 80+ Animal constants + GBIF taxon keys │ │ │ └── stores/ │ │ │ └── speciessqlite/ │ │ ├── weather/ # Weather entity, Store, Service │ │ │ ├── weather.go # Store interface, Service, errors │ │ │ ├── model.go # Weather, Temperature, Precipitation, Wind, Condition │ │ │ ├── validate.go │ │ │ └── stores/ │ │ │ └── weathersqlite/ │ │ └── README.md # "The rules. Everything that would still be true if we deleted the database and the API." │ ├── clients/ # OUTBOUND ADAPTERS: gbif, openmeteo │ │ ├── gbif/ │ │ │ ├── client.go # Client struct, BaseURL, New() │ │ │ ├── occurrences.go # Occurrence type (300+ fields!), Occurrences() search │ │ │ ├── species.go # GBIF Species lookup │ │ │ ├── media.go │ │ │ ├── pagination.go │ │ │ ├── common.go │ │ │ └── testdata/ # JSON fixtures for offline tests │ │ ├── openmeteo/ │ │ │ ├── client.go # Client struct, BaseURL │ │ │ ├── reading.go # Reading, Request, query builder │ │ │ ├── codes.go # WeatherCode enum │ │ │ └── testdata/ │ │ └── README.md # "Anything that talks to somebody else." │ ├── infra/ # PLUMBING: config, sqlite, sqlc output │ │ ├── config/config.go # Config from env (caarlos0/env) │ │ ├── db/sqlite/ # SQLite connection, error mapping │ │ ├── db/sqlc/ # AUTOGENERATED sqlc output (db package) │ │ │ ├── models.go # Sighting, Species, Weather (sqlc-generated structs) │ │ │ ├── sightings.sql.go │ │ │ ├── species.sql.go │ │ │ ├── weather.sql.go │ │ │ ├── querier.go # Querier interface │ │ │ └── db.go # New() constructor │ │ └── README.md # "The plumbing of the app... decisions don't." │ └── common/ # GENERIC HELPERS (httputil, logs, server, printer) │ ├── httputil/ # JSON HTTP client (works in any project) │ ├── logs/ # request logger, slog setup │ ├── server/ # HTTP server with graceful shutdown │ ├── printer/ # CLI console output (tables, trees, styles) │ └── README.md # "Generic helpers that happen to be ours." └── web/ # VIEW LAYER: routing, handlers, templates, assets ├── web.go # New(): ServeMux, static assets, route registration ├── handlers/ │ ├── home.go # Home() handler: calls service, renders template │ └── error.go # renderError(): error page rendering └── views/ ├── layout/layout.templ # Base layout (HTML shell, slots) ├── pages/ │ ├── home.templ # Homepage: iterates sightings, calls SightingCard │ └── error.templ # Error page └── components/ ├── sighting_card.templ # Individual sighting card └── gallery.templ # Media gallery (StillImage vs link) 

// internal/domain/sighting/sighting.go:19 type Store interface { Find(ctx context.Context, id uuid.UUID) (Sighting, error) FindByGbifKey(ctx context.Context, gbifKey int) (Sighting, error) List(ctx context.Context, filter ListFilter) ([]Sighting, error) Create(ctx context.Context, id uuid.UUID, in CreateParams) (Sighting, error) } 

// internal/domain/sighting/stores/sightingsqlite/store.go:21 var _ sighting.Store = (*Store)(nil) // Compile-time interface check 

type SightingsLister interface { List(ctx context.Context, filter sighting.ListFilter) ([]sighting.Sighting, error) } 

-- name: SightingFind :one SELECT sqlc.embed(sightings), sqlc.embed(species), sqlc.embed(weather) FROM sightings JOIN species ON species.id = sightings.species_id JOIN weather ON weather.id = sightings.weather_id WHERE sightings.id = ?; -- name: SightingFindByGbifKey :one SELECT sqlc.embed(sightings), sqlc.embed(species), sqlc.embed(weather) FROM sightings JOIN species ON species.id = sightings.species_id JOIN weather ON weather.id = sightings.weather_id WHERE sightings.gbif_key = ?; -- name: SightingList :many SELECT sqlc.embed(sightings), sqlc.embed(species), sqlc.embed(weather) FROM sightings JOIN species ON species.id = sightings.species_id JOIN weather ON weather.id = sightings.weather_id WHERE (sqlc.narg('from_date') IS NULL OR happened_at >= sqlc.narg('from_date')) AND (sqlc.narg('to_date') IS NULL OR happened_at <= sqlc.narg('to_date')) AND (sqlc.arg('country_code') = '' OR sightings.country_code = sqlc.arg('country_code')) AND (CAST(sqlc.arg('any_species') AS BOOLEAN) OR species.gbif_key IN (SELECT value FROM json_each(sqlc.arg('species_keys')))) ORDER BY sightings.happened_at DESC, sightings.id DESC LIMIT sqlc.arg('limit'); -- name: SightingCreate :one INSERT INTO sightings (...) VALUES (?, ?, ..., ?) RETURNING *; 

type SightingListParams struct { FromDate interface{} `db:"from_date"` ToDate interface{} `db:"to_date"` CountryCode interface{} `db:"country_code"` AnySpecies bool `db:"any_species"` SpeciesKeys interface{} `db:"species_keys"` Limit int64 `db:"limit"` } 

// internal/domain/sighting/stores/sightingsqlite/transform.go:14 func transform(row db.SightingListRow) (sighting.Sighting, error) { r, sp, w := row.Sighting, row.Species, row.Weather var media []sighting.Media if err := json.Unmarshal([]byte(r.Media), &media); err != nil { return sighting.Sighting{}, fmt.Errorf("decode media: %w", err) } if media == nil { media = []sighting.Media{} } return sighting.Sighting{ ID: r.ID, GBIFKey: r.GbifKey, // ... all 30+ fields mapped ... Location: sighting.Location{ CountryCode: country.Code(r.CountryCode), Coordinates: sighting.Coordinates{ Latitude: r.Latitude, Longitude: r.Longitude, }, }, Species: species.Species{ GBIFKey: int(sp.GbifKey), // ... }, Weather: weather.Weather{ Temperature: weather.Temperature{ Actual: w.Temperature, Apparent: w.ApparentTemperature, }, Condition: weather.Condition{ Code: int(w.ConditionCode), Description: w.Condition, }, }, Media: media, }, nil } 

GBIF Occurrence Search ↓ For each occurrence: ├─ 1. Check skippers (status must be PRESENT, must have media) ├─ 2. Resolve species (find or fetch from GBIF and create) ├─ 3. Resolve weather (fetch from Open-Meteo and create) ├─ 4. Save sighting (validate, parse coordinates/country, insert) └─ 5. Count: created / skipped / duplicates / failed 

package layout type BaseProps struct { Title string } templ Base(props BaseProps) { <!DOCTYPE html> <html lang="en-GB"> <head> <meta charset="utf-8"/> <meta name="viewport" content="width=device-width, initial-scale=1"/> <title>{ props.Title }</title> <link rel="stylesheet" href="/assets/css/app.css"/> </head> <body> <main class="container"> { children... } </main> <script src="/assets/js/app.js"></script> </body> </html> } 

package pages import ( "workshop/internal/domain/sighting" "workshop/web/views/components" "workshop/web/views/layout" ) templ Home(sightings []sighting.Sighting) { @layout.Base(layout.BaseProps{ Title: "Sightings", }) { <h1>Sightings</h1> if len(sightings) == 0 { <p>No sightings have been ingested yet.</p> } else { <p>Total: { len(sightings) }</p> <ul class="sightings"> for _, s := range sightings { <li> @components.SightingCard(s) </li> } </ul> } } } 

templ SightingCard(s sighting.Sighting) { <article class="card"> <header class="card__header"> <h2>{ displayName(s.Species) }</h2> if s.Species.ScientificName != "" { <p class="card__scientific">{ s.Species.ScientificName }</p> } </header> <dl class="card__meta"> <dt>Seen</dt> <dd>{ s.HappenedAt.Format("2 January 2006") }</dd> <dt>Where</dt> <dd>{ place(s.Location) }</dd> if s.IndividualCount != nil { <dt>Count</dt> <dd>{ individuals(*s.IndividualCount) }</dd> } if s.RecordedBy != "" { <dt>Recorded by</dt> <dd>{ s.RecordedBy }</dd> } </dl> <div class="card__gallery"> @Gallery(s.Media) </div> </article> } func displayName(sp species.Species) string { return cmp.Or(sp.VernacularName, sp.CanonicalName, sp.ScientificName, "Unknown species") } 

templ Gallery(items []sighting.Media) { if len(items) == 0 { <p class="gallery__empty">No media recorded.</p> } else { <ul class="gallery"> for _, m := range items { <li class="gallery__item"> if m.Type == "StillImage" { <img src={ m.URL } alt={ altText(m) } loading="lazy"/> } else { <a href={ templ.URL(m.URL) } rel="noopener">{ altText(m) }</a> } if m.Creator != "" { <figcaption class="gallery__credit">{ m.Creator }</figcaption> } </li> } </ul> } } 

func Home(logger *slog.Logger, sightings SightingsLister) http.HandlerFunc { return func(w http.ResponseWriter, r *http.Request) { ctx := r.Context() items, err := sightings.List(ctx, sighting.ListFilter{ Limit: 50, }) if err != nil { logger.ErrorContext(ctx, "handlers: listing sightings: "+err.Error()) renderError(ctx, w, logger, http.StatusInternalServerError, "Unable to load sightings.") return } w.Header().Set("Content-Type", "text/html; charset=utf-8") if err = pages.Home(items).Render(ctx, w); err != nil { logger.ErrorContext(ctx, "handlers: rendering sightings: "+err.Error()) renderError(ctx, w, logger, http.StatusInternalServerError, "Unable to render page.") } } } 

func bootstrap(ctx context.Context, cfg config.Config, level slog.Level, live bool) (*app, func(), error) { conn, err := sqlite.New(ctx, cfg.DatabaseURL) // ... migrate, err := migrations.New(conn) // ... queries := db.New(conn) speciesStore := speciessqlite.New(queries) gbifURL, openMeteoURL := localGBIFBaseURL, localOpenMeteoBaseURL if live { gbifURL, openMeteoURL = gbif.BaseURL, openmeteo.BaseURL } openm := openmeteo.New(openMeteoURL) speciesSvc := species.NewService(logger, speciesStore) weatherSvc := weather.NewService(logger, weathersqlite.New(queries)) sightingSvc := sighting.NewService(logger, sightingsqlite.New(queries), speciesSvc, weatherSvc, gbif.New(gbifURL), openm, ) // ... } 

func interactive(app *app) cli.ActionFunc { return func(ctx context.Context, root *cli.Command) error { ifSource：https://dev.to/amayo_clinton/full-stack-go-domain-driven-applications-with-sqlc-and-templ-2gff
My favorites