Systems | Development | Analytics | API | Testing

PostgreSQL's EXPLAIN command is a powerful tool that provides insights into how a query will be executed. It helps developers and database administrators identify potential performance issues in their queries. In this blog, we will explore what EXPLAIN is, when to use it, how to interpret its output, and techniques for optimizing queries based on the insights it provides.

Unit tests are essential for increasing the test coverage of a backend application, ensuring its reliability, functionality, and robustness. Jest has become one of the most popular solutions when unit testing in Node, due to its intuitive API, zero-configuration philosophy, and flexible approach to code transpilation. In this guide, you will learn more about Jest, explore its features, and see it in action through a complete example. Become a Jest unit testing expert!

In the previous part of this series, we discovered how to create persistent connections in Rack in theory, but now we'll put what we learned into practice. The web has two formalized specifications for communication over a persistent connection: server-sent events (SSEs) and WebSockets. WebSockets are widely used and highly popular, but SSEs are far less well-known. Let's explore them first.

In today’s digital age, data has evolved from being a mere byproduct of business processes to becoming the cornerstone of strategic decision-making. Yet, for many organizations, unlocking the full potential of their data remains a significant challenge. Traditional data analytics models often create bottlenecks, relying heavily on overextended IT departments to provide insights, which delays decision-making and limits agility.

One of the most important aspects of a product is the ability to showcase its functionality. In the API space, it’s very important for a product to not just claim something, but to show that utility and use. One of the best ways to do this is through the use of a demo environment. A demo environment is a perfect method to surface a specific use case or example for users, showcasing functionality that is often tailored to a specific interest group.

Learn everything you need to know about creating a test automation strategy from Marcus Merrell, from designing and implementing a scalable test automation operation to overcoming common challenges.

In today’s data-driven world, visualization goes beyond displaying numbers — it’s about empowering users to express meaningful stories from data. Visualization is key to quickly interpreting data, uncovering patterns and trends, and enabling faster, more trusted decisions. At ThoughtSpot, we have always championed making data accessible and actionable for everyone. With our AI-powered analytics, any user can self-serve key business insights within seconds.

Today, we are excited to announce the availability of Volume Snapshots in public preview! Snapshots are an essential feature to backup your High-Performance Volumes, simplify data management and allow reproducibility. With Snapshots, you can create an immediate point-in-time copy of your Volumes with a simple CLI command or click, enabling: Volumes and Snapshots are available today in our Frankfurt, EU and Washington, US regions!

We recently helped our customer Holocafé prepare its Laravel application for a TV appearance on the German edition of Dragons’ Den (Höhle der Löwen) and the corresponding peak in traffic. The primary change was to utilize Cloudflare as an HTTP reverse proxy to cache the main page of the site and a few other mostly static pages that users were most likely to click on. The expectation was that 80-90% of the curious users could be served with pages from the HTTP cache.

When it comes to mobile app development, slow build times are not only the biggest source of frustration for developers but also the greatest barrier to innovation and competitive advantage. We surveyed developers at DroidCon New York and they overwhelmingly reported that build delays hindered their ability to release new features, fix bugs, and iterate quickly. Two-thirds of respondents said they wait more than 10 minutes for their mobile builds.