wd and cc

— Happy every day

Who am I

酷不

My name is Dong Wang, and I am a software engineer for about twenty years, write python, javascript, java now. I have used perl, lua, ruby and lots of other programing languages for what can make my work done. Programing languages is just tools, I’m not being fascinated by anyone of it.

I’m also a database administrator for PostgreSQL, which I think is the best database application now. So you maybe found some articles of PostgreSQL or databases.

About this site

This is my personal blog, to collect and record some things I thought and learned. I’m trying to learn English now, I wrote done these things in English, wish this can be to make some help to improve my English.

WD is my name’s initials, it’s also West Digital’s abbrevation. This is very annoying, since lots of people find me to solve hard disk problems on twitter. SAD…

CC is my wife’s nickname, which pronounce is cici, like her given name. I have suggested her to change CC to Cici, since there is no vowel letters in the name, people can’t sounds it, but she didn’t agree… oh, okay… I found my nickname is at the same situations, I think I will not change it too … :)

Recent posts

Jul 19, 2020
Use Certbot Docker to Manage CertsI think everyone knows Let's Encrypt these days. I use letsencrypt for some of my personal services. I was using the system shipped certs at the beginning, and using systemd jobs to auto renew the certs. I was using the HTTP-01 challenge mode at first, and using the certbot standalone mode to achieve that.…
Jun 30, 2020
To Be a Terraform ExpertI was using AWS before I join the current company, but I don't even know terraform before I interview with the current company. I got hit by Terraform at first, it's really hard to deal with states. Use -target with plan command to collaborate When you work with your colleagues with same terraform project, sometimes they maybe need to apply some changes that haven't merged yet for testing, when you run the plan command, you will find that terraform want to destroy his resources.…
Jun 29, 2020
Transparent Proxys这次说说透明代理。所谓透明代理指的是用户无感知的情况下(也就是不需要对自己的电脑手机做任何设置,运行…
May 24, 2020
10 Most Common Mistakes Using Kubernetes翻译自 10 most common mistakes using kubernetes resources - requests and limits 这个绝对值得一开始就讲。 CPU 限制通常都是 not set(没设置)或者 set very low(…
May 18, 2020
RBAC in KubernetesHow to give a pod the access to run kubectl to create pods or configmaps? It's very simple. Every pods has to bind to a service account, it will be default, if you haven't specify one. And by default, this account didn't have any access to the kubernetes API.…
Mar 7, 2020
Dont Need Kubernates翻译自 “Let’s use Kubernetes!” Now you have 8 problems ,这个东西和所谓什么中台,微服务类似,小公司弄…
Mar 5, 2020
Book Review of Kubernates in Action这几天看了一下 Kubernates in action 这本书,看的是中文版本。把自己觉得有用的记录一下。 怎么决定一个 pod 里面包含多少容器…
Feb 25, 2020
Interview Is a Two Way Choise最近看到一些人贴面试经历,我觉得可以适当总结一下,结论是:面试就是一个双向选择,对方不选你不一定是因…
Feb 2, 2020
Google Python Style Guide来自这里。翻译的目的是为了方便快速理解,所以没有太纠结很准确,最好是和英文对应看。 1 Background Google 的 python 代码风格…
Feb 2, 2020
PostgreSQL at Low Level总结一下这篇文章 PostgreSQL at low level: stay curious! Introduction 我们之前使用数据库的时候,生产环境都只在实体机上面使用,测试和开发为了…
Feb 1, 2020
Dont Do This in PostgreSQL前几天看见个这个,翻译一下。 不要使用 SQL_ASCII 可以看德哥这篇文章,使用这个编码后就是给啥存啥,如果 db 用户瞎用…
Jan 29, 2020
Algorithms Lessons From MIT在推上看到的这个课程 Introduction to Algorithms,虽然是 2011 年的,但是基础的东西还是比较稳定的,刚好补习一…
Jan 18, 2020
Comfort Zone舒适区 舒适区这个概念不同人其实有不同的定义,比如有些人可能是工作中学习一些自己没学过的知识,就需要打…
Dec 28, 2019
Django Channels2Django 3.0.1 has released for sometime. We still use Django 1.11 in one of our project, with Channels 1.1.8, I think it's the time to upgrade to newest Django and Channels. According this upgrade guide, Channels 2 is a fully rewritten, lots of things has changed. This post is just a record about the upgrade I've done.…
Dec 18, 2019
Year in Review 2019Here it comes, the end-of-year 2019. The next year will be 2020, it’s more easy to pronounce for foreigners :) Works Finally, I realized that I lack of experience and knowledge to continue run our startup company. When you are the founder of a company yourself, you…
Dec 12, 2019
Should I Join a Startup Company前几天看到一个这个程序员为了期权加入创业公司,值得吗?,高票的回答写的挺有意思的,有兴趣可以看看。 大…
Dec 12, 2019
Add an Force Sync Button in Django Admin我们的系统里面需要和外部的系统同步一些数据,为了保证数据正确处理,增加了一个队列。队列是通过一个 celery 里…
Dec 4, 2019
ST_Buffer in PostgisPostgis 一直没仔细用过,总是临到用时看看文档,这不又遇到问题了,折腾半天。 我们最近有一个需求是,需要把一些…
Nov 7, 2019
Upgrade RN From 0.57 to 0.61好久没升级 app 使用的 RN 了,前几天看见已经是 0.61 了,我们用的还是 0.57,已经差了好几个版本了,有必要跟进…
Oct 29, 2019
Doing Code Reviews集中看了一波 code review 的帖子,记录一些笔记 How Do Code Reviews Work at Microsoft? 微软这个倒是没什么亮点,不过最后有一堆别等链接值得…
Oct 17, 2019
Some Interview QuestionsNotes for some interview questions. OSI 7 layers Physical layer. Data link layer. Switches are working on this layer, so when we talk about mac address, node to node connection, it's all happened here. Network layer. IP/ICMP protocol are for this layer.…
Oct 17, 2019
Learning Python Coroutine看了一个视频 OSB 2015 - How Do Python Coroutines Work?,从头开始讲 coroutine 是怎么抽象出来的,感觉好厉害。自己写了一点程序学习…
Oct 15, 2019
ASGIDjango 3.0 要支持 ASGI 了,全称 Asynchronous Server Gateway Interface,使用了 coroutines 异步。WSGI 是目前普遍使用的,把进来的请求标…
Oct 14, 2019
New Way to Go Across the GFW家里路由器用了一段时间的国内定制的梅林系统,还给这个系统做过一个插件使用 v2ray。后面试过换个软路…
Oct 8, 2019
Drive in the US十一前去美国自驾了一圈,其实算是第二次美国自驾了。第一次是五年前。第一次去的时候有一个当地生活了比较…
Sep 5, 2019
Notes for CPython Internals视频地址这里。 Python 源码 Include/opcode.h 里面定义了所有 opcode。 Modules 里面是一些 c 实现的模块, Lib 里面是用 python 实现的模块。…
Aug 28, 2019
Book Review of Soft Skills改变自己对自己的看法 你所能犯的最大错误就是相信自己是在为别人工作。这样一来你对工作的安全感已然尽失。…
Aug 27, 2019
Python Coroutine协程 coroutine 不知道是从什么时候开始的,感觉我第一次看到是 lua 里面支持 yield 。后面看到就是 javascript 里面的 Promise,…
Aug 26, 2019
Book Review of Effective Python: 59 Specific Ways to Write Better Python书名是《Effective Python:编写高质量 Python 代码的 59 个方法》这本书买了大概 2 年,一直没看完,…
Aug 20, 2019
Get Wool From Dogs不知道羊毛出在狗身上怎么翻译的好,暂时先说成 get wool from dogs 了。今天的内容可能会有点文不对题。 也不知道是什么…