Not all traffic can be arbitrarily routed. — While taking the responsibility of a mature service, it may not be possible for a single server to handle all the workload. This is due to three main considerations: performance, availability, and economy. In order to handle the excessive traffic well, increasing the capacity of processing requests is necessary, it…

There may be an index better than the default for your database. — As the amount of data in the database increases, the performance of the query may start to be unsatisfactory. However, we definitely can’t let the service continue to slow down because of this bottleneck, a suitable solution is necessary. Using table index is one of the most common solutions to…

As the complexity of software architecture increases, good analysis and design become more and more critical. Since I became a software engineer so far, we are used to drawing something like an architecture diagram on a whiteboard and discuss with other colleagues. But … have we really done the analysis…

Recently I was responsible for the integration of Stripe online payment service, and take some notes about workflow planning and SDK usage details. Stripe would be highly recommended for the payment tasks due to its software-engineering-friendly SDK, the succinct interface and complete documentation also helpful during my development. The third-party…

This semester I participated in a course on network data mining, which includes a crawler-related project that had much room for technical play, and I think it is worth writing an article to share. The students were asked to collect unique URLs as much as possible with website-scraping skills but…

自春季末開始求職以來，大約也經過了半年，期間陸續接觸了近十間軟體企業，拓展了不少眼界。依循著前人「取之於社群，回饋於社群」的精神，我也希望能為產業貢獻一己之力，以一個求職者的視角，分享我親身體驗的軟體企業面試現況。 在進入正文之前先粗略描述筆者的技術背景，希望讀者能理解觀察與描繪面試流程的視角，也提供背景相似的讀者一些參考。目前我有五年多的程式撰 …

中午吃飯滑手機時收到 CakeResume 的新功能通知，是個程式技能的認證機制，和同行朋友聊了下看法後得出了些有趣的結論，決定寫篇文章來分享一下從一個求職者視角的想法。 雙邊網絡模型 市面上多數這類型的類媒合平台，不管是約會、家教、就業、募資，只要是使用者明顯分為兩個族群的 (e.g. 男性/女性、老師/學生、徵才者/求職者、募資者/投資者)，並設法將雙方鏈結以 …

Consider a well-modulize project structure, we certainly take the advantage of the flexibility which empowers us to change or extend at less limit. Unfortunately, the complexity of communication between modules increases rapidly with the developing process. After a few version iterations, the engineers might start to think about related issues…

Driven by the curiosity of database tunning, I have taken some time to study how the database planner plans the query strategy this week. This really gave me great inspiration, which makes me pay more attention to how I construct a complex SQL. Here I will write down some notes…