Building Blason to Learn Full-Stack Architecture

说明与用途

开发者构建了 Blason 项目以提升全栈开发技能。他们从 Supabase 迁移到本地 Express + SQLite 架构，以更好地理解应用程序组件之间的交互。

问题

The developer wanted to move beyond isolated frontend projects and build a complete application to improve full-stack development and software architecture skills.

结果

The developer successfully built a full-stack application, transitioning from a managed service (Supabase) to a self-hosted architecture (Express + SQLite) to gain deeper understanding of system interactions.

工作流

• Identify the need to build a complete application rather than an isolated frontend project.
• Define the tech stack: React, TypeScript, Express, SQLite.
• Implement core features: Authentication, REST APIs, File handling, User profiles, Quests, Submissions.
• Initially use Supabase for backend services.
• Refactor to replace Supabase with a local Express + SQLite architecture.
• Implement underlying application stack components manually to understand interactions.
• Analyze the flow: frontend → API → business logic → database → authentication → workflows.
• Publish the project as open source.

证据

The application initially relied on Supabase. I later replaced that dependency with a local Express + SQLite architecture.

来源

The most valuable part of the project was not any particular framework. It was learning how the different parts of a real application interact: frontend → API → business logic → database → authentication → workflows.

来源