Author: 永夜
-
Post Views: 79 1. Reference:Optimization of List Interface Response Timeout 2. Reference:In Spatie\QueryBuilder, query SQL enforces index 3. However, when the fields in where contain shipping_at_gmt, Shipping_status, operator_user_id, after forcing the combined index is a negative optimization. SQL execution time-consuming sorting is as follows 4. Preliminarily summarize the rules, when the fields in where contain Shipping_at_gmt and Shipping_Status|Shipping_Type|Operated_Source When the…
-
Post Views: 48 The correct display of code blocks is critical when writing a technical blog. Recently, I’m having trouble with code blocks using the WordPress Gutenberg editor, and I’m struggling to find a better solution. After repeated exploration, I finally summed up a complete set of ‘from manual to automatic’ complete plan, which can not only solve the problem…
-
Post Views: 102 Preface In most programming languages, it is quite complex to check if two binary trees store the same sequence of values. It is usually necessary to write a recursive algorithm to traverse the two trees and then compare them by node. But in the Go language, we can use its powerful concurrent primitives and channel (channel) mechanisms…
-
Post Views: 281 PrefaceRecently, many friends have asked me a very strange question: the WireGuard client shows ‘Last handshake time’ is obviously normal, indicating that vpn The connection has been successfully established, but both domestic and foreign websites can’t be opened. What’s going on?I also encountered the exact same problem: after checking for a long time, the allowedips configuration is…
-
Post Views: 66 In the previous Go concurrency review, I focused on the many drawbacks of ‘global variable lock synchronization’ through factorial cases, especially the core question of ‘there are still hidden dangers when adding locks and hibernation’ Question – Manually set the sleep time to accurately match the rhythm of the execution of the protocol. If the resource is…
-
Post Views: 71 In the process of using a Google account, it is inevitable to encounter the scenario of account security verification – when Google detects abnormal operations, or needs to confirm the account attribution, it will prompt to obtain security code through the device to complete the verification. For OnePlus 12 (ColorOS system) users, due to the built-in Google…
-
Post Views: 73 Self-built WireGuard VPN The most troublesome problem:The UDP port fails every 2 days or so, the client has no last handshake time, and the ports such as 57586, 2096, and 443 are repeatedly replaced., tossing back and forth a lot of trouble. The root cause: operator DPI deep packet detection, WireGuard native data packet features are fixed,…
-
Post Views: 45 In Go language concurrent programming, channel (pipe) is the core mechanism of communication between goroutines, which follows The design philosophy of communicating to share memory, rather than communicating through shared memory, fundamentally solves many hidden dangers of global variable lock synchronization. In the previous study, we understood the necessity of the channel through the factorial case. This…
-
Post Views: 69 Since LetsVPN officially announced that the service was stopped, many friends who pursue privacy and self-use network have embarked on their own way to build Wireguard. Recently, a reader sent me an email consultation: I am like me, I have started a VULTR $5 per month Singapore entry model, and the Wireguard has been built. After visiting…