Sitemap

A list of all the posts and pages found on the site. For you robots out there is an XML version available for digesting as well.

Pages

Posts

如何从零开始搭建自己的个人网站(4)——数据库

less than 1 minute read

Published:

在讲完如何编写后端接口之后,下一步就是想办法将网站所需的数据存储到数据库当中了。作为一个最最基本的网站,我们并不会使用到复杂的存储模式(如NoSQL),所以数据库管理软件还是选择免费且简单的MYSQL。这样一来,Golang如何与MYSQL进行交互就变成了一个相当关键的问题。本篇文章会围绕这一主题进行讲解。内容不难,相信你很快就能学会。

如何从零开始搭建自己的个人网站(3)——后端

less than 1 minute read

Published:

正如上一篇文章结尾处所提到的,后端技术是前端开发者比较陌生的领域,因而实现起来会比较棘手。在这篇文章中,我会大致地介绍一下后端分为那些部分,以及一个相当重要的点:前端与后端如何进行交互。不过首先,我还是简要地说明一下我认为的前端和后端的区别以及各自该做的事情。

如何从零开始搭建自己的个人网站(2)—— 前端

less than 1 minute read

Published:

本文主要围绕网站开发的两个我认为比较难的点:React-Router路由和GitHub开源组件的使用进行分享。最后也会涉及到一些具体细节的实现方法,比如文本行数超出显示省略号,require动态导入图片。

如何从零开始搭建自己的个人网站(1)——明确需求

less than 1 minute read

Published:

这个系列文章是我当年大三学习和实践前端开发时写的,主要涉及我在自己完整地经历前端页面设计&开发,后端数据库处理和API编写,云服务器部署&搭建到最终网页上线的全过程中遇到的各种问题以及解决方案。当时觉得能搭建出一个属于自己的网站是一件非常难得的事(现在其实也这么觉得),但可惜的是当年的网站由于腾讯云服务器学生优惠到期已经停止运行很久了。现在重新将这部分捡起来,使用开源仓库部署出来,效率比之前快得多,但我还是有些怀念当时一门心思钻研前端开发的时光。现在慢慢地将之前的备份Word文档转为Markdown,也算是重走了一遍当时的路吧^v^。

portfolio

publications

GLogS: Interactive Graph Pattern Matching Query At Large Scale

Published in ATC, 2023

Find optimized execution plan for graph pattern match query by graph-strctured catalogue

Recommended citation:
@inproceedings {288723, author = {Longbin Lai and Yufan Yang and Zhibin Wang and Yuxuan Liu and Haotian Ma and Sijie Shen and Bingqing Lyu and Xiaoli Zhou and Wenyuan Yu and Zhengping Qian and Chen Tian and Sheng Zhong and Yeh-Ching Chung and Jingren Zhou}, title = {{GLogS}: Interactive Graph Pattern Matching Query At Large Scale}, booktitle = {2023 USENIX Annual Technical Conference (USENIX ATC 23)}, year = {2023}, isbn = {978-1-939133-35-9}, address = {Boston, MA}, pages = {53--69}, url = {https://www.usenix.org/conference/atc23/presentation/lai}, publisher = {USENIX Association}, month = jul }
Download Paper | Download Slides

talks

teaching

TA of CSC4005: Parallel Programming

Undergraduate course, The Chinese University of Hong Kong, Shenzhen, 2022

I was the administrator and maitainer of the cluster with Slurm task management system where students submit their parallel tasks. Besides, I graded two of the programming projects and conducted Q&A session for students.

TA of DDA2003: Data Visualization

Undergraduate course, The Chinese University of Hong Kong, Shenzhen, 2023

I serve as the leading TA, and was reponsible for giving tutorial sessions to students, that taught them how to write basic programs for data visualization.

TA of CSC4005: Parallel Programming

Undergraduate course, The Chinese University of Hong Kong, Shenzhen, 2023

I was the administrator and maitainer of the cluster with Slurm task management system where students submit their parallel tasks. Besides, this time I was the leading TA, and needs to manage other TAs and USTFs (Undergraduate Student Teaching Fellow) with the course instructor

TA of CSC4180: Compiler Construction

Undergraduate course, The Chinese University of Hong Kong, Shenzhen, 2024

I was the only TA of this course, and needed to handle all the works alone, including designing and grading programming projects, giving tutorial sessions, and conducting Q&A sessions for students.