Hi there 👋

Welcome to my blog. I am Dvip Patel. I post random things that comes to my mind. If you like what you see, follow along!

From Prompt to Dashboard: Building a Secure Text-to-SQL Analytics Bot

Let me define the problem statement first: Users/managers constantly ask for slightly customized metrics or weird date ranges that standard dashboards don’t cover. Hardcoding a new UI chart for every edge-case query is unscalable. Sounds simple enough problem, right ? We could just make some chatbot API. Well it is simple if you ignore the security risk that it could be, plus how could a chatbot possibly provide visualizations? I was asking these questions to myself as well. So let’s start from the very beginning and walk our way through it. ...

May 15, 2026 · 3 min · Dvip Patel

Real-Time Monitoring AI Architecture

In this article, I’ll explain the architecture of the Real-Time Object Detection monitoring system I designed, what decisions I made, why I made them, and how I did the testing, which is also very interesting. Below is my stack and how the components interact with each other. Let’s start from the beginning. First Phase First there was Light. I mean the Security Camera. It uses a protocol called ‘RTSP’, which MediaMTX uses to take in the feed and transport it to our service 1. ...

May 11, 2026 · 4 min · Dvip Patel

Getting Started with Git

Initial Process 1. GitHub Account Make sure you already have a GitHub company account. If you don’t ask your supervisor to provide it to you. 2. Install Dependencies Check if you have git installed from this command in PowerShell. git —version If it’s not installed, then install it as such winget install --id Git.Git -e --source winget To check if it’s installed, run the command git --version once again in a new PowerShell window or tab. ...

February 1, 2026 · 3 min · Dvip Patel