Written by Sergio HenriqueOctober 18, 2024October 18, 2024

Enhancing Relational Database Agents with Retrieval Augmented Generation (RAG)

In the GDSC7 challenge, I tackled the issue of reducing API costs while preserving answer quality in agent systems. The solution involved implementing semantic search to efficiently handle gender-related queries without explicit gender columns in the database. By using embeddings for all string columns and combining questions with answers, we minimized unnecessary database queries, enhancing system efficiency and reducing costs.

Written by Sergio HenriqueOctober 18, 2024October 18, 2024

How to override a method of instantiated object in python

In this post, I describe how I overcame AWS login challenges in a coding competition by using a method override trick. By defining a new function for authentication and dynamically replacing the existing method in an instantiated object, I was able to experiment with the Embedchain package without altering its class definition. This technique allowed for seamless integration with AWS services and added a valuable tool to my programming arsenal.

Written by Sergio HenriqueOctober 9, 2024October 9, 2024

Text-to-SQL Agents in Relational Databases with CrewAI

How to use crewai to create a agentic system to query a relational database.

A report about my experience developing this solution.

Written by Sergio HenriqueSeptember 30, 2024September 30, 2024

How to use Azure Communication Services to send email in a Django application

I wanted to share my recent experience with setting up email sending in my Django application, which I’m deploying on Azure Web Apps. Since I’m using django-allauth for authentication, I needed to ensure that the email confirmation and password reset workflows were properly configured. After some research, I found a solution that worked well for me.

Written by Sergio HenriqueSeptember 26, 2024September 26, 2024

Create dependent dropdown with Django and HTMX

Recently, I faced the challenge of creating dynamic, interdependent form fields in my Django application. After some trial and error, I found a solution using Django and HTMX that I’d like to share. This combination allowed for seamless, server-side updates without full page reloads, significantly enhancing the user experience and performance of my application.

Written by Sergio HenriqueSeptember 19, 2024September 19, 2024

How to use Alteryx Render tool for better spreadsheet exports

Ever been in a situation where you’ve built this awesome data transformation pipeline, only to end up with a spreadsheet that looks… well, kinda meh? That’s exactly where I found myself recently. I had this pipeline sending data tables to email, but the spreadsheets were just raw info dumps. Not exactly the professional look I was going for!

Written by Sergio HenriqueSeptember 13, 2024September 13, 2024

Setting up local database to simulate Azure production database

I have an existing SQL database in Azure, created from a scraping project using Azure Functions. My new SaaS needs to access this data. However, I prefer not to modify the existing Azure database during development.

Written by Sergio HenriqueSeptember 11, 2024September 13, 2024

How to override Django-Allauth default templates

The Problem:

I chose the package ‘django-allauth’ to help me with the login management of a SaaS code base that I am building. All my installed packages are inside of my virtual environment folder (venv) inside my project folder.

I had already created a base layout for the landing page. However, after installing the ‘django-allauth’ and configuring it, I noticed that the login page did not inherited the layout configuration from my base template.