Systems | Development | Analytics | API | Testing

January 2022

11 Tips to Boost SQL Query Optimization

When enterprises and companies are having trouble with SQL query optimization, they frequently turn to performance tuning tools and optimization strategies. This will not only help in analyzing and speeding up queries, but also in resolving performance issues, troubleshooting bad performance, and avoiding or minimizing the impact on SQL Server databases. Data accessibility, availability, and performance are critical to corporate success.

Using Native API/Native Code vs SourcePro DB

Fast access to data is more important now than ever before. Native applications often can produce that extra bit of performance that makes the difference. But the push to leverage lower level APIs comes with its own set of challenges and costs. SourcePro has been designed to allow you to focus on solving your business problems instead of getting bogged down in unclear and error prone low-level API coding.

Allan Gray: Intelligent Client Onboarding Process Automation

Allan Gray, a Wealth Management company in South Africa, processes thousands of client transactions a day. They built their client onboarding process on Appian’s low-code platform with Know Your Customer (KYC) functionality and dramatically reduced the onboarding friction experienced by their clients. Watch this video to see how the lean delivery team in Cape Town has been able to deliver new features and functions every few weeks and months, instead of months and years, while drastically enhancing user and customer experience.

How to Create API Value Chains to Grow Your Business

An application programming interface (API) value chain connects you to your customers through a series of partners. Unlike browser-based web apps where your customers buy goods or services directly from your website. APIs are a vital component of your digital business strategy. They help you analyze data and enable a multi-cloud strategy that can dramatically accelerate your time-to-market. Once you know how to create API value chains, you can implement them right away.

.NET Core vs .NET Framework: How to Pick a .NET Runtime for an Application

A while back we predicted that.NET Core would be the next big thing, offering developers many options in application development. Indeed, there is huge demand for developers skilled in this technology. But how does it differ from the.NET Framework, and what do you need to know to use them both effectively? Today, we’ll contrast.NET Core vs.

Fitness App Development: An Innovator's Guide

Fitness app development is exploding — what health company isn’t trying to create a fitness app for their customers? According to Allied Market Research, the global fitness app market size was valued at $13.78 billion in 2020 and is projected to reach $120.37 billion by 2030. With the COVID-19 pandemic keeping people at home, consumers are looking for new ways to keep exercise interesting. Adaptable brands are rushing to provide the next best service.

3 Imperatives to Transform Financial Institutions

Digital transformation in the financial services industry is driving rapid change in the way financial institutions do business. Consumer expectations are growing. Managing money and investments through digital mediums is the new normal. But financial institutions face heavy regulations that can make it difficult to keep up with transformation. To stay competitive and digitally transform, financial organizations can prioritize these imperatives for a differentiated customer experience. 1.

Why Mulesoft May Not Be Right For You

Mulesoft is often considered one of the leading names in data integration. It has a wide range of features that allow companies to integrate their applications, run analytics, and automate business processes. However, before you consider Mulesoft for your company’s needs, here are some reasons why Mulesoft may not be right for you.

Test and Optimize Your Ruby on Rails Database Performance

In this article, you will learn how to test database performance in Rails and solve some of the most common database performance issues. When you develop a Rails application, ActiveRecord is the default tool that manages your database. ActiveRecord provides an easy and fast interface to query and insert data using commands like.where, .save, .create, and.update. Rails does the work of converting these commands to SQL queries, which is a good thing, but sometimes can cause performance issues.

3 Steps to Successful Process Mining

Processes exist within organizations to help them carry out the tasks and activities necessary to keep the business running. But often, these processes don’t run as smoothly as they should. Inefficiencies creep in, certain activities take longer than necessary, or important steps are skipped altogether. How can you get at the root of the issues that are bogging down your processes to get them running more smoothly and efficiently? The old approach to process optimization is no longer enough.

Securing Your Phoenix LiveView Apps

LiveView is a compelling choice for building modern web apps. Built on top of Elixir's OTP tooling, and leveraging WebSockets, it offers super fast real-time, interactive features alongside impressive developer productivity. In this post, we'll show you how to secure your live view routes with function plugs and group live routes in a secure live session. Let's dive straight in!

In-depth analysis of the APM performance cost in Node.js

TL; DR: Based on the APM benchmarks results is evident that one of the main performance problems for a Node.js application in a production environment is the usage of the very same applications in charge of monitoring the performance for the application itself. This article explains the reasons with an in-depth analysis to show why using most APMs in a Node.js application is that expensive performance-wise.

How To Choose the Right API Business Model

The API economy is growing rapidly. According to research by Coleman Parkes enterprises were twice as likely as their peers to be confident they are differentiating themselves by using Application Programming Interfaces. The same report showed that companies with advanced API management processes experience up to 47 percent better business results than those with basic API management.

7 Best WordPress Payment Gateway Plugins

WordPress is an excellent platform to start an online store, but it’s missing many crucial features to support an eCommerce experience. But what is eCommerce? It refers to all forms of online transactions, but the term is often used interchangeably with “online shopping.” The further explanation could be found on Hostinger. To create an online store and enable eCommerce features, you need to activate a payment gateway.

How to Fix The IllegalStateException in Java

An IllegalStateException is a runtime exception in Java that is thrown to indicate that a method has been invoked at the wrong time. This exception is used to signal that a method is called at an illegal or inappropriate time. For example, once a thread has been started, it is not allowed to restart the same thread again. If such an operation is performed, the IllegalStateException is thrown.

Golang Debugging Tutorial

Golang or Go is a well-established programming language ground built for speed and efficiency. Robert Griesemer, Rob Pike, and Ken Thompson designed the language at Google. It was first announced to the public in 2009, and it was made open source in 2012. Go is the preferred choice among developers, but its simplicity can also leave it vulnerable to bugs and other programming issues.

Improve KYC Compliance and Customer Experience Using Low-Code

Managing and reporting on compliance can challenge businesses in any industry. For financial institutions, the stakes are even higher as regulations rise, data management increases, and expectations for transparency grow. Financial firms are under pressure to deliver a great customer experience while managing costs, risk, and compliance and maintaining operational resilience. Know your customer (KYC) requirements have become increasingly important to manage.

Top Reasons Why You Should Choose PHP for Website Development

PHP has become a popular choice for many to create out-of-the-box websites and web applications. So much so that most websites are powered by PHP today. A popular server-side scripting language, PHP offers many benefits in web development. If you need to create a web application or a full-fledged website for your business, then you can count on PHP to build top-notch solutions. PHP offers many advantages over other technologies empowering developers to create well-customized solutions for clients.

How to Handle the InterruptedException Checked Exception in Java

Threads are a basic concept in concurrent and parallel programming . They allow programs to do multiple things at the same time and are often used for performing computationally intensive tasks in the background without interrupting the main program. This is accomplished through multithreading, a common programming and execution model which allows multiple threads to exist within the context of one process. These threads share resources but are able to execute independently.

Node.js Error Handling Best Practices: Ship With Confidence

Node.js error handling isn’t a walk in the park. When deploying applications into production, we want to know that all code has been tested for all possible complex scenarios. We can, however, avoid issues by preparing our code to properly handle errors. To do so, we need to understand: Today we’re going to take you through the above items and give you a tour of JavaScript’s main quirks for better insight and understanding.

Building innovative and secure financial services that help users save money

In this interview, we talked to Sudeep Sidhu, Neo Financial's Lead Mobile Engineer about how to provide better features for users, how to ensure the highest levels of security in fintech app development, and what the future of mobile finance and banking looks like.

Dynamic Observability - The Quest For Real-Time Debug Data

Rookout’s Dynamic Observability platform enables engineers to get instant code-level data and troubleshoot their cloud-native applications easier and faster, without adding code or waiting for a new deployment. But we’ll let this video speak for itself - take a look to learn what Rookout can do for you in your quest for debug data.

Federal IT Modernization Post-COVID - The Key to Speed is Low-Code - Part 1

In the post-COVID world, the federal government spends about three-fourths of its technology budget maintaining aging computer systems including platforms more than 50 years old and even some that use floppy disks, according to a recent Government Accountability Office report. But beyond updating decades-old technology, getting digital transformation right in government and elsewhere is about cultivating an organizational mindset that embraces change.

A Three-Step Guide to Insurance Transformation

The world of insurance has been one most heavily influenced by APIs and the API-first operating model. Today, insurance agencies can benefit from learning how the API-first operating model can enable your IT team to unlock data from legacy systems and more. Technology has left its imprint on the insurance industry, and now tools like APIs have created even more opportunities for success. With so much room for success, it is important to realizes the need for insurance transformation.

Unique WordPress Themes for a Travel Blogging Website

WordPress is among the most popular platforms you can use to create and run your own travel blog. It offers plenty of impressive and easy-to-use blogging features, so you don’t have to worry about a lack of experience. Because writing is just one of the many parts of travel blogging, it’s crucial that you install a theme that will allow you to create a feature-rich website, boasting a high-quality design ready for your carefully prepared content.

SOA vs. Microservices: A Head-to-Head Comparison

Traditionally, monolithic architecture has been used to develop large-scale apps. However, people have realized its drawbacks and limitations over time. Without adapting to modern agile practices and limited flexibility does not allow for a productive development process. Therefore, organizations have been searching for better, more reliable architecture to facilitate the development of large-scale, complex apps with a more productive workflow.

What is TTFHW?

TTFHW is not the most common acronym you’ll hear in the tech and product domain. Even though it’s not extremely common, it can be argued that it is one of the most important acronyms for companies trying to scoop up and deliver value to new users. TTFHW, or Time To First Hello World, is likely something you’ve already thought about. Many product-led enthusiasts refer to it as the customers’ “aha!” moment.

3 Ways to Extend Your AWS Capabilities in 2022

Amazon Web Services (AWS) has millions of customers, making it one of the most popular cloud platforms in the world. With over 200 services from data centers globally — compute, storage, databases, machine learning, artificial intelligence, data lakes, analytics, Internet of Things, etc. — AWS makes it easier for businesses to move applications to the cloud and streamline workflows. Still, many gaps exist in native AWS tools, which can limit your company’s AWS capabilities.

The Five Pillars of CIAM

Transforming customer experience is at the heart of digital transformation. Digital technologies are changing the game when it comes to customer interactions, with new rules and possibilities that were unimaginable only a few years ago. Customer identity and access management (CIAM) is a new field of identity and access management (IAM) that is fundamentally a component of digital customer experience.

A Maturity Model for Customer IAM

The main objective of Customer IAM (CIAM) is to drive revenue growth by leveraging identity data to acquire and retain customers. It will build an identity-centric ecosystem to nurture an anonymous website visitor into a well-known loyal customer. We have come across multiple phases in the past, and today at the age of the customer, identity has become the glue for all contextual marketing. In doing that, in our journey towards CIAM, we face multiple challenges.

Identity and Access Management for Startups

Startups can be somewhat small to large scale businesses and they can vary between different fields of interest. With entrepreneurship becoming one of the hot trends of the decade, a lot of startups have shown up on the records. Many innovative ideas are converted into businesses. Some of these startups excel in large businesses whereas many meet the end of their line in a very short span of time. But this doesn’t keep entrepreneurs from capturing business opportunities.

[Node.js] Securing your applications Part 3/3

If you haven’t checked out the first two-part of our ‘Securing your Applications in Node.js’ series, click here and the second part here. This is a 3-part blog series on Node.js. This article aims to establish a Node.js security roadmap by addressing security challenges comprehensively and consistently for large infrastructures. Let’s begin! 🚀

How to fit agile methodologies into the constraints of fintech app development? - featuring N26

We talked to Dama Damjanović, Principal Engineer at N26 about how the regulations in finance and banking affect engineering teams behind fintech apps, how they can improve security, and what type of new technology will add the most value to the industry in the coming years.

Driving Solution Improvement with a Customer-Centric Approach: A Product Management Q&A

Customer focus is hugely important for the Appian product management team as we iterate on our solutions to keep pace with customer needs. Hearing directly from those who use the solutions every day is invaluable and offers our team insight into specific use cases and opportunities for optimization and enhancement.

Best WordPress Plugins to Optimize the Speed of Your Ecommerce Website

For many, no job will ever come close to the profound experience that is running a company. After all, as an entrepreneur, you get the unique ability to dictate your own course, something virtually impossible to achieve so long as you stay employed under someone else. You’re no longer required to follow the vision of others, as it is you who has the final say in everything. In simple terms, for the first time, you are the master of your professional fate.

Monorepo Javascript Projects with Yarn Workspaces and Lerna

Typically, every project that you do will have its own git repository. This approach can be cumbersome when those projects are closely tied. Monorepos promise a more convenient alternative. In this article, Saiharsha Balasubramaniam shows how to set up and manage a monorepo for a JS project using Yarn Workspaces and Lerna.

How to Handle the Illegal Monitor State Exception in Java

An IllegalMonitorStateException is a runtime exception in Java that occurs in multithreaded applications. It indicates that the calling thread has attempted to wait on an object's monitor, or attempted to notify other threads waiting on an object's monitor, without owning the specified monitor. Since the IllegalMonitorStateException is an unchecked exception, it does not need to be declared in the throws clause of a method or constructor.

Deliver pixel-perfect apps with Kobiton's test automation Steps

Kobiton is a mobile experience platform making your mobile apps work better everywhere: it lets you run your tests on a flexible and high-performing real device cloud, and based on your preferences and security requirements, they offer an on-premise solution too. Let’s see what you can achieve by implementing their Steps in your Bitrise Workflow!

Monitoring Appian with Appian: Orchestrating the Security Toolbox

In our previous blog post covering our in-house Security Orchestration, Automation & Response (SOAR) application, we described the data model for the system and basic features allowing security analysts to review events and trends across Appian’s many security monitoring systems.

Who will Dominate in the future: .Net or Java?

With the ongoing release of new technologies in the IT market, your choices for programming languages is also changing. This makes the task of choosing one among all the languages a tough job. Java and.Net are two renowned languages that have been involved in a locked horn competition for years. Since both languages offer unique benefits, opting for one is itself a brainstorming tussle.

How are APIs Enabling Supply Chain Digital Transformation?

The benefits of technology in the world of business are no secret. What is driving that technology today, however, is the use of APIs in areas like supply chain management. APIs are enabling the supply chain digital transformation from improved processes to forecasting and even being able to build better supply chain relationships. Being proactive versus reactive is the key to successfully managing your supply chain.

How to Handle the Unsupported Class Version Runtime Error in Java

Runtime errors occur when a program is being executed and, in the case of compiled languages, after the program has been successfully compiled. Runtime errors are, therefore, harder to detect and prevent than compile-time errors . This allows for a certain category of errors to be captured and dealt with before the program effectively starts.

How to Deploy ASP.NET Core to IIS & How ASP.NET Core Hosting Works

Previously, we discussed the differences between Kestrel vs IIS. In this article, we will review how to deploy an ASP.NET Core application to IIS. Deploying an ASP.NET Core app to IIS isn’t complicated. However, ASP.NET Core hosting is different compared to hosting with ASP.NET, because ASP.NET Core uses different configurations. You may read more about ASP.NET Core in this entry. On the other hand, IIS is a web server that runs on the ASP.NET platform within the Windows OS.

Readme: Beautiful solution for dev's documentation

Technology has completely changed the way business houses function today. Most of them have gradually started shifting from the traditional ways of creating their own services to the newer and smoother approach of deploying APIs. APIs have the potential to increase a firm’s revenue while extending their consumer reach. As such, having a tool that helps build quality API documentation is essential.

How to Use the Delegate Method in Rails

In most modern programming, there are objects that get involved with every aspect of an application. They are on a very high level in the hierarchy and need to interact with almost all other objects directly to ensure the proper functioning of the app. More often than not, these are objects involved in the overlaps of business logic: a User, Booking, or Account.

Securing your Applications in Node.js - Part 2/3

If you haven’t checked out the first part of Securing your Applications in Node.js, click here. This is a 3-part blog series on Node.js. This article aims to establish a Node.js security roadmap by addressing security challenges comprehensively and consistently for large infrastructures. Let’s begin! 🚀

Top Supply Chain Innovation Focus Areas for 2022

In 2022, organizations across industries will be leaning in to improve agility and resilience across their supply chain ecosystems. With ongoing disruption caused by the pandemic, changing customer expectations, an evolving technology landscape, and the demand for more sustainable practices, supply chain managers need efficient and transparent processes more than ever before. Organizations must concentrate on key aspects of transformation that will provide the greatest impact.

Unify Data Sources for Improved Data Management and Deeper Insights

As digital ecosystems become more complicated, some organizations assume that they need expensive ETL (extract, load, transform) platforms to unify data sources. While an ETL platform can offer robust features, you probably don’t need an entire system dedicated to unifying data from diverse CRMs. The right API solution can simplify your approach to real-time data unity. Plus, you don’t have to spend extra money on a high-cost platform.

Increasing Front-end and Back-end Developer Productivity using Codezero

Here at CodeZero we know that our developer platform for Kubernetes can lead to a 10x increase in productivity, and so we promote that fact proudly. "But wait!" you say. It's one thing to make that claim, but another to demonstrate exactly how this boost in productivity is achieved.

How to Migrate Your Blog from Gatsby to Next.js

A while back, you were probably looking for a great solution to create your blog, and Gatsby was the most popular solution floating around at the time. Now that some time has passed, a new player has risen to fame on the scene: Next.js has taken developer blogs by storm. Whatever your reasons for switching, we will explain how to switch from the Gatsby stack over to Next.js in this post.

Legacy Modernization and the Value of Enterprise Systems

Talk of what to do with legacy systems often causes angst among leaders. Retiring the system means lost functionality that might be too difficult to replace. Keeping it means more time spent on maintenance rather than value-added tasks. Replacing it can be a financial and logistical nightmare. The result of these talks is often to simply keep it and make do as best as possible.

Build Interactive Phoenix LiveView UIs with Components

LiveView empowers developers to build interactive, single-page web apps with ease by providing a framework that eliminates the need for guesswork. In this post, we'll take a look at how you can layer simple, single-purpose functional components to wrap up shared presentation logic. We'll also use more sophisticated live components to craft easy-to-maintain single-page flows that handle complex user interactions.

3 Best Boomi Alternatives

Boomi, previously known as Dell Boomi, is a well-known software provider for enterprise integration. It manages all the information and data that needs to flow between different companies, systems, and applications. Boomi products are designed to offer the best possible performance with the lowest possible latency. However, not everyone can afford or has room in their budget for this particular product.

What are Software Metrics? How to Track and Measure those Metrics?

Measuring software development teams' progress can be a crucial step toward improving efficiency and productivity. Software metrics can be used to track a variety of characteristics of software development. Understanding software metrics and how to track them will help you in better managing the programming process. In this article, we define software metrics, look at the many types, discuss how to track them, and outline the benefits and drawbacks of using them to assess productivity.

5 Technology Trends Insurance Companies Should Watch for in 2022

2021 was a busy year for insurers. Beyond supporting customers through an ongoing global health crisis, they’ve also faced increased competition from a growing number of insurtechs and pressure from customers to deliver a seamless, digital-first experience—all in addition to ensuring the overall customer experience is positive. All of these changes in the industry call for insurers to be more agile and open to change and innovation. 2022 is sure to continue to disrupt the status quo.

Is iPaaS Enough for System Integration?

Many organizations that already rely on Integration Platform as a Service (iPaaS) to integrate applications question the necessity of an API management system. The question of which to use over often confuses. So which one is the best choice? The answer is both. Here we’ll discuss why an Integration Platform as a Service alone isn’t enough. Companies will need to embrace both iPaaS and API management to achieve the true agility and innovation they need to remain competitive.

Low-Code and Agile 2: A Winning Combination

For something as complex as software development, there can be no “right” way of doing things all the time. Each project has its own set of variables, challenges, and idiosyncrasies. And every developer has a preferred way of working, which makes it difficult to set any hard and fast rules. But this doesn’t mean you should dive into your development projects head first, without guidelines or a methodology—albeit a flexible one—to inform the way forward.

OOP Concept for Beginners: What is Encapsulation

Encapsulation is one of the fundamental concepts in object-oriented programming (OOP). Let’s examine how it’s done and unwrap some examples for this concept. By definition, encapsulation describes the idea of bundling data and methods that work on that data within one unit, like a class in Java. This concept is also often used to hide the internal representation, or state of an object from the outside. This is called information hiding. The general idea of this mechanism is simple.

How does your website design and content affect customer interactions and conversions?

The aim of your website is obviously to get potential customers to engage with it as much as possible, and ultimately, make a purchase. But as we well know, it isn’t as simple as someone landing on your website and instantly converting. 9 times out of 10, there’s a whole sequence of actions that take place before a customer makes a purchase. The best thing?

Introducing Choreo Connect 1.0.0

Choreo Connect is a cloud-native, open-source, and developer-centric API gateway. It provides first-class support for Kubernetes while facilitating an array of API management quality of services (QoS), such as message security, rate-limiting, observability, and message mediation. As a microgateway, it provides additional flexibility, scalability, and resilience to meet today's cloud native demands.

How to Secure Single-Page Applications with Asgardeo

More often than not, securing access to your Single-Page Application (SPA) inevitably becomes an integral part of development. Asgardeo simplifies this by providing an Identity and Access Management (IAM) solution coupled with a suite of SDKs to easily integrate Asgardeo with various applications. In this article, we will explore how to use Asgardeo Auth SPA SDK to secure your SPA. If using React or Angular, Asgardeo’s React or Angular SDK can be used, further simplifying development.

Build a Data Driven Business: Follow These 4 Steps

To harness the power of big data, more and more businesses are adopting a data-driven business model. Adopting such a model allows your company to benefit from the rich information that databases, APIs, and other modern tools provide. Have you been thinking about learning more about how to unlock and transform your data into insights with API-led data integration? This article reveals the four primary steps required to create a data-driven business.

Open Banking Platform Strategy and the Need for APIs

There is simply no other industry in the world like banking. In addition to dealing with and handling large amounts of financial data, this industry also places the highest priority on security concerns and measures. For businesses using an open banking platform strategy, APIs present a safer, smarter, and better way to do banking and business. The future of banking is here, and it is the open banking platform.

The Rise of Super Apps: A Win-Win or Winner Takes All Phenomenon?

A new type of app called "super apps" are gaining popularity. They combine the functionality of several different apps into one convenient package. Originated in Asia, these apps are finally coming to the west. Here's what businesses should know about this new mobile trend in 2022.