More with tags:

#ai

#GenerativeAI

#LLM

#NLP

#PostgreSQL

#prompt-management

#RAG

In this article, I will share my experience setting up a software demo project for a device, which can recognize and act on certain voice commands. The solution will be used to evaluate the feasibility of using ML (Machine Learning) approach to detect keywords in a constrained environment. Our demo is quite simple conceptually: a hardware device with connected LEDs and a microphone. The microphone is listening to voice commands recognizing three main colors: GREEN, RED, and WHITE. For each […]

Once upon a time, before “AI” was a word of the day, our team had been building advanced solutions in the area of image processing, powered by Machine Learning (ML) and AI (Artifical Intelligence). Today, we are introducing a Santa Pix project, an image editing and cropping app powered by ML. Santa Pix is designed for both iOS and Android users, enabling them to pick any image from their smartphone gallery and edit it on the spot. The platform offers […]

OpenAI’s ChatGPT captured imagination of the world with unlimited possibilities it can bring to our daily life. Our mobile team had many ideas for the projects, and one of them revolved around creating a smart keyboard powered by AI. Introducing Keyssistant Keyssistant is a mobile keyboard extension that seamlessly integrates AI-powered capabilities into all messaging apps on your smartphone. The solution connects to ChatGPT via the OpenAI API. The extension offers a selection of AI-generated responses in various conversational styles, […]

Explore our project where we developed firmware with ML capabilities for a smart autoinjector and integrated it with our custom app, revolutionizing self-medication and comprehensive care. In collaboration with a leading pharmaceutical company, our team has developed a system that transcends traditional paper logs and manual reminders, fostering a more intuitive treatment experience. This initiative not only focuses on drug manufacturing but also on delivering complete care solutions, including smart packaging that tracks medication intake and supports remote monitoring for […]

Executive Summary Challenge: To modernize its Project and Portfolio Management (PPM) SaaS platform,  OpenText (formerly Micro Focus) made the call to shift its products from on-premises Oracle servers to PostgreSQL on Amazon RDS. They faced various hurdles due to inconsistencies within the database and the legacy architecture of their app. They also requested a reusable custom algorithm for forthcoming migrations. Solution: The ABCloudz team successfully migrated the OpenText database from Oracle to Amazon RDS cloud. The ABCloudz team leveraged DMS […]

In this post we’d like to share with you our experience in delivering a sophisticated database migration solution on top of AWS DMS for one of our large enterprise customers. The client is a large technology corporation that provides software solutions and services for telecom giants and mid-size companies. They ran numerous Oracle databases where they stored billing and other financial data. In an effort to cut costs for operational infrastructure, the company started the migration of their Oracle systems […]

In this post we continue exploring the technical aspects of Oracle to PostgreSQL migration using AWS SCT. We were using AWS SCT build#660 to convert one of our Oracle test databases. AWS SCT provides functionalities for the most efficient migration from Oracle to PostgreSQL. However, there is a common challenge with implementing the Oracle NumToDSInterval function in PostgreSQL. The Oracle NumToDSInterval function is responsible for the conversion of the provided number value of specified time units or expressions to an […]

In this post we continue exploring the technical aspects of Oracle to PostgreSQL migration using AWS SCT. AWS SCT promises a very high level of migration efforts, however it is very rare that 100% automation is achieved. In this article we’ll look into conversion of INSERT ALL statements, which are quite popular in Oracle code. We were using AWS SCT build #660 to convert one of our Oracle test databases. Oracle gives you an option to use the conditional insert […]

In this post we explore the technical aspects of Oracle to PostgreSQL migration using AWS SCT. We’ll look into conversion of Oracle “aliases”. We were using AWS SCT build #660 to convert one of our Oracle test databases. The challenge Oracle’s subtype declaration allows creating an “alias” for some datatype declaration, which can be re-used later as many times as needed. PostgreSQL domains entirely differ from Oracle’s subtypes. Thus, whenever you try to convert PL/SQL code containing variables that are […]