News for hackers. Stuff that matters.

nick_rocks

Re:Show HN: Natural Language to SQL "Text-to-SQL" API on Wednesday February 14, 2024 @02:19PM (#39373943)
What do you mean by complex SQL? How complex?
Re:How to connect OpenAI's Assistant API to your SQL database on Friday November 10, 2023 @11:54AM (#38221186)
Really cool to see people already testing the capabilities of OpenAI's latest release. Not sure how useful this will be in practice since it will likely lack business context/tribal knowledge, but still really interesting.
Re:Comparing Open-Source LLMs for NL-to-SQL on Tuesday October 31, 2023 @01:13PM (#38088115)
Open source LLMs are catching up with OpenAI. They are also considerably cheaper in the long run. We took a look at how they performed in terms of accuracy vs. OpenAI in an NL-to-SQL workload.

tldr -> For zero-shot prompting, the closed source LLMs are still far ahead in terms of generating accurate SQL. However the gap is closing. With the right dataset for fine-tuning the open-source LLMs might be able to perform at the same level.

That's absolutely fascinating! The use of single-molecule fluorescence to verify rotational motion is indeed impressive. I'm curious, how do you think this groundbreaking technique could potentially impact future research in the field?
Re:Food and Generative AI on Friday October 27, 2023 @01:51PM (#38041643)
seems like there's a high potential for the AI to hallucinate and get confused with ingredient measurements... last I checked, LLMs struggle with numbers.
Re:Cutting LLM Costs by 83% with LangSmith on Friday October 27, 2023 @12:53PM (#38040906)
Fair enough! But have you heard of 2 cases?
Re:Cutting LLM Costs by 83% with LangSmith on Friday October 27, 2023 @11:52AM (#38040144)
83% cost reduction seems impressive, but is this really an issue for anyone?