Misc

Just a dump of stuff I explored a long time ago.

Very quick text-to-SQL:

While I worked at Crux (2024), we initially worked on text-to-sql. Our product had a latency of 30s-2min depending on the question. I noticed that a particular customer had a limited set of query types. Created a few postgres functions that spanned their entire query space. When the user asked a question in natural language, a tiny Llama model would extract parameters (parameters being SQL operators) for the functions based on examples in the system prompt. The functions were overloaded such that the list of parameters outputted by the llama model was enough to call it. This entire pipeline required ~2s to run. Made this entirely myself. I wish we hadn’t pivoted a few weeks later. This was a good idea to explore

(One full app + Quick MVPs to test user demands)

PatternLogs - I used this app to track my muscle twitches. They occur in bursts and I match the pattern and intensity of the twitches by tapping on the screen. Helped me find triggers
Did your doctor Mess up? - Record the audio of your doctor visit to check if they made a mistake. This got decent usage when I demoed to friends. In hindsight, this was a very good entry point to build a healthcare AI startup, and I should have continued. I had also tried an alternate version: an audio EHR software for doctors. This seemed to have much lower demand.
AIIMS Delhi - “Which resident is currently on call?” - There is no system in place to know which resident is on call for consults leading to massive delays and medical issues (and even deaths) every hour, every day. Exploring problems in govt. hospitals was vv depressing. Bureaucracy fucking sucks. V few people genuinely care about their work.
proto-research-paper-finder: Finding relevant research papers for your disease (this was pre-deepresearch, helped me sometimes come up with new things to read about for my own health)
Mood tracker, Pain Tracker - For a friends who wanted to track their pain / mental health levels. Both products didn’t end up getting used. This made me realise users don’t know what they want, and in general have very low agency. No link for obvious reasons

Quantum Mechanics TAship: Was a TA for the QM course for 2 years (2022-23). Was in charge of 1500 freshman and all 40 TAs. Also created the solution booklet for all the tutorial questions in the course. I think its still used today.
Shop Monitors on arduino: Did some technically challenging stuff like messing around with the EEPROM and interrupts itself. Had to dig around documentation of the registers to get this done (this was pre-LLMs). Final implementation is much simpler.
ROOT Installation Guide for Windows (WSL): A guide to install WSL w graphics support and CERN ROOT for the data analysis course. Made this coz most of my classmates were afraid of the terminal