More with tags:

#.NET

#Application Development

#AWS

#backend

#BLE

#connected-devices

#firmware

#IoT

#mobile-apps

#PostgreSQL

#react

#wearable devices

#web-app

Imagine trying to keep up with the evolving needs of higher education institutions while ensuring your systems are cost-effective and scalable. This was the challenge faced by our client, a company providing a suite of software solutions for educational institutions. They needed to modernize one of their core components—an Operational Data Storage (ODS) system, which essentially served as a Data Warehouse for preparing data for BI (reporting), originally built on Oracle—by migrating to PostgreSQL in AWS. The primary goal of […]

Migrating Oracle databases to PostgreSQL or MySQL with AWS Schema Conversion Tool (AWS SCT) can present a range of challenges, from unsupported data types to limitations in automated code conversion and potential performance issues. AWS SCT offers powerful capabilities to automate these migrations, but it may not always deliver optimal results or handle complex Oracle constructs efficiently. In these cases, manual adjustments and optimizations are required to ensure a seamless transition to the target database. At ABCloudz, our team has […]

When migrating from Oracle to PostgreSQL, one of the most important differences to consider is the treatment of null and empty string values. In Oracle, null and empty string are treated as the same entity, but in PostgreSQL, they are distinct. Failing to account for this distinction during migration can lead to logical errors and unexpected behavior in the database. This post will explore key nuances and demonstrate how to handle these differences effectively. Comparing null and empty string In […]

When working with PostgreSQL, database developers may encounter a limitation when attempting to create routines with more than 100 arguments. PostgreSQL enforces this restriction by setting FUNC_MAX_ARGS to 100 during the server build. Although this limitation is rarely an issue, complex procedures, particularly those migrated from Oracle, may have a significantly higher number of arguments. This blog post outlines a solution to handle such situations by utilizing composite data types to bypass the argument limit, ensuring routine compilation without significant […]

The AWS SCT Extension Pack is designed to emulate Oracle’s system functions, procedures, and other database objects within PostgreSQL. This emulation is achieved by creating a special schema in PostgreSQL, named aws_oracle_ext, where these functions and objects are stored. This pack simplifies migration by replacing Oracle-specific calls with their PostgreSQL equivalents, ensuring that the code functions correctly post-migration. For example, consider the following transformations: Oracle PostgreSQL SELECT sysdate FROM dual; SELECT aws_oracle_ext.sysdate() SELECT to_char(sysdate, ‘dd.mm.yyyy hh24:mi:ss’), to_char(sysdate, ‘dd.mm.rrrr’) FROM dual; […]

Imagine a business analyst whose task is to extract necessary information from a data warehouse to generate various reports. They need to be proficient in crafting SQL queries of any complexity—a challenging and time-consuming feat that requires deep understanding of database structures and SQL language. But what if this business analyst had an AI assistant to whom they could describe the required data and format in natural language? This assistant would understand the request and convert it into an SQL […]

Picture this: You have an AI-powered assistant that helps manage your team’s growth. It works with three types of text data: job descriptions, employee skills, and training programs. You give it a job description and an employee’s skill set, and it pinpoints the perfect training programs to bridge any skill gaps. It’s like having a tailor-made career coach that ensures your team is always ready for their next big challenge.We have developed precisely this kind of solution — an AI-based […]

This blog post examines the operational expenses of the AI-powered chatbot solution introduced in our previous blog posts, Custom AI chatbot using RAG and Deployment of AI-Powered Chatbot. This solution operates on the AWS cloud while integrating OpenAI’s language model. We will discuss the financial aspects of infrastructure costs and analyze how to estimate expenses for AI resources, such as Language Model as a service. Cost Structure of a Custom AI Chatbot Solution Operating expenses for our AI chatbot solution […]

This blog post focuses on the architecture and deployment of the AI-powered Chatbot solution that we described in our earlier blog post Custom AI Chatbot Development Using RAG. This solution is built for the AWS cloud but uses OpenAI as an LLM. We’ll dive deep into the CI/CD process and AWS deployment architecture of the backend application. AWS Deployment Architecture Our solution represents a rather typical configuration of a web project deployed to AWS. Click or tap on the picture […]

You have probably seen and heard about AI-powered chatbots that can converse with the user about website content, or some piece of knowledge related to a company. The world is full of buzz on all things AI, with chatbots driving the headlines. In this article, we’ll share our experience building a full-blown solution from scratch that empowers such chatbots. The goal is to build a framework that can be plugged in with any knowledge sources and be easily integrated into […]

This story is about our collaboration with Dusker, a renowned company dedicated to creating audio products that enhance bedtime experiences. Dusker’s Sleepbar v2.0 is a standout innovation in their product line. This advanced sleep speaker uses bone conduction technology to deliver audio directly through a pillow, making it ideal for listening to music, audiobooks, sleep sounds, and podcasts. It’s designed for comfort with no buds or wires, ensuring a peaceful sleep environment that’s particularly considerate for couples, as the audio […]

Immerse yourself in the technical intricacies of developing firmware that empowers a smart water bottle with a wide range of functionalities. This bottle’s purpose extends beyond merely tracking the user’s hydration level; it also timely reminds them to replenish their water intake. Equipped with a microcontroller and sensors, the bottle collects water consumption data and interacts with the user via a mobile application. While a detailed functional overview of this solution can be found here, this blog post will focus […]

In this blog post, we examine how a smart water bottle communicates with a mobile application using the Bluetooth Low Energy (BLE) communication protocol. The customer’s concept is designed to motivate users to maintain a healthy lifestyle by regularly consuming water and monitoring their hydration habits. A comprehensive functional overview of the entire solution is available here.   This post focuses on the technicalities of the BLE communication protocol as it facilitates interaction between the mobile app and the smart water […]

Imagine a bottle that does more than just hold water—a bottle that communicates with your smartphone, tracks your hydration levels, and nudges you towards healthier habits while conserving the environment. That’s the reality we’ve created with a solution that marries the simplicity of hydration with the complexity of technology. By integrating the bottle with iOS and Android apps using the energy-efficient Bluetooth Low Energy (BLE) protocol, users gain the power to monitor their daily water intake and, simultaneously, contribute to […]

We’ve developed a mobile app and web admin panel that allow a specialized headphone manufacturer for Heavy Metal enthusiasts to swiftly and conveniently deliver firmware updates for their headphones over the air. These headphones do more than just play music; they’re designed to precisely render sound, enhanced by continually evolving custom firmware for each model. How can users stay informed about the latest updates and improvements? This is where our expertise in wireless connected devices truly shines. We have crafted […]