Skip to content

Instantly share code, notes, and snippets.

View sdttttt's full-sized avatar

AwK sdttttt

  • jmp.-2
View GitHub Profile
@sdttttt
sdttttt / loader.asm
Created May 20, 2025 06:51
从硬盘引导主扇区读取512字节的setup代码到内存,然后控制权交过去
[org 0x7c00]
[section data]
BOOT_MAIN_ADDR equ 0x500
[section text]
[bits 16]
global _start
_start:
@sdttttt
sdttttt / wrt.sh
Last active May 25, 2025 04:34
路由器脚本(每次固件更新后可能会用的命令
# 必看!
# 这个脚本是sdttttt的路由器配置脚本,格式比较乱因为这是个备忘录。
# 路由器主要运行OpenClash作为透明代理,DNS由ChinaDNS-NG处理,下面大概讲一下分流行为
# DNS请求经过Chinadns-ng,域名分流由chnlist.txt完成,在chnlist内会走国内组DNS,否则走国外组,国外组的DNS服务器为Clash
# 解析好的IP会通过内部预设好的chnroute判断是否为国内IP,如果是国内IP会加入到chnip合集内
# 防火墙中,如果连接目标IP属于chnip,则流量会绕过clash内核
# 非chnip中的IP会经过Clash内核,并且在Clash内核中会经过二次分流
# chinadns-ng的分流为黑名单模式,chnlist以外都会走国外组
# clash内部的第二次分流更加严格,为白名单模式,只有匹配到的流量才会走代理
@sdttttt
sdttttt / wrt.sh
Last active May 9, 2025 04:33
自用的OpenWrt脚本:重新编写了OpenClash的iptables/nftables逻辑
# sdttttt自用openclash规则
# openclash 需要处于tun模式
# 该规则下网关下设备:UDP走TUN,TCP走TProxy,QUIC走直连,9000端口以上流量不经过核心,网关本机流量统一走TUN
# 需要创建TProxy的路由表,TUN的路由表Openclash已经创建了:表354
# 到本地回环处理的路由,在表355
ip route del local default dev lo scope host table 355
ip route add local default dev lo scope host table 355
# 标记0x164,策略路由到355表
ip rule del priority 2000 fwmark 0x164 lookup 355
ip rule add priority 2000 fwmark 0x164 lookup 355
@sdttttt
sdttttt / hello.asm
Created April 27, 2025 09:44
头一次写汇编
SECTION .data
msg db '123456789awdawdawdawd', 0Ah
SECTION .text
global _start
_start:
mov ecx, msg
@sdttttt
sdttttt / sql.md
Created August 28, 2023 06:18
[SQL 优化 EXPLAIN 关键字]
mysql> explain select * from student;
++-+-++--+---+--+-+--+--+--+---+
| id | select_type | table   | partitions | type | possible_keys | key  | key_len | ref  | rows | filtered | Extra |
++-+-++--+---+--+-+--+--+--+---+
|  1 | SIMPLE      | student | NULL       | ALL  | NULL          | NULL | NULL    | NULL |    2 |   100.00 | NULL  |
++-+-++--+---+--+-+--+--+--+---+
@sdttttt
sdttttt / sql.md
Last active August 28, 2023 06:25
[关于索引的一些知识, 面使用]

MySQL 的索引有两种分类方式:逻辑分类和物理分类。

逻辑分类

有多种逻辑划分的方式,比如按功能划分,按组成索引的列数划分等 按功能划分

  • 主键索引:一张表只能有一个主键索引,不允许重复、不允许为 NULL;
@sdttttt
sdttttt / quick.sql
Last active August 27, 2023 12:08
[Docker Mariadb 快速部署 + 测试数据]
# docker run -d --name mariadb-wp -p 33006:3306 -e MYSQL_ROOT_PASSWORD=admin mariadb:5.5
CREATE TABLE users
(
id int NOT NULL AUTO_INCREMENT PRIMARY KEY,
name varchar(255) DEFAULT 'fuckyou',
email varchar(255) DEFAULT 'a@b.com',
address varchar(255) DEFAULT 'A',
city varchar(255) DEFAULT 'HangZhou'
)
@sdttttt
sdttttt / .eslintrc.js
Last active March 23, 2023 02:23
[Vue ESLint] 习惯了
process.env.ESLINT_TSCONFIG = "tsconfig.json";
module.exports = {
root : true,
extends: ["eslint:recommended", "plugin:vue/vue3-recommended"],
parser : "vue-eslint-parser",
// 优先级低于parse的语法解析配置
parserOptions: {
// 指定ESlint的解析器
@sdttttt
sdttttt / prettier.config.js
Last active March 23, 2023 02:03
[prettier format] 习惯了
module.exports = {
printWidth : 80,
tabWidth : 4,
useTabs : false,
semi : true,
singleQuote : false,
jsxSingleQuote : false,
bracketSpacing : true,
bracketSameLine : true,
arrowParens : "avoid",
@sdttttt
sdttttt / repo.go
Last active December 14, 2022 04:26
Go Web Repoonse
import (
"net/http"
)
const MsgOK = "ok"
// Response is common json response type
type Response[T any] struct {