Categories

130 pages

Computer

Linux Server, Reset MySQL Password

I had an idle Tencent Cloud server that was expiring at the end of the year and I hadn’t planned to renew it. So, I decided to deploy a MySQL database for development purposes. When reinstalling the system, I wanted to save time and chose a third-party image provided by Tencent Cloud, which already had MySQL installed. I thought the system should include a Readme file or similar documentation explaining the password and deployment path.

A Brief Overview of Automated Testing

The investment in testing for financial trading systems far exceeded that of other systems, with tedious test steps repeatedly executed and a low ROI. As projects and personnel changed, uncontrollable factors inevitably introduced, a common situation being the modification of a field output from Interface A impacting the results of Interface B. With each version release, risk also accumulated.

Theoretical Knowledge

  • How to Measure the Value of Automation? An automation testing ROI = (Manual Execution Time) * (Number of Runs) / (Development Cost + Maintenance Cost)
  • Which Features Should Be Automated? Frequently used features that are unlikely to change. Writing automated test code for this type of interface yields the highest returns.
  • Why Choose This Timing to Drive Automation Testing? Not appropriate near project launch – distant water doesn’t quench immediate thirst; automation is a long-term return model. It’s most suitable when the project is already in a production environment and within a stable release cycle.

Framework Selection

Given the task of automation testing without prior practical experience, a typical starting point is to open a search engine and find tools and frameworks that can be used with the current system’s technology stack, review the user manuals, and get started. If you can immediately find a suitable tool, congratulations, perfect start!

Why Do We Need to Learn a New Language?

Starting from my academic years, I’ve been working with C++ for over ten years. So, why do I need to learn other programming languages?

Work experience: Lacking experience in elegant module design, C++ syntax is freeform. Learning other languages helps me guide the development of more elegant designs.

I often use them when writing some tools. The design principles for low-level libraries and business modules are also becoming clearer.

Visual Studio Compilation Character Set [Converted]

C++ cross-platform development. Commonly encountered on Chinese operating systems: error C2001 - constant contains a newline character.

Visual Studio

cmake organizes the project compilation script, generating a temporary solution under the windows system for development. The reason for cross-platform compatibility is that the file encoding is chosen as utf-8.

The cited reference provides a detailed explanation of the causes of the problem from first principles.

Regarding encoding, MSVC has dedicated compilation options /source-charset and /execution-charset. The former indicates the encoding of the file itself, and the latter indicates what encoding the byte array inside the compiled character set is. Encoding issues can basically be solved using these two options.

Quickly calculate folder size on the Windows platform

The Linux platform is very simple: du -sh * – just one line of code solves the problem. What about Windows? With many disks and a desire to clean up, with numerous files, the system’s built-in Resource Manager is too slow to calculate folder sizes, making you want to give up.

Everything

For developers working on the windows platform, you probably haven’t personally used everything, and should at least have heard of it. Its search speed far exceeds that of the built-in file explorer. Given that system-level support for fast indexing exists, we can certainly find similar tools that build file indexes while also calculating file sizes.

How to Copy Webpage Stylesheets (CSS): Element Inspector

Static blog themes, the mainstream is based on foreign templates, modified and adjusted without much consideration for Chinese content layout.

Main Text

About half a month ago, I adjusted the blog’s stylesheet – as I’ve been developing backend services for many years, I’m a pure newbie in frontend. After struggling with it for half a day, the design wasn’t quite reasonable. Suddenly an idea struck me: I looked at the technical blogs I often read – infoq and OpenChina – and their layouts look really good. Could I borrow some of those? After reviewing the source files, I got lost trying to locate the relevant elements.

Editing Extremely Large Files on the Windows Platform: EmEditor (Text Editor)

The Shanghai GuoAn database incident, which caused a huge stir within the black hacking circles, remains unclear whether it’s true or false. Let’s see what we remember in two years and look back on it then. Based on past experience, I updated a batch of local social engineering databases, and I encountered a massive SQL file: 17.9G. A regular text editor couldn’t even preview it, let alone open it. Chatting with netizens, someone mentioned EmEditor.

Adding a code copy button for seemingly simple things

Spent four hours on this, and when I saw the sentence, it was hilarious. How could it have taken so long? Finally looked at the time: three hours.

This was the first draft of the year 2022, and it wasn’t complicated – exactly as the title said. (At that time, I was still quite young), I thought simply copying 作业 would be enough, putting it in my favorites folder, and letting it sit for over a month before finally remembering the task.