Jignesh Sanghani · Full-Stack Engineer · Team Lead
I build SaaS and AI products, and lead the team that ships them.
Eight years at AppStoneLab, building web, SaaS and AI products for startups, agencies and growing businesses. I lead the team, own the technical architecture, and work directly with the people the product is for.
01 · What I do
What I do.
Six things the job is made of, from the screen down to the database and out to the team that ships it.
Product Engineering
The whole slice of a feature: the screen, the API behind it, the schema under that, and the migration that gets there. Most of my work looks like this: SaaS platforms, eCommerce, content and knowledge-base systems.
02 · Writing
Latest from the blog.
Practical notes, guides and lessons from building and operating real products.
·8 min readRAG Examples: Same Pipeline, Different RetrievalReal RAG examples, from web search to support bots, share one pipeline and differ only in retrieval. A hybrid Postgres setup to start from, with code.AI
·7 min readWhat Vector Embeddings Are, and Where They HelpWhat vector embeddings are, the four product problems they solve, where a plain index still wins, and why pgvector beats a vector database first.AI
·10 min readCut a 300s Product Filter Query to 30s With a Lookup TableA correlated EXISTS join across a 12M-row product/category pivot took 300s. Denormalizing the filter columns into one indexed lookup table dropped it to 30s.Performance
·9 min readThe 15-Filter Query That Broke Our MySQL SearchOur audio search hit 15+ filters across full-text, ranges, and facets, and no MySQL index could cover them. Why faceted search needs a search engine.ArchitectureSay hello.
Questions about anything here, or about the work. I read everything that arrives.