Dataherald

Data

text-to-sql engine

SHOW HN2024

464points
144comments
#77of 3,515 in 2024
Top 3%of 2024 by points

How HN took it

CuriousMostly questions and neutral comments

15 positive, 52 neutral or asking, 1 mixed, 10 critical, out of 78 comments about the project. Thread score +0.06.

Idea: 9 for, 7 againstExecution: 2 for, 1 againstPrivacy: 1 for, 1 againstPerformance: 1 for, 1 againstDocs: 1 for, 0 against

The thread, comment by comment

Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.

positive neutral or mixed critical about another commenter or something else the maker

What HN said

What people liked

  • Useful for non-technical users and analysts who want first-draft SQL

    From 2 comments
    • I think a lot of people want something like this. Especially as more non technical people are adding business analysts to their jd. I’ve tried to teach SQL to PMs, bug triage…
      edmundsauto on HN
    • we've encountered a lot of instances when people know SQL but just want a first draft of SQL to expedite the process. we see this a lot from data analysts too.
      saigal on HN
  • Open sourcing is a valuable contribution

    From 2 comments
    • This is a historical contribution. Thank you for doing it! Basically all the enterprises with a lot of data need to "chat with their data" right now. I can't imagine how many…
      evan_ry on HN
    • That's one of the more feature rich AI analytics assistants. (1) Kudos for open sourcing. I think it's really difficult to build a business around that, but there are some…
      zurfer on HN

Objections

  • Accuracy and correctness are not guaranteed, risking wrong business numbers

    From 2 comments
    • With what level of accuracy? And what guarantee of correctness? Because a report that happens to get the joins wrong once every 1000 reports is going to lead to fun legal…
      TheRealPomax on HN
    • But who wants text-to-sql in products that they use? You wouldn't be able to trust the results. So what is it useful for? Of course you could learn to check the output. But then…
      nicoburns on HN
  • Latency of about 20-30 seconds

    From 1 comment
    • There are organizations using Dataherald in production right now. The latency is ~20-30s and it takes some set up, so as long as those are not blockers it can be used in prod.
      aazo11 on HN
  • Security risk when end users run generated queries

    From 2 comments
    • What guarantees do you offer with query security if I turn this over to an end user? How do I keep them only accessing their own data?
      throwaway115 on HN
    • Why do you think that's more reasonable :) To me it seems a more risky use-case since you don't have control/observability over what an untrusted user is asking for?
      tirumaraiselvan on HN

Requests

  • Support for GraphQL

    From 1 comment
  • Better handling of complex joins and outer joins

    From 1 comment
    • This looks really cool, can't wait to check it out. The problem I've seen with other tools I've tinkered with is that they do well with simple stuff like: "what are my latest…
      thedynamicduo on HN

Questions

  • How does it guarantee query security for end users

    From 1 comment
    • What guarantees do you offer with query security if I turn this over to an end user? How do I keep them only accessing their own data?
      throwaway115 on HN
  • Whether it can handle complex joins

    From 1 comment
    • Interesting! I am assuming it can do complex joins. Are there any examples of text -> sql it produces? I looked on the website but only saw "coming soon"
      instabart on HN
  • Why it was open sourced

    From 2 comments

Alternatives named

  • Vanna

    From 1 comment
    • Would you be interested in merging with Vanna in some way? You’re ahead of us in terms of interface but we’re ahead of you in terms of adoption (because of specific choices we’ve…
      zainhoda on HN
  • SQLAI

    From 1 comment
    • The demand is huge. Accuracy is less important because the alternative is being completely in the dark or wait for a developer to get the data for you. In my experience people…
      Kiro on HN
  • Defog sql-eval based tools

    From 1 comment
    • /? awesome "sql" llm site:github.com https://www.google.com/search?q=awesome+%22sql%22+llm+site%3Agithub.com : - awesome-Text2SQL:…
      westurner on HN

Category, keywords, summaries and labels on this page were made by AI (Thread Reader v2) and not checked by hand. Each point links to the comments it came from.

Add a badge to your READMEShown on HackerShow
[![Shown on HackerShow](https://hackershow.org/badge.svg)](https://hackershow.org/show/40456236)