Comic Collection is a database searching and displaying engine made with the Python Flask. 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.

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 database.

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 play 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 SQLite 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 asked.) the app can locate the animal within 10 rounds.