[flagged]
Haha, almost :P Some problems can't be solved. For everything else, there's LogicLoop.
Show HN: AI SQL Copilot LogicLoop – AI to Generate, Optimize and Debug SQL
11–20 of 65 posts
Re: Show HN: AI SQL Copilot LogicLoop – AI to Generate, Optimize and Debug SQL
#12[flagged]
Re: Show HN: AI SQL Copilot LogicLoop – AI to Generate, Optimize and Debug SQL
#13[flagged]
Agreed, that's always a risk with making data too easy to access, its context doesn't always come with it. While we initially thought it'd be most valuable for new SQL users, a lot of existing SQL experts actually find that it gives them a huge productivity boost.
Re: Show HN: AI SQL Copilot LogicLoop – AI to Generate, Optimize and Debug SQL
#14[flagged]
Thank you, let us know what you think when you try it out.
Re: Show HN: AI SQL Copilot LogicLoop – AI to Generate, Optimize and Debug SQL
#15[flagged]
Re: Show HN: AI SQL Copilot LogicLoop – AI to Generate, Optimize and Debug SQL
#16How is this any different from using ChatGPT myself?
Good question. A few different ways:
* Model Selection: We pre-select the best models for SQL generation, so you don't have to A/B test and figure it out. As the number of models available increases, this can take a lot of time if you want to do it yourself.
* Prompt Engineering: Similarly, we've had to fiddle around with a lot of different prompts to deal with common issues like hallucinations (and are constantly updating them, fixing bugs, telling the model what it can't ignore etc.) This also takes a lot of time, patience and skill.
* Directly on your data schema: You'd have to copy-paste your schema every single time you wanted to generate or modify a SQL query, which can be cumbersome. You connect your data sources once with LogicLoop, and it gets auto-included correctly for you.
Hope that helps.
Re: Show HN: AI SQL Copilot LogicLoop – AI to Generate, Optimize and Debug SQL
#17Do I understand right, everything goes to your server and all the processing happens there rather than on-premise? Too bad, that pretty much ensures no serious company will even touch it.
Re: Show HN: AI SQL Copilot LogicLoop – AI to Generate, Optimize and Debug SQL
#18[flagged]
It varies. Theoretically, someone who doesn't know SQL should be able to generate it from this, but you'd still have to get someone to connect your datasource, and have a general sense for what you want to do.
I'd say it's not optimized for the high-level executive or entry-level operations person. It's more geared for someone that is data-aware but wouldn't consider themselves confident in SQL, like a junior data analyst profile.
Re: Show HN: AI SQL Copilot LogicLoop – AI to Generate, Optimize and Debug SQL
#19Seems useful, but I'm guessing this will be (or already is) a super competitive space. How is this different than any other AI SQL generator?
Right, here's some ways we're different -
* On your data schema: A lot of the ones we've seen recently don't actually generate these queries on your schema, so you still have to do a lot of manipulation or calculation to get to SQL that just produces results.
* A better experience in productionizing SQL: Like code, writing production SQL is rarely one-shot. LogicLoop comes with a suite of AI SQL Copilot tools, like a fixer, optimizer, editor etc. that allow you to continue to iterate on your SQL logic in an integrated environment.
* Go beyond SQL: Generating query results might often be the first step of a business process. With LogicLoop, you can actually visualize results, send Slack alerts, create tickets, run automations etc. on a schedule.
Hope that helps clarify your question.
Re: Show HN: AI SQL Copilot LogicLoop – AI to Generate, Optimize and Debug SQL
#20Do I understand right, everything goes to your server and all the processing happens there rather than on-premise? Too bad, that pretty much ensures no serious company will even touch it.
I understand your skepticism, here's how we think about things -
* We only send data schema to underlying models: No data is actually sent there, but yes when you connect your database, we run the generated SQL on your database and store results to show those to you. They get regularly deleted though.
* We take security seriously: We're SOC2 Type 2 compliant and publish our security practices online, have a DPA, etc.
* Companies value convenience: We've often seen that companies _prefer_ cloud deploys so they don't have to DevOps themselves. Can be a matter of personal preference.
Hope that helps clarify.