Systems | Development | Analytics | API | Testing

When building Node.js applications that interact with relational databases, you have a large variety of tools at your disposal to manage and execute queries. The three most common approaches — raw SQL, query builders, and Object-Relational Mappers (ORMs) — offer unique advantages and challenges, making it difficult to decide which is best. In this guide, we will compare the strengths, trade-offs, and use cases of all three approaches.

Testing is necessary to produce working code, but it can be difficult and takes a lot of time! By reducing the time and cost of testing, we can increase the pace at which we can ship reliable and working features to customers. In this article, we'll explore easy and quick ways to collect and generate data and create schemas for testing.

With the release of Node.js v23.6.0, developers can now use TypeScript natively without additional transpilation tools like ts-node or manual compilation steps. This milestone significantly streamlines development workflows, simplifying build processes and improving the overall developer experience by reducing complexity.

Artificial intelligence is revolutionizing software development, and at NodeSource, we're bringing AI-driven insights to Node.js applications through N|Solid. Our latest AI-powered profiling and diagnostics tools help developers streamline performance analysis, optimize application efficiency, and proactively detect bottlenecks. In this post, we'll dive into how AI enhances observability, simplifies CPU profiling, and generates actionable recommendations that improve performance debugging workflows.

It is essential that you test sites and web applications to ensure their reliability, functionality, and user experience. Thanks to its rich API and impressive list of features, TestCafe has emerged as one of the most popular choices for automated end-to-end testing in Node.js. In this guide, you'll learn what TestCafe is, understand how it works, explore its features, and see it in action with a complete example. Time to become a TestCafe testing expert!

Tracing is a critical feature in N|Solid that allows developers to analyze application performance by visualizing the relationships between different processes through spans and traces. Without proper tracing, debugging performance issues becomes significantly more challenging, as developers lack visibility into how requests flow through an application. Tracing helps pinpoint bottlenecks, optimize request execution, and improve overall application efficiency.

In Node, managing asynchronous operations effectively (especially those involving I/O, like network requests or file system access) is crucial to prevent resource depletion. Managing async operations well also helps maintain optimal application performance when the results of operations are no longer required. The AbortController API addresses this need by providing a standardized mechanism to terminate operations gracefully.

When debugging performance issues in a Node.js application, CPU profiles play a crucial role in identifying bottlenecks. However, if your code is transpiled or minified, analyzing these profiles can be a challenge. This is where sourcemaps in N|Solid come in, helping you trace your code back to its original form for more meaningful insights.

Keeping your Node.js version up to date is essential for security, performance, and access to the latest features. New releases often include bug fixes, optimizations, and improvements that can enhance your development workflow. If you're using Windows, there are multiple ways to update Node.js, whether you prefer a simple installer, a package manager, or a version manager. In this guide, we’ll walk through different methods, so you can choose the one that best fits your needs.