文件6.9更新总库.txt的大小是18G, 大概有7亿条数据, 需要写入到mysql并提供查询功能。 步骤 1. 建表 建表：建立5个表分别是qq_0, qq_1, qq_2, qq_3, qq_4， 表结构一致， 先不建立索引. 耗时0分钟 create database ku default charset utf8mb4; CREATE TABLE qq_0 ( id INT(11) PRIMARY KEY AUTO_INCREMENT, qq_number VARCHAR(64) DEFAULT ”, mobile VARCHAR(64) DEFAULT ” ); CREATE TABLE […]

用于机器无法联网, 但是局域网内有其他电脑可以联网的情况下使用pip安装依赖包. 使用Nginx反向代理即可： server { listen 38888 default_server; index index.html index.htm index.nginx-debian.html; server_name _; location /simple { proxy_pass https://pypi.doubanio.com; } location /packages { proxy_pass https://pypi.doubanio.com; } } 安装时指定trusted-host, 比如： pip install requests -i http://ip:18888/simple –trusted-host=*

<meta http-equiv=”Content-Security-Policy” content=”default-src * data: blob: filesystem: about: ws: wss: ‘unsafe-inline’ ‘unsafe-eval’ ‘unsafe-dynamic’; script-src * data: blob: ‘unsafe-inline’ ‘unsafe-eval’; connect-src * data: blob: ‘unsafe-inline’; img-src * data: blob: ‘unsafe-inline’; frame-src * data: blob: ; style-src * data: blob: ‘unsafe-inline’; font-src […]

for remote in `git branch -r`; do git branch –track ${remote#origin/} $remote; done

docker run -it –rm –name certbot -v $PWD:/etc/letsencrypt certbot/certbot certonly –manual –preferred-challenges=dns-01 –server=https://acme-v02.api.letsencrypt.org/directory 回车后按照提示输入 , 最后配置txt解析即可生成证书和密钥, 有效期三个月

Editing ‘/etc/parse.conf’ is not recommended any more because the content will be reset after restart. Open a terminal window and go to the Network Manager connections profile directory. cd /etc/NetworkManager/system-connections/ Then list connection names available on your system. ls As […]

JWT is a very common authentication method. Some people say you should never use it, while others say it’s amazing. Today, I just want to talk about the disadvantages and why using JWT in web applications is not always a […]

The app build with cordova is installed on an Android device, all ajax requests are 404(NotFound). But debugging in chrome works fine. This problem can be solved by reinstalling cordova-plugin-whitelist remove: cordova plugin remove cordova-plugin-whitelist reinstall: cordova plugin add cordova-plugin-whitelist

DNS over HTTPS (DoH) is a protocol for performing remote Domain Name System (DNS) resolution via the HTTPS protocol. A goal of the method is to increase user privacy and security by preventing eavesdropping and manipulation of DNS data by […]

Install Python runtime and pip package manager a. Go to python.org b. Click on the appropriate Mac installer pkg link. c. Once downloaded run the pkg to install Python runtime Open terminal Install Homebrew package manager ruby -e “$(curl -fsSL […]