Comic Collection is a database searching and displaying engine made with the Python
As the client requested, a clean and fast phone display of
the comic wishlist and active collection is the highlights of this app.
Through easy steps of converting original data,
this app first parses the SQLCE database extracted from comiccollectionlive.com
into SQLite form and the outcome of the app eliminates the unnecessary information in
the database and only keep the key features(book title, issue, etc.)
designated by the user. You can also preview the cover of the comic book
from comiccollectionlive.com directly from the app instead of search on another website.
All converted data can be downloaded in different excel formats. Comes with a simple
search function and an advanced function as well as 5 comic-style themes.
Jewel of China is a website for people to share their Chinese
translations. As a history student, I find it is always very hard for scholars or
students to look for the translation for a certain text. We had to spend long time
search dictionaries or annotations. Although not published,
the work is usually not widely shared as well.
This website provides an open platform to share and store your translation
to reduce repetitive work and improve the quality of the work. Users can edit
the text with the rich text editor, insert images, and comment on other posts.
The search function and tagging system can help the user easily find a post.
SQLAlchemy Database for Storing Data
User Password Encryption
Traditional Chinese Auto Convert(Powered by HanziConv)
Used SQLite database engine as the container for the
Zoo Animal Classification database.
In this guessing game, the app can successfully narrow down to one or two results within
10 rounds through a SQLite statement sent to the database. The player can also input the
animal that is not successfully guessed and its features to expand the data in the
As my earliest project, this game developed from a pure Python terminal app into a
website based on Python Flask. The motivation behind was to transform a game I always
in real life into an interactive computer app that has higher calculation capability.
The original game starts with a person thinking of an animal and another person tries to
guess the animal by asking different questions such as "does it have a tail".
I always have trouble guessing. The results show that through a SQLite query,
the more features you give, the faster the computer can locate the answer.
All birds have feathers and animals that have feathers must be birds. However,
the program does not know that unless you write the logic. The app first tends to
ask all the questions about the features in the database, which is a useless move and
reduces the success rate. My goal is to give the right answer within the fewest rounds,
so the app has to eliminate the invalid question each round. After I optimized the
query by creating a function to find valid questions after each 'ask',
(eg. if all animals have the same feature, the feature is not a valid feature to be
the app can locate the animal within 10 rounds.
Walletwatch.xyz is a database visualizing and displaying website made with Python backend
and React frontend. The App is useful in tracking your bitcoin investment progress. Instead of
calculating how much money gained since yesterday, last week, and last month, the visualized
data in the line chart will allow you to check your bitcoin balance for every hour.
By calling a Flask API, the Python backend requests the bitcoin wallet data from Blockchain.com
API with a designated wallet address. React frontend will receive the data return from Flask API
and create a line chart.
Visualization of Data in Line Chart (supported by VictoryChart)
Fast Data Retrieving through customized Flask API
Light React Frontend
Data Accurate to Every Hour
Zoom and Brush Functions for the Chart
Light UI for Small Screen (coming soon)
Check different cryptocurrency types (coming soon)
Hi, I am an academic turned web/software developer.
I am interested in building my clients fully-functional and responsive
websites. As a bilingual in English and Chinese. I can create Chinese website as well.