Systems | Development | Analytics | API | Testing

Error Reporting: Improving Outcomes with Proactive Identification

Errors happen. Despite best efforts, no piece of software is perfect. Unintentional issues with code, updates to existing frameworks, or unexpected interactions with other tools can all cause errors. As a result, it's critical for companies to deploy robust and reliable error reporting processes that help them proactively identify potential issues and improve operational outcomes.

SQL Puzzle Optimization: The UDTF Approach For A Decay Function

How do you implement a decay function in SQL? You can use window functions, which scale better than joins, or better yet, you can try what Felipe Hoffa did: use tabular UDFs. In this video, Felipe shows you how you can use a tabular UDF to write custom code that can analyze a table row by row while preserving state. Felipe wrote a table UDF in JavaScript that uses a low amount of memory to keep track of the decaying values. He was able to run it in 36 seconds, instead of the 46 seconds that the SQL with windows solution took; and then he optimized the JavaScript even further and ran it in just 9 seconds.

Space-Based AI Shows the Promise of Big Data

At a distance of a million miles from Earth, the James Webb Space Telescope is pushing the edge of data transfer capabilities. The observatory launched Dec. 25 2021 on a mission to look at the early universe, at exoplanets, and at other objects of celestial interest. But first it must pass a rigorous, months-long commissioning period to make sure that the data will get back to Earth properly. Mission managers provided an update Feb.

Cost-Per-Order Formula for E-Commerce Explained

Our Five Key Points: You have a customer. They want a product: you sell that product. It’s simple, but how do you know if you’re charging the right amount for that product? Knowing how to calculate the cost per order is essential in helping you set the correct prices for your products and services. As an e-commerce retailer, you’ll naturally have lower overheads than a brick-and-mortar store.

Data Warehouse Automation: What, Why, and How?

Building a data warehouse is an expensive affair and it often takes months to build one from scratch. There is also a constant struggle to keep up with the large volumes of data that is constantly generated. On top of that, setting up a strong architectural foundation, working on repetitive and mundane data validation tasks and ensuring data accuracy is another challenge. This puts tremendous stress on data teams and data warehouses. Data warehouse automation is intended to handle this growing complexity.

Scaling Microservices with Contract Testing and Pactflow

API growth continues to rise within the modern enterprise. Microservices, are a leading growth driver for APIs as development teams continue to break down monolithic systems, seeking to capitalize on the advantages of decoupled capabilities. Benefits such as reduced costs, reduced time-to-market, faster release cycles and decentralized evolvability are possible. However, as APIs become increasingly prolific and central to core business functions, such benefits do not always linearly scale.

The SmartBear API Platform: Driving Quality, Consistency, and Collaboration Across Your Development Workflow

APIs have never been more instrumental in business. Organizations use them to deepen partnerships, accelerate development, integrate capabilities, and generate revenue. These business drivers, combined with the rise of microservices, drive incredible growth in the API space. According to the most recent State of Software Quality API report, 61% of survey respondents chose microservices as the technology that will most likely drive API growth.