Show HN: We open sourced our entire text-to-SQL product https://ift.tt/pXqk9ae

Show HN: We open sourced our entire text-to-SQL product Long story short: We (Dataherald) just open-sourced our entire codebase, including the core engine, the clients that interact with it and the backend application layer for authentication and RBAC. You can now use the full solution to build text-to-SQL into your product. The Problem: modern LLMs write syntactically correct SQL, but they struggle with real-world relational data. This is because real world data and schema is messy, natural language can often be ambiguous and LLMs are not trained on your specific dataset. Solution: The core NL-to-SQL engine in Dataherald is an LLM based agent which uses Chain of Thought (CoT) reasoning and a number of different tools to generate high accuracy SQL from a given user prompt. The engine achieves this by: - Collecting context at configuration from the database and sources such as data dictionaries and unstructured documents which are stored in a data store or a vector DB and injected if relevant - Allowing users to upload sample NL <> SQL pairs (golden SQL) which can be used in few shot prompting or to fine-tune an NL-to-SQL LLM for that specific dataset - Executing the SQL against the DB to get a few sample rows and recover from errors - Using an evaluator to assign a confidence score to the generated SQL The repo includes four services https://ift.tt/Pc5qzdy : 1- Engine: The core service which includes the LLM agent, vector stores and DB connectors. 2- Admin Console: a NextJS front-end for configuring the engine and observability. 3- Enterprise Backend: Wraps the core engine, adding authentication, caching, and APIs for the frontend. 4- Slackbot: Integrate Dataherald directly into your Slack workflow for on-the-fly data exploration. Would love to hear from the community on building natural language interfaces to relational data. Anyone live in production without a human in the loop? Thoughts on how to improve performance without spending weeks on model training? https://ift.tt/74uajsP May 23, 2024 at 09:20PM

Show HN: Topmixlabs - Create Studio-Quality Animations with AI https://ift.tt/qlWoTXC

Show HN: Topmixlabs - Create Studio-Quality Animations with AI https://ift.tt/SCYogKT May 23, 2024 at 11:59PM

Show HN: I made a Flutter app for loneliness. 14000 min of voice messages later: https://ift.tt/YubQi5z

Show HN: I made a Flutter app for loneliness. 14000 min of voice messages later: I hope you are doing better today than yesterday. (TLDR in the comments; or enjoy my story :) ) Why: About 11 months ago, I launched my app for the first time on Reddit's r/lonely because I had previously experienced loneliness myself during grad school. I wanted to reach out to people going through similar experiences by providing them with what would’ve helped me in the past. I felt this was an important mission for me and a much more rewarding one than my day job that I quit my job to work on the app full-time. It was necessary because I did not come from a programming background. I knew how to program in the sense of running scientific simulations on MATLAB, but creating the front-end and back-end for a consumer app was totally new to me, so I had to learn from scratch. I enjoyed everyday going to a cafe to learn from programming crash courses on YouTube, developing the app little by little, and eventually launching the app! The initial response was actually pretty great: 220 upvotes for the app launch post! How: I made the app to be based on voice, and nothing else: no profiles, no profile photos, and even no texts. The reason for that was I felt a lot of people felt lonely and had trouble finding meaningful online connections because of the modern communication medium which actually promotes superficial and viral contents over authentic and long-form contents. It is easy to see from examples: TikTok’s 30 second videos, Instagram’s eye-popping photos by beautiful people from the globe, and Twitter(X)’s 140-char spicy takes. Sure, these platforms offer us information about DIYs, trends, and news that can enrich our lives and entertain us, but they don’t by all means help us feel more connected to individuals. Even on Reddit, the contents tend to be more wholesome and there are hilarious comments that build on top of each other, but the actual sense of connection you feel with the users is tenuous. Focusing on voice worked! It was incredible listening to the heartfelt messages from strangers from all over the world who opened up about their loneliness and didn’t mind being vulnerable to other strangers. I have personally spoke with everyone that came by. The 14k minutes of voice messages do not include my own voice messages; they are all messages that people left for their own posts, to each other, or as replies to me. Highlights: There were some incredible moments, which would be too long to share in this post (leave a comment if you want to hear more!), but some of the highlights were (note: these are all from public conversations): * Lady in New Brunswick, Canada was extremely depressed after a difficult divorce and felt being on the life’s edge. She was getting scammed left and right on dating apps and was losing hope. She told me that I was the only one that she felt she could trust and talk to, and she probably wouldn’t be here if I ever stopped talking to her. Thankfully, she eventually managed to find a boyfriend and she thanked me for having always been there for her. She still came back to the app to act as a supporter for other lonely souls for a while! * Gentleman in New York, USA felt isolated in a farm and felt he had no real connections with anyone. He shared with me and other users about his life growing various vegetables, but stopped coming on the app for a couple of months. When he came back, he was pleasantly surprised by the app’s development, felt I really believed in my mission to help lonely souls, and became an evangelist for my app :) He posted on several forums on Reddit and engaged in conversations with many users on the app. ... Continued in the comment https://ift.tt/vJ384zy May 22, 2024 at 11:06PM

Show HN: Keepy AI – Automate Receipt Data Entry with an Email https://ift.tt/HpDLZV8

Show HN: Keepy AI – Automate Receipt Data Entry with an Email I moved to the Bay Area to dive headfirst into the GenAI wave, eager to learn how startups build AI. I co-founded a startup with a friend and quickly realized a familiar pain: managing receipts. I'd "keep" them in my pocket, on a table, in the car – and told myself I would manage it later. Later never came. Talking to friends, I realized this was a universal struggle. That's how Keepy was born. Keepy AI automates data entry and receipt storage for individuals, freelancers and small businesses. Simply send an email with a receipt to keep@keepy.us, and our AI-powered platform handles the rest. Here's how it works: - Effortless Data Entry: No more manual inputting! Just send receipts to keep@keepy.us - Reliable Automation: 24/7 AI processing for accuracy and efficiency. - Human-Assisted Accuracy: Human agents step in if needed to ensure precise results. - Seamless Data Output: Access your data in Google Sheets, ready for analysis and integration. - Secure Cloud Storage: Peace of mind with secure cloud storage for your receipts. Try it out: send a receipt to keep@keepy.us and see how it works! I'd love to hear your feedback on Keepy. Let me know what you think! https://keepy.us/ May 22, 2024 at 01:36AM

Show HN: Hire big tech employees to appeal account suspensions https://ift.tt/uGZqmt1

Show HN: Hire big tech employees to appeal account suspensions I used to work for Facebook and Google and constantly got asked questions like "Hey, my Instagram account got blocked for no reason. Could you help me get it back?". I'd say yes, it would take me 10 min to fill out an internal form and 1 week later the account was back. Even years after leaving, I still get these requests. So I built a marketplace for them. Let me know what you think! https://plsfix.co/ May 21, 2024 at 10:42PM

Show HN: I recreated Jeffery Ventrella's "Particle Life" https://ift.tt/szXCvgQ

Show HN: I recreated Jeffery Ventrella's "Particle Life" This weekend's coding session was dedicated to recreating Jeffery Ventrella's "Particle Life". As you can imagine, I had a lot of fun with it. I recently saw this here on Hacker News and found it strange that I’d never come across it before. Source code: https://ift.tt/64Nx3Mo The color palette is by Alex Cristache. https://twitter.com/AlexCristache/status/1791122643816431930 https://ift.tt/T6nNsuS May 18, 2024 at 01:47AM

Show HN: Optigraph – optimum graph network generator https://ift.tt/iGI0ScN

Show HN: Optigraph – optimum graph network generator I've created a tool that helps plan graph networks for the best possible connections between nodes. The idea is for it to be used as a kind of underground system planner. I am still working on improving the algorithms it uses, but please consider checking it out for new ideas/bug catching. https://ift.tt/oPXcrOh May 19, 2024 at 03:00PM