Selected Projects

Selected Projects

1. NearChat (Real-time Messaging System)

• Description: NTNU Database Systems final project (team development) with a Monorepo using Next.js for frontend and Express for backend.
• Highlights:
  • Wrote raw SQL queries to optimize PostgreSQL database interactions without using ORMs.
  • Co-implemented database features including custom group permissions, message TTL, and offline testament mode.
• Link: GitHub Repository

2. All-Platform-Post (TypeScript project)

• Description: A tool that integrates multi-platform posting processes to streamline publishing workflows.
• Highlights:
  • Developed in TypeScript to improve code quality and maintainability.
  • Deployed on Azure Static Web Apps with automated CI/CD pipelines via GitHub Actions.
• Link: GitHub Repository

3. dimension-topology-memory-expansion (3D Puzzle Game Prototype)

• Description: A first-person 3D cozy puzzle game prototype centered on spatial topology and memory mechanics.
• Highlights:
  • Implemented “Frame Stitching” core mechanic: aligning photographs with real-world perspective to trigger spatial expansion.
  • Programmed custom GDShaders for rendering visual perspective effects and designed interactive physics puzzles.
• Link: GitHub Repository

4. Zerojudge-record (Algorithm solution record)

• Description: Solutions and thought processes for ZeroJudge algorithm problems.
• Highlights:
  • Documents problem-solving strategies for various data structures and algorithms.
  • Practices time complexity analysis and optimization techniques.
• Link: GitHub Repository