How to select LLM for SQL generation

Imagine a scenario where a data analyst needs to generate SQL queries to extract specific information from a complex data warehouse, but without deep knowledge of SQL. Our goal was to create an AI assistant that translates natural language to SQL, and we wanted to find the optimal large language model (LLM) for this task. We needed a solution that balances performance and cost while handling the limitations of context windows. A context window refers to the amount of text […]

Mariia Horova (Full stack developer), Oleksii Svitlychnyi (Technical writer)
AWS Confirms The High Quality of Our GenAI Solutions

At ABCloudz, we are committed to delivering quality and trustworthiness in every solution we create. Recently, two of our AI-powered solutions, Natural Language Interface for Data Platform and AI Text Classification and Matching, successfully passed the rigorous AWS Foundational Technical Review (FTR). This achievement validates our technical expertise and reinforces our commitment to delivering reliable, high-performance solutions that meet AWS’s exacting standards. What is the FTR and what it takes to pass? The AWS Foundational Technical Review is a comprehensive […]

Oleksii Svitlychnyi
ABCloudz has Attained Google Cloud Non-Profit Expertise

At ABCloudz, we are thrilled to announce that we have achieved the Google Cloud Non-Profit Expertise designation. This significant milestone underscores our commitment and proven capabilities in delivering tailored cloud solutions for non-profit organizations, helping them amplify their impact while optimizing resources. What does this expertise mean? Attaining the Google Cloud Non-Profit Expertise is a testament to our deep understanding of the unique challenges faced by non-profits and our proficiency in leveraging Google Cloud’s powerful tools to address those needs. […]

Adam Robertson
Natural Language Interface for Data Platform

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 […]

Maksym Kurhanetskyi, Oleksii Svitlychnyi
AI Text Classification and Matching for Better Decisions

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 […]

Maksym Kurhanetskyi, Oleksii Svitlychnyi
ABCloudz achieves Amazon CloudFront Delivery Partner Status

We are thrilled to announce that ABCloudz has achieved the status of Amazon CloudFront Delivery Partner as of early June. This prestigious recognition by AWS underscores our deep expertise in content delivery network (CDN) services and our commitment to providing top-notch solutions that adhere to the highest industry standards. Achieving the Amazon CloudFront Delivery Partner status involved a comprehensive validation process where AWS assessed our technical capabilities and customer success stories. This certification is a testament to our proficiency in […]

Adam Robertson
Custom AI Chatbot Development Using RAG

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 […]

Maksym Kurhanetskyi, Oleksii Svitlychnyi
Dusker Audio Integration with Sleepbar via BLE

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 […]

Oleksii Svitlychnyi
Firmware Development for a Smart Water Bottle

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 […]

Oleksii Svitlychnyi
Smart Water Bottle BLE Integration

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 […]

Oleksii Svitlychnyi
The Smart Water Bottle Solution

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 […]

Oleksii Svitlychnyi
Over-the-Air Device Firmware Upgrade via Bluetooth

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 […]

Oleksii Svitlychnyi
Medical App with BLE Blood Pressure Monitor Integration

Explore our development of a BLE-enabled application that simplifies patient monitoring by directly syncing with wireless blood pressure devices, focusing on functionality and user-friendly design. A key feature of the application is its ability to synchronize with wireless medical devices. In this blog post, we will examine the process of establishing a connection with a wireless blood pressure monitor via Bluetooth Low-Energy (BLE) technology. This feature enables users to effortlessly collect data on their blood pressure readings without manual entry. […]

Oleksii Svitlychnyi
Low-Power Design Techniques and Methodologies

Discover the art of crafting energy-efficient IoT devices in this comprehensive guide, where we delve into optimizing Bluetooth connectivity for extended battery life, innovative voltage drop mitigation techniques, precise battery life calculation methods, and strategies for enhancing button and switch energy efficiency. As the digital world evolves towards more connected yet power-conscious solutions, understanding these key aspects becomes crucial for developers. While the specific examples and calculations you will encounter in this article are based on data from one of […]

Dmitriy Liukevych, Oleksii Svitlychnyi
Case Study: Fast and secure media content delivery with Amazon CloudFront and Lambda@Edge

This case study shows how ABCloudz engineering team resolved site performance issues using Amazon CloudFront and Lambda@Edge of AWS. Challenge Our partner iCleanse offers its clients the Swift UV devices, designed to disinfect hands and mobile phones. As the device disinfects a phone within 15 seconds, it simultaneously displays sponsored video content, generating advertising revenue. Businesses of any type can benefit from installing these disinfection stations, not only by reducing costs on traditional disinfection methods and aligning with green initiatives […]

Viacheslav Kim

Ready to start the conversation?

ABCloudz emerged from the world of data and established itself as a go-to partner for any IT needs. Our professionals are ready to help. Drop us a line today!

Hi there! How can I help you?

ABCAssist