TinySQL Implementation

TinySQL Implementation 本次实现是关于 PingCap Talenet Plan 2022 TinySQL 学习营相关的实验解题思路。本次实验可以作为 CMU 15-445 的补充,主要内容为每周的讲座+通过Lab的所有测评 Case ,总体实现难度

Amend Hugo Theme Even

By default, the theme even doesn’t support the search and copy to the clipboard button which is proposed in issues#289 and issues#399. So I have finished implementing the features. 1. Search Initially, you should add the output of JSON in your ./config.toml file. 1 2 [outputs] home = ["HTML", "RSS", "JSON"] Then create the file ./themes/even/layouts/_default/index.json and add these lines. Then make sure you can see the output in the localhost:1313/index.

About Computer Science

It is a yearly “divide major” season, and now I am looking back at the series of computer science questions and answers I have browsed in Zhihu during my freshman year, and I feel a lot of emotions. I have been thinking about it for a long time, and this is the first time I have seen such numerous questions and discussions about computer science, hence I write about this post.

Compilers

1. Overview 2. Language Grammar 字母表(Alphabet):$\sum$是一个有穷符号集合,包括字母、数字、标点等。 乘积(product):字母表$\sum_1$

Software Engineering

Overview Software is more than just a program code. It is considered to be collection of executable programming code, associated libraries and documentations. Engineering on the other hand, is all about developing products, using well-defined, scientific principles and methods. IEEE Definition (1) The application of a systematic, disciplined, quantifiable approach to the development, operation, and maintenance of software; that is, the application of engineering to software. (2) The study of approaches as in the above statement.

Safety in Systems Programming

1. Introduction The gets() function cannot be used securely. Because of its lack of bounds checking, and the inability of the calling program to reliably determine the length of the next incoming line, the use of this function enables malicious users to arbitrarily change a running program’s functionality through a buffer overflow attack. It is strongly suggested that the fgets() function be used in all cases. How can we find and/or prevent problems like this?

Advanced MySQL

1. Query Engine 1.1. Relational Model 关系型数据库是建模现实世界的关联数据的有组织的集合。最早期数据库难于构建,逻辑与物理层强耦合。 查询流程 SQL(Parser):词

TCP Congestion Control

1. Overview 最初的TCP因为不支持拥塞控制而频繁被丢弃数据包,协议栈被投入使用8年后,Van Jacobson在1988年将 TCP 拥塞控制引入网络。 IP层