From Problem to System

Technology is not just about implementing features. It's about understanding needs, establishing consensus, and transforming problems into usable and maintainable systems.

localhost:3000/home

Beyond Wiring

More than wiring frontend and backend—clearly break down each request

GET /posts/with-translations/sciMaker?locale=zh-TW
JSON bodyReady

Not Just Updates

Turning accumulated content into a knowledge system

Actual Execution Plan

Simplified SSMS-style plan that advances one operator at a time.

01SELECT

Choose articles or atlas data as the root operator for the plan.

02JOIN

Combine content rows with their translations or atlas metadata.

03WHERE

Apply category and language predicates before sorting.

04ORDER BY / LIMIT

Order the result set and keep the final page-sized rows.

Query Shape
Software Odyssey

Notes on Next.js Content Architecture

Fetch posts, translations, cover images, and publish dates by category and language for homepage cards.

Software OdysseyenArticle System

Problem-Sized Builds

Turn specific problems into matching tools

PDFtoPPT
Software Odyssey

PDFtoPPT

A Python CLI that turns text-based PDF documents into structured PowerPoint summary decks. The pipeline extracts PDF text, normalizes noisy content, chunks long documents, summarizes with an LLM, validates outlines with Pydantic, and renders .pptx files with python-pptx.

Python / Ollama / Pydantic / python-pptx / Document Pipeline

Open project
Gift for You
Software Odyssey

Gift for You

A personal web project that turns gift-giving scenarios into an interactive experience, with practice across product thinking, interface design, frontend implementation, and deployment.

React / Web UI / Product Thinking / Vercel

Open project

For Future Review

Latest Writing

2026 Observation Logbook

2026 Observation Logbook

This article is dedicated to documenting the post links from the Facebook group "Science Maker." Each link showcases the results of observations made using scientific tools designed by the Science Maker community. To encourage the use of scientific tools for observation, members can earn SciSpot points by sharing their observation results. These points can be redeemed for small gifts or used to access community skills.

Attack on Titan Anime Review (Major Spoilers)

Attack on Titan Anime Review (Major Spoilers)

Because of a single sentence, I ended up watching all of Attack on Titan on Netflix. The experience was truly overwhelming, so I wanted to capture this emotion in words. Along with images generated in Midjourney (so it’s normal if the characters look different), this serves as a reminder for my future self.

Meringue: A Simple Homemade Treat with Only Two Ingredients

Meringue: A Simple Homemade Treat with Only Two Ingredients

Back in college, I had a friend from the social work department who loved making desserts. That’s how I first discovered a sweet treat called meringue. Its melt-in-your-mouth texture left a lasting impression on me, so I wanted to try making it myself. After doing some research, I realized the process is actually quite simple and perfect for making at home. It only requires two ingredients. So, after borrowing a stand mixer and a piping tip, I bought the ingredients and started DIY baking!

Gathered Over Time

Turning curiosity into places to keep moving forward