Serverpod Web Server Tutorial Series #5 - — Designing the Database Schema
We design the App and AppMetric YAML models, run code generation, apply the database migration, and seed 90 rows of realistic analytics data : the foundation everything else builds on.
This is part of a complete, practical tutorial series on Serverpod's built-in web server; the feature most Flutter developers overlook. By the end of the series you will have built a fully functional mobile app analytics dashboard served directly from your Serverpod backend, using three different serving strategies: a Flutter web app, server-rendered HTML with Mustache templates, and a plain SPA.
Every lesson is grounded in real, runnable code.
Full Series → • Serverpod Web Server Tutorial Series #1 - ...
───────────────────────────────────────────
WHAT THIS SERIES COVERS
───────────────────────────────────────────
✦ Serverpod's two-server architecture and the Relic framework
✦ Routing → path parameters, query parameters, HTTP methods, wildcards, route modules
✦ Middleware → request logging, API key validation, ContextProperty
✦ Database schema design with YAML models, code generation, and migrations
✦ Business logic endpoints callable by both the web server and your Flutter app
✦ Building a Flutter web dashboard with fl_chart and live Serverpod data
✦ Serving Flutter web apps with FlutterRoute and WASM multi-threading
✦ Server-side HTML rendering with WidgetRoute and Mustache templates
✦ Serving any plain SPA (React, Vue, Vanilla JS) with SpaRoute
───────────────────────────────────────────
PROJECT CODE
───────────────────────────────────────────
Full source code for the series:
🔗 https://github.com/Mobterest-Studio/s...
───────────────────────────────────────────
TOOLS & RESOURCES MENTIONED
───────────────────────────────────────────
🛠 Dartform — Serverpod backend tooling
https://dartform.dev/
📦 Serverpod — https://serverpod.dev/
📦 Relic — https://docs.dartrelic.dev/
───────────────────────────────────────────
MOBTEREST STUDIO
───────────────────────────────────────────
We build content for mobile engineers who want to go deeper — architecture, backend integration, production patterns, and the Dart full-stack.
🌐 Official website
https://www.mobterest.studio/
🎓 Engineering Residency — structured mentorship for mobile engineers
https://www.mobterest.studio/engineer...
📞 Book a Discovery Call
https://www.mobterest.studio/call-eve...
☕ Support the channel
https://buymeacoffee.com/mobterest
▶ Subscribe for more
/ @mobtereststudio
───────────────────────────────────────────
SERIES LESSON LIST
───────────────────────────────────────────
Lesson 1 — What is Serverpod's Web Server and Why Should You Care?
Lesson 2 — Project Setup & Folder Structure
Lesson 3 — Routing Deep Dive
Lesson 4 — Middleware
Lesson 5 — Designing the Database Schema
Lesson 6 — Business Logic & Endpoints
Lesson 7 — Building the Flutter Web Dashboard UI
Lesson 8 — Server-Side HTML with Mustache Templates
Lesson 9 — Serving a Plain SPA
#serverpod #dartform #flutter #dartbackend