Eric Way's Personal Site

I Write $\sin(x)$ Not Tragedies

Category : Coding

块状链表

例题：https://vjudge.net/problem/POJ-2887 要求支持字符串的插入（在第$x$位之前插入字符串$c$）、后缀（在整个字符串最后添加字符串$c$）、查询（查询当前第$x$位）操作。字符串长度1e6，操作数量2e3。 Read more

Coding

Solving SQL Murder Mystery With Logica

Logica is a logic language for data manipulation developed by Google. It can be compiled into several SQL dialects, including BigQuery, SQLite and PostgreSQL. SQL, as a programming language, has several design flaws and suffers from bad readability especially when it comes to complex data queries. Logica has been aimed at mitigating those problems with SQL, and this post attempts to show that it does a quite good job in enhancing code readability and reusability, taking the SQL Murder Mystery as an example. Read more

Coding