• Use custom ID in Rustdesk

    calendar Sep 15, 2023 · 1 min read · rustdesk  ·
    Share on: linkedin copy

    Recently, I changed my remote assistance tool to Rustdesk, but a inconvenient thing is that the ID for a host is randomly generated, which is hard to remember.

    So I want to customize the ID.

    This solution is tested okay on Rustdesk v1.3.1.


    Read More

  • MySQL server starts very slowly in Docker container

    calendar Mar 19, 2023 · 1 min read · mysql docker  ·
    Share on: linkedin copy

    I have a MySQL server deployed in a Docker container for testing purposes.

    Recently, I found that the server started extremely slowly in the container.

    After investigation, it turned out that the problem was caused by the too large open-file limits…


    Read More

  • Two datetime systems in Excel

    calendar Oct 25, 2022 · 2 min read · excel date  ·
    Share on: linkedin copy

    stupid-excel-datetime-schema

    Long time ago, I create a command-line tool to convert Excel files to JSON files and vice versa. A few days ago, one of my colleagues reported a strange bug to me: some date values in sheets was wrong after converting to JSON.

    At first, I didn’t pay much attention to it. A few days later, he continued to follow up this issue, and spotted the clue: copying values from the .xlsx file with problem, into another new Excel file, the date value was different; but if copying into another sheet in the same file, the date value was still the same… 😐


    Read More