BestHub
Sign in
37 Interactive Technology Team
Author

37 Interactive Technology Team

37 Interactive Technology Center

126
Articles
0
Likes
349
Views
0
Comments
Recent Articles

Latest from 37 Interactive Technology Team

100 recent articles max
37 Interactive Technology Team
37 Interactive Technology Team
Jul 29, 2024 · Artificial Intelligence

AI-Generated Unit Test Cases: A Reflection-Based Workflow for Automated Testing

The article describes a reflection‑based workflow that lets an AI iteratively generate, validate, and refine Go unit tests until 70 %+ code coverage is reached, using coverage‑out parsing, role‑based prompts, and automatic error correction, enabling fully autonomous test creation that can be integrated into CI pipelines to dramatically improve developer productivity.

AI testingCI integrationGo Testing
0 likes · 7 min read
AI-Generated Unit Test Cases: A Reflection-Based Workflow for Automated Testing
37 Interactive Technology Team
37 Interactive Technology Team
Jul 8, 2024 · Operations

Investigation and Resolution of Intermittent Timeout Between Cloud Host A and Cloud Game Server B Caused by tcp_tw_recycle

The intermittent timeout between cloud host A and game server B was traced to the server’s net.ipv4.tcp_tw_recycle setting, which dropped SYN packets with non‑monotonic timestamps after NAT translation, and disabling this kernel parameter restored normal connectivity.

LinuxNetwork TroubleshootingTCP
0 likes · 4 min read
Investigation and Resolution of Intermittent Timeout Between Cloud Host A and Cloud Game Server B Caused by tcp_tw_recycle
37 Interactive Technology Team
37 Interactive Technology Team
Jun 17, 2024 · Databases

MySQL 5.7‑to‑8.0 Upgrade Plan, Compatibility Checks, and Blue‑Green Deployment on AWS RDS

Facing MySQL 5.7’s February 2024 end‑of‑life, the team devised a zero‑impact blue‑green migration on AWS RDS to MySQL 8.0.35, using util.checkForServerUpgrade() compatibility checks, pt‑upgrade SQL validation, and a rapid 2‑minute switchover that completed within the planned low‑traffic window.

AWS RDSCompatibility CheckDatabase Upgrade
0 likes · 12 min read
MySQL 5.7‑to‑8.0 Upgrade Plan, Compatibility Checks, and Blue‑Green Deployment on AWS RDS
37 Interactive Technology Team
37 Interactive Technology Team
May 27, 2024 · Artificial Intelligence

Enhancing AI Code Review Quality with Contextual Embedding and Function Calling

The article explains how AI code reviews suffer from missing context, and improves them by embedding the codebase, using Retrieval‑Augmented Generation to fetch relevant snippets, and adding a function‑calling tool that lets the model autonomously request additional code, resulting in precise, bug‑detecting feedback.

AI code reviewEmbeddingFunction Calling
0 likes · 8 min read
Enhancing AI Code Review Quality with Contextual Embedding and Function Calling
37 Interactive Technology Team
37 Interactive Technology Team
May 20, 2024 · Game Development

Introduction and Implementation of MaxSDK for Unity Cross‑Platform Game Development

The article presents MaxSDK, a unified C# SDK for Unity that abstracts platform‑specific native SDKs across Android, iOS, Windows, macOS and future platforms, offering a singleton interface, abstract base classes, data models, and callback listeners to dramatically cut integration effort, maintenance cost, and enable easy extension to other engines.

AndroidCCross‑platform
0 likes · 21 min read
Introduction and Implementation of MaxSDK for Unity Cross‑Platform Game Development
37 Interactive Technology Team
37 Interactive Technology Team
May 16, 2024 · Databases

Optimizing SQL Query Performance with EXPLAIN Statements

Optimizing SQL query performance hinges on confirming that the database engine fully leverages indexes, and the EXPLAIN statement provides a detailed execution plan—including key_len values—that shows whether each index field is completely used, enabling developers to identify and fix inefficient index usage.

Database PerformanceEXPLAIN StatementIndex Utilization
0 likes · 5 min read
Optimizing SQL Query Performance with EXPLAIN Statements
37 Interactive Technology Team
37 Interactive Technology Team
Apr 15, 2024 · Backend Development

High-Performance Data Collection and Persistence Using OpenResty, Lua, and Kafka

The article describes a high‑throughput, fault‑tolerant data‑collection pipeline built with OpenResty, Lua, and Kafka that writes incoming records to disk using a cross‑worker mutex and cached file handles, rotates files via Nginx reload, and achieves over 13× performance versus typical online methods.

DataIngestionFileIOHighPerformance
0 likes · 7 min read
High-Performance Data Collection and Persistence Using OpenResty, Lua, and Kafka
37 Interactive Technology Team
37 Interactive Technology Team
Mar 18, 2024 · Databases

Handling MySQL Read‑Only Errors During Master‑Slave Switch in Go: Extending the Driver and Using rejectReadOnly

When a MySQL master‑slave switch makes the old master read-only, Go connection pools keep reusing stale connections and cause prolonged write errors, but by extending the driver to return driver.ErrBadConn on error 1290 or using the DSN flag rejectReadOnly=true, the bad connections are discarded and the error disappears almost instantly.

ConnectionPoolDatabaseSwitchDriverExtension
0 likes · 14 min read
Handling MySQL Read‑Only Errors During Master‑Slave Switch in Go: Extending the Driver and Using rejectReadOnly
37 Interactive Technology Team
37 Interactive Technology Team
Mar 4, 2024 · Mobile Development

Android Plugin Architecture Overview and Implementation Guide

This guide explains Android pluginization, showing how a host app can dynamically load separate APK modules—including native libraries, classes via a custom DexClassLoader, and mixed resources—while supporting hot updates, modular isolation, and reduced initial size, and details each loading step and manager implementation.

AndroidDynamic LoadingResources
0 likes · 31 min read
Android Plugin Architecture Overview and Implementation Guide