Full-stack portfolio with i18n, Studio CMS, and SQLite persistence

This project evolved from a static page into a full-stack application. The core idea is to decouple content management from code changes—edit site content, manage projects, and moderate messages directly from the Studio admin panel, all persisted to SQLite without redeployment. It also includes ICP filing, visit counting, cover image upload, and more.
Design
Dark glassmorphism theme emphasizing content hierarchy and immersive reading. Responsive layout from desktop to mobile with seamless bilingual switching.
Architecture
Next.js App Router + SQLite (better-sqlite3) + RESTful API layer. Monorepo architecture: Studio admin manages data via API, frontend pages read DB directly via SSR.
Tech Stack
Messages
Anyone can leave a message or reply. Author replies are labeled automatically when logged in.