Yesterday in the gap between Debug time, the product manager proposed an idea, hoping to perform fuzzy matching of text between two Excel files to convert a many-to-many relationship into a one-to-many result.

After writing the automatic check-in script, I also hope to receive the push message after each script run. I tried to send emails with 163 mailboxes, but it always triggered the anti-spam mechanism to be blocked, whether it was to change keywords or set recipients. So, look for it, use IFTTT to do the push.

Android emulator and Docker on Windows can’t be used at the same time. I want to use Raspberry Pi to set up a development environment. I just watched the live broadcast recently, so maybe running an RTMP live broadcast on the Raspberry Pi is a good idea.

I saw someone sharing an open source Py library to get the current IP on v2ex, Which remind me that the proxy crawler I wrote before was verified by Taobao’s API. There are concurrency restrictions, and maybe I can change it to a better way.

There is a traditional gateway link Python Challenge, which was played a long time ago and happened to see a blackboard crawler breaking through to record the process of gateway breaking.

Last night, I saw Gift Book Activity on the V2EX, and the first three comrades with the same number of responses and the last number of the Shanghai Composite Index can get the gifts.

Anti-reptiles are numerous, the most common one is to check the Header, and the second is to block the IP based on the frequency of the visit. There are many websites that provide agents on the Internet, but the actual available IP is very small, and the purchase of the charging interface is not suitable for small projects. Therefore, it is very necessary to build a pool of your own crawler agent.

I made an automated tool recently and found that it was horrible to get the current coordinates of the mouse when developing. It’s a waste of time to use the Photoshop ruler for viewing the screenshots, so I wrote a small tool to get the coordinates. The autopy library is used to implement the function, and Tkinter is used to draw the interface. Convenient for further development in the next step.

There are many ways to hide files in images on the web, which can also be done in Python, which avoids the blocking method of matching links or text. Most of the rumors circulating on the Internet are rar format. I have tried it for free, zip can also, find some information, and organize the process as follows.