Tech Articles
30 Ways to Optimize Your SQL
Boost SQL efficiency with indexing, JOINs, partitions, and advanced techniques for faster queries and scalable systems.
Hono.js: The Next-Gen Node.js Framework
There are already many backend libraries and frameworks for Node.js on the market. I've used Nest.js for some small projects before. It has comprehensive functions and enables rapid project implementation. However, for my small projects, many of its features are really overkill, and it has a high level of encapsulation, leaving little freedom when writing code.
Designing RBAC Permission System with NestJS: A Step-by-Step Guide
Step-by-step guide to implementing RBAC permission control using Nest.js with database setup and entity relationships.
Mastering Express.js: A Deep Dive
Express is an extremely commonly used web server application framework in Node.js. Essentially, a framework is a code structure that adheres to specific rules and has two key characteristics: - It encapsulates APIs, enabling developers to concentrate more on writing business code. - It has established processes and standard specifications.
Deep Dive into Go Struct
Let’s dive into all aspects of Go structs.
2024 in Review: Key Highlights in Cloud Databases
A 2024 review of cloud database innovations, highlighting vector databases, AI integration, key trends, and industry developments.
How to Get the Goroutine ID?
In an operating system, each process has a unique process ID, and each thread has its own unique thread ID. Similarly, in the Go language, each Goroutine has its own unique Go routine ID, which is often encountered in scenarios like `panic`. Although Goroutines have inherent IDs, the Go language deliberately does not provide an interface to obtain this ID. This time, we will attempt to obtain the Goroutine ID through the Go assembly language.
Fun Facts About Ghostty
How does Mitchell Hashimoto think of Ghostty?
Go Generics: A Deep Dive
Overall, the benefits of generics can be summarized in three aspects: 1. Types are determined during the compilation period, ensuring type safety. What is put in is what is taken out. 2. Readability is improved. The actual data type is explicitly known from the coding stage. 3. Generics merge the processing code for the same type, improving the code reuse rate and increasing the general flexibility of the program. However, generics are not a necessity for general data types. It is still necessary to carefully consider whether to use generics according to the actual usage situation.
How to Run Puppeteer in the Cloud for Free: Solutions Compared
Comparison of serverless platforms for Puppeteer: how to use them to accomplish a typical Puppeteer task, and their pros and cons.
A Deep Dive into Gin: Golang's Leading Framework
Gin is a HTTP web framework written in Go (Golang). It features a Martini-like API, but with performance up to 40 times faster than Martini. If you need smashing performance, get yourself some Gin.
High-Performance Python: Asyncio
Unlike multithreading, `asyncio` is single-threaded, but the mechanism of its internal event loop allows it to run multiple different tasks concurrently and has greater autonomous control than multithreading.Tasks in `asyncio` will not be interrupted during operation, so the situation of race condition will not occur.Especially in scenarios with heavy I/O operations, `asyncio` has higher operating efficiency than multithreading. Because the cost of task switching in `asyncio` is much smaller than that of thread switching, and the number of tasks that `asyncio` can start is much larger than the number of threads in multithreading. However, it should be noted that in many cases, using `asyncio` requires the support of specific third-party libraries, such as `aiohttp` in the previous example. And if the I/O operations are fast and not heavy, using multithreading can also effectively solve the problem.
Mastering Python Async IO with FastAPI
Asynchronous I/O is implemented at the bottom layer using "coroutines" and "event loops". "Coroutines" ensure that when the thread encounters marked I/O operations during execution, it doesn't have to wait for the I/O to complete but can pause and let the thread execute other tasks without blocking. "Event loops" use the I/O multiplexing technology, constantly cycling to monitor I/O events. When a certain I/O event is completed, the corresponding callback is triggered, allowing the coroutine to continue execution.
The Secret Behind FastAPI’s Speed
What’s the secret sauce behind FastAPI’s speed? Why does it leave others eating its digital dust?
Is Flask Dead? Is FastAPI the Future?
The article mainly discusses the current situation and development of Flask and FastAPI in the Python framework field. By comparing the adoption of new projects, the number of GitHub stars, and the proportion in official surveys, it shows that FastAPI's popularity has risen and exceeded that of Flask. Looking back at the development of web frameworks, although Flask once had advantages, it is limited by issues like plugin maintenance. FastAPI stands out with its asynchronous design, Pydantic data validation, and ASGI support. It also explains the decline of Flask's popularity from aspects such as community activity and discussion frequency. Finally, it introduces the advantages of the Leapcell platform suitable for deploying both.
WTH Is Synthetic Testing?
A brief and friendly introduction to synthetic testing.
Deep Dive into Microsoft MarkItDown
This is a deep dive into MarkItDown, exploring its features, architecture, limitations, and integration methods. It highlights how MarkItDown converts diverse file types into Markdown, and its extensible modular design. Practical examples, and API hosting guides are also covered.
Why Playwright is Dominating Browser Automation: A Deep Dive
Playwright is a modern browser automation framework that supports JavaScript, Python, C#, and Java, offering seamless interaction with major browsers such as Chrome, Edge, Firefox, and Safari. Unlike Selenium, which requires separate drivers for each browser, Playwright simplifies the process by eliminating the need for browser drivers. Its features include headless mode, concurrency support, iframe handling, and multi-tab operation, making it a versatile tool for automation tasks. Playwright also excels in debugging with built-in capabilities, automatic waiting, and integrated screenshot/recording tools. It is known for its ease of use, minimal configuration, and simple DOM manipulation. While its community is still maturing compared to Selenium’s, Playwright has quickly become a popular choice for web automation due to its efficiency and developer-friendly design. With its emphasis on scalability, performance, and compatibility across different environments, Playwright is an excellent tool for both beginners and advanced users looking to automate browser tasks effectively.
Will Your Marketing Email End Up in Spam? We Built a Tool to Find Out
This article discusses how to use Apache SpamAssassin, an open-source spam detection tool, to evaluate email spam scores and deploy it as an API for seamless integration into workflows.
WSGI vs ASGI: The Crucial Decision Shaping Your Web App’s Future in 2025
Asynchronous Server Gateway Interface (ASGI) and Web Server Gateway Interface (WSGI) are two Python protocols designed to bridge web servers and applications. WSGI is synchronous and ideal for traditional HTTP-based apps like blogs or corporate websites, with long-standing support in frameworks like Django and Flask. It is simple, stable, and widely used but struggles with high-concurrency or real-time communication.ASGI, introduced with Python's async/await features, is asynchronous, non-blocking, and supports modern protocols like WebSocket and HTTP/2. It is built for high-performance, real-time applications, such as chat apps and live data services, and is used in frameworks like FastAPI.