How github-samples/tailspin-toys works
Tailspin Toys is a static Astro crowdfunding-game catalog backed by local SQLite. Its principal workflow reads game records through data-access helpers and prerenders pages; database seeding and the Backer Concierge catalog export are separate supporting capabilities. Page and component source was not excerpted, so their internal routing and rendering relationships are not expanded beyond the README’s description.
Main entry points: db.ts Database client · seed.ts Database seeder · games.ts Game queries · export-catalog.ts Catalog export
Components 13
Static catalog
- Astro pages
src/pages - Shared UI
src/components - Rating formatter
src/lib/ratings.ts
Catalog data
- Game queries
src/lib/games.ts - Database client
src/lib/db.ts - Catalog schema
db/schema.ts - SQLite database
Catalog preparation
- Seed catalog
db/games.csv - Seed transforms
db/transforms.ts - Database seeder
db/seed.ts - Migration runner
db/migrate.ts
Concierge export
- Catalog export
db/export-catalog.ts
Other components
- Site visitor
Connections 16
- Site visitor → Astro pages: views
README.md - Astro pages → Game queries: queries at build
README.md - Game queries → Database client: uses client
src/lib/games.ts - Game queries → Catalog schema: queries tables
src/lib/games.ts - Database client → Catalog schema: configures Drizzle
src/lib/db.ts - Database client → SQLite database: executes SQL
src/lib/db.ts - Shared UI → Rating formatter: formats stars
src/lib/ratings.ts - Database seeder → Seed catalog: reads seed data
db/seed.ts - Database seeder → Seed transforms: parses and derives
db/seed.ts - Database seeder → Catalog schema: writes records
db/seed.ts - Database seeder → Database client: creates connection
db/seed.ts - Migration runner → Database client: creates connection
db/migrate.ts - Migration runner → SQLite database: applies migrations
db/migrate.ts - Catalog export → Game queries: loads games
db/export-catalog.ts - Catalog export → Rating formatter: formats ratings
db/export-catalog.ts - Catalog export → Database client: creates connection
db/export-catalog.ts