nicktikhonov | 8 months ago | on: Show HN: SnapQL – Desktop app to query Postgres with AI
might be possible to solve this with prompt configuration. e.g. you'd be able to explain to the llm all the weird naming conventions and unintuitive mappings
nicktikhonov's comments
nicktikhonov | 8 months ago | on: Show HN: SnapQL – Desktop app to query Postgres with AI
and yet this was on the front page of hacker news for an entire day :D
it's all about friction. why spend minutes writing a query when you can spend 5 seconds speaking the result you want and get 90-100% of the way there.
nicktikhonov | 8 months ago | on: Show HN: SnapQL – Desktop app to query Postgres with AI
Interesting lead. What else would they be looking for in a tool like this? My bad re the video, I'll make sure not to toggle dark mode in the next one.
nicktikhonov | 8 months ago | on: Show HN: SnapQL – Desktop app to query Postgres with AI
OpenAI LLM is used to generate SQL based on a combination of a user prompt and the database schema.
nicktikhonov | 8 months ago | on: Show HN: SnapQL – Desktop app to query Postgres with AI
Merged! Thanks Stephan
nicktikhonov | 8 months ago | on: Show HN: SnapQL – Desktop app to query Postgres with AI
I'm using my own production databases at the moment. But it might be quite nice to be able to generate complex databases with dummy data in order to test the prompts at the higher levels of complexity!
And thank you for offering to contribute. I'll be very active on GitHub!
nicktikhonov | 8 months ago | on: Show HN: SnapQL – Desktop app to query Postgres with AI
Thank you for the feedback. Please feel free to raise some issues on the repo and we can jam this out there
nicktikhonov | 8 months ago | on: Show HN: SnapQL – Desktop app to query Postgres with AI
That makes no sense. OpenAI doesn't know the secret database connection string or any query results. Perhaps you should have read the code before making baseless claims.
nicktikhonov | 8 months ago | on: Show HN: SnapQL – Desktop app to query Postgres with AI
thanks Jaimin. happy you finally found what you were looking for :D
nicktikhonov | 8 months ago | on: Show HN: SnapQL – Desktop app to query Postgres with AI
Appreciate the input! I'd love to be able to support more models. That's one of the issues in the repo right now. And I'd be more than happy to welcome contributions to add this and other features
nicktikhonov | 8 months ago | on: Show HN: SnapQL – Desktop app to query Postgres with AI
The first doesn't have good UX and the second isn't open source. SnapQL is both :) But I'll find new ways to differentiate for sure, it's part of the fun of building.
nicktikhonov | 8 months ago | on: Show HN: SnapQL – Desktop app to query Postgres with AI
What I meant was that it isn't a web app and I don't store your connection strings or query results. I'll make this more clear
nicktikhonov | 8 months ago | on: Show HN: SnapQL – Desktop app to query Postgres with AI
Currently OpenAI 4o
nicktikhonov | 8 months ago | on: Show HN: SnapQL – Desktop app to query Postgres with AI
nicktikhonov | 8 months ago | on: Show HN: SnapQL – Desktop app to query Postgres with AI
Not really - I had some previous experience with electron and wanted to finish the core feature set in a few hours, so just went with what I already know.
nicktikhonov | 8 months ago | on: Show HN: SnapQL – Desktop app to query Postgres with AI
Graph generation is next on the list.
nicktikhonov | 8 months ago | on: Show HN: SnapQL – Desktop app to query Postgres with AI
You can set up an MCP and use it in your existing AI app, but is afaiu the first open source standalone app that gives you a familiar interface to other SQL workspace tools. I built it to be a familiar but much more powerful experience for both technical and nontechnical people.
nicktikhonov | 1 year ago | on: Launch HN: Haystack (YC S24) – Visualize and edit code on an infinite canvas
I would try it if it was a VSCode extension. I'd like to use it, but I live inside cursor these days.
nicktikhonov | 9 years ago | on: Building Your First Atom Plugin
While I advocate hacking Atom, I don't advocate actually using the plugin the tutorial teaches you to make as-is! A safer bet is Sourcerer (https://atom.io/packages/sourcerer) - it's got some neat features like previewing snippets and attributing credit to the SO author through added comments. I always thought of this plugin as an educational tool for learning new languages, rather than something to be used regularly when building real software. That said, So many of us use StackOverflow to find library/API examples, and this is a nice shortcut! I think that this is generally safe for finding one-line examples and shorter snippets, where it's easy to read and understand what the code does.
Before switching to Atom, I used vim and Sublime Text. The thing I enjoyed most about both of these editors was extending them with plugins. I think it's important to customise and personalise your editor because it's one of the few tools we use the most as developers, and any tweak/feature that saves us time doing a particular task means a great deal in the long term. I chose to switch to Atom because it's an editor designed around being easy to extend and customise - anyone who has done any web/Node development can dive right in. There are already nearly 5000 packages and themes available, and so far I found it much more open and easier to develop for than both Sublime and Vim.
nicktikhonov | 9 years ago | on: Building Your First Atom Plugin
Hey everyone ! I'm Nick - GitHub Campus Expert and the author of this tutorial. I'm glad that you all enjoyed hacking with Atom and can't believe that my post got to the front page! I would love to answer any questions about the content and would appreciate any feedback for this or future posts.
page 2