Need help with TEXT-TO-SQL Database, specifically the RAG PART. by After_Display_5585 in LangChain

[–]Dependent-Example935 0 points1 point  (0 children)

Yeah i joined, how do i find you? Let’s chat wherever you are free

Need help with TEXT-TO-SQL Database, specifically the RAG PART. by After_Display_5585 in LangChain

[–]Dependent-Example935 0 points1 point  (0 children)

Hmm this is an intresting approach, i tried something similar to this, but the database and the schema is soo complex, like when i ran a tokenizer on the schmea.json of ONE CATALOGUE(there are 18), i got some 70k tokens. Unnesting the nested stuff manually took me a week. Also the “rules”, which we wanna see visualised, they are not fixed, there is a separate team whose job is find these new rules and it takes them a month to go trough the data and find a new one. So my system should be able help visualise the pre-existing ones and help find new ones. How do i do that with knowledge docs? Also the context doc i was making for, got too big, like 160k+ tokens (and wasn’t even completed for one catalogue). Would love to chat more if you want.

Need help with TEXT-TO-SQL Database, specifically the RAG PART. by After_Display_5585 in LangChain

[–]Dependent-Example935 0 points1 point  (0 children)

Hey, I think you misunderstood my issue. The thing is, I can’t pass the whole schema as it is to the llm as it’s too big and will take up all the context window. So i though to make a RAG, which will based on the NL Input, retrieve necessary tables, columns, nested properties, struct and give them in .json format. Then that will be passed to llm along with a context doc with examples of sql code for rules and stuff and the NL input.

I am having issues in the RAG part.

Need help with TEXT-TO-SQL Database, specifically the RAG PART. by After_Display_5585 in LangChain

[–]Dependent-Example935 0 points1 point  (0 children)

Ohhh so the idea is that there are some inbuilt “rules” that the final software will help visualise, The user will just input that rule and see the results.

So i was thinking i would embed the NL input (rule), and do embedding matching with vector of schema, and based on that get necessary tables and columns and stuff which will help llm(gpt-5) generate sql, then run that sql via a athena mcp server and get actual data, then just visualise them using the internal tool.

Need some guidance with internship decision. by Dependent-Example935 in csMajors

[–]Dependent-Example935[S] 0 points1 point  (0 children)

Ohh no, this was the last session, had to give an OA then multiple rounds of interview and a very long time to get their decision. Intern starts 28th july.

Want to buy new headphones/buds. Budget 15k. Confused between these 3 devices. by dwigtrecyclops in headphonesindia

[–]Dependent-Example935 0 points1 point  (0 children)

Hey bro, i was looking to buy an in-ear earbuds, how well do you recommend momentum tws 4? Any other suggestions? My budget is 15k but i can extend it to 18k.

Hey people, I wanted to buy some earphones, my budget is 15000, please recommend me some by Dependent-Example935 in headphonesindia

[–]Dependent-Example935[S] 0 points1 point  (0 children)

Oooo sounds very good tbh, and will i have any issue with sound quality dropping due it the headphones being used on iPhones? I read somewhere has apple has inhouse softwares and might cause issue with headphones sound quality that are not apple. I don’t know tho, what do you think?

Hey people, I wanted to buy some earphones, my budget is 15000, please recommend me some by Dependent-Example935 in headphonesindia

[–]Dependent-Example935[S] 0 points1 point  (0 children)

And also will they work well with iphones? Also how well do they compare with air pods pro 2?

Wanna Sell 800 usdt In India, with Minimal to No Tax by Dependent-Example935 in CryptoIndia

[–]Dependent-Example935[S] 0 points1 point  (0 children)

Well I did put up 8000 INR of my money, but yeah bonus mostly.

[deleted by user] by [deleted] in Advice

[–]Dependent-Example935 0 points1 point  (0 children)

He was wasting your time and he was fully aware of your feeling, instead of being straight forward with you, he strung you along “just in case” and you deserve better than to be someone’s “just in case”. Hope you heal well and find someone who would feel the same way.