I'm Shuaijie
Li.

A developer | designer | lifelong-learner.

Projects | Blog.

Review on sponsor talks from Microsoft, Google, and Snowflake

Review on sponsor talks from Microsoft, Google, and Snowflake

This is a review on three presentations made in the Database Affiliates 2023 at UW-Madison on October 13, 2023.

OceanBase

A review of the paper “OceanBase: A 707 Million tpmC Distributed Relational Database System”

Database Built on Go

Database Built on Go

This project was built based on

Algorithm of the JOIN Statement

Algorithm of the JOIN Statement

How to Handle Accidental Data Deletion

How to Handle Accidental Data Deletion

Temporary Measures to Boost MySQL Performance

Temporary Measures to Boost MySQL Performance

Database Table Space Recovery

Database Table Space Recovery

How MySQL Uses Indexes

How MySQL Uses Indexes

The appearance of indexes is actually to improve the efficiency of data query, just like the index of a book.

The logic of the optimizer in MySQL

The logic of the optimizer in MySQL

Global Locks and Table Locks in MySQL

Global Locks and Table Locks in MySQL

Transaction Isolation in MySQL

Transaction Isolation in MySQL

Update statement process in MySQL

Update statement process in MySQL

MySQL Basic Frames

MySQL Basic Frames

Profile.

Shuaijie Li

Hi, I'm thrilled to introduce myself to you as a passionate CS student with a deep appreciation for the potential of technology. I began my journey into CS as a graduate student at UW-Madison.

Through my experiences in research and collaborative projects, I have developed a passion for technology and a determination to continuously challenge myself. Ultimately, I aspire to become a full-stack engineer and create tools to enhance human capabilities and foster a harmonious relationship between people and the physical world.

Education.

University of Wisconsin - Madison

Master of Science in Computer Sciences

Southeast University

Bachelor of Architecture

Work Experience.

Unity

Software Engineer Intern

Engaged in the server-side development of a game-based multiplayer voice and video product using Golang, which is based on WebRTC to ensure a secure and stable connection.
Implemented CI/CD pipeline; orchestrated Docker and Kubernetes for multi-container deployments.
Integrated Redis into an Egress service, enabling real-time voice/video streams and non-compliant content filtering.
Participated in the server-side development of a 3D model cloud synchronization service based on the ASP.NET Core.

Conway Robot

Research and Development Intern

Collaborated in an interdisciplinary team to create an automatic tool for digital twin model generation using Python, which included vectorizing real-world maps and leveraging a GAN model for city block planning.

Skills.

Programming Languages: Java, C/C++, JavaScript, Python, Golang, C#, SQL
Frameworks: Spring Boot, ASP.NET Core, MyBatis, React, Tailwind CSS
Databases: MySQL, Redis, MangoDB
DevOps & Other Tools: AWS, Git, Docker, Kubernetes, Figma, Adobe Creative Suite, Unity 3D