Recent Articles on the tecRacer AWS Blog

SQL Server 2019 Failover Cluster on EC2 – Lessons Learned

Customer requirements demanded the setup of a SQL Failover Cluster on EC2. Following AWS’s reference setup, I encountered some issues that cost me a couple of hours. In this blog post, I’ll share my experience and the solutions I found, hopefully saving you valuable time and making your journey to set up a SQL 2019 Failover Cluster with Windows Server 2019 on EC2 smoother and more enjoyable.

Integrating HubSpot with AWS Lambda

Like many organizations, tecRacer uses HubSpot as a CRM. Integrating Hubspot with other (internal) systems enables smooth workflows for everyone involved. Since I recently built a custom integration, I thought it may be helpful to explain how to set up a secure interface with AWS.

Embedded Embeddings Database: Building a low cost serverless RAG solution

Retrieval-Augmented Generation (RAG) solutions are an impressive way to talk to one’s data. One of the challenges of RAG solutions is the associated cost, often driven by the vector database. In a previous blog article I presented how to tackle this issue by using Athena with Locality Sensitive Hashing (LSH) as a knowledge database. One the of the main limitations with Athena is the latency and the low number of concurrent queries. In this new blog article, I present a new low-cost serverless solution that makes use of an embedded vector database, SQLite, to achieve a low cost while maintaining high concurrency.