I have a genuine question, intended in good faith: why? Why spend 10 years working on this, only to give it way for free?
Show HN: 10 Years to Build a Free SQL Editor
11–20 of 101 posts
Re: Show HN: 10 Years to Build a Free SQL Editor
#12Practically I am often understanding how to write certain queries by starting out with a certain table or a certain row and then looking at the resulting subgraphs of tables or rows that are linked to it. I want to be able to bookmark a row and come back to it immediately.
Also tools like this also implement "save" in a way that is useless at best and sadistic at worst. Who really saves a bunch of SQL files in a directory like "Query001.sql"? If I want to "save" queries and updates I don't want to save them in a strange SQL-specific project. Depending on my project these are either going to be incorporated inside source code files or possibly saved in files that live inside a project I manage with a non-SQL IDE. If I want to "save" DDL these are either saved in the database themselves by executed or could be managed as part of a migration system, which I haven't seen a tool of this sort support. Although I never "save" files in that kind of tool, it is certain to try to stop me from turning my computer off so it is another thing that makes turning my computer off like
Re: Show HN: 10 Years to Build a Free SQL Editor
#13Yet to find one of these (Microsoft SQL's query editor, Oracle's query editor, DBeaver, pgadmin 4) that I really like. The basic problem I have is that the structure of the typical relational db which uses primary and foreign keys (even if they aren't declared) is a graph. A user interface that lets me pick out individual tables and columns for one little query tab which gets lost in a sea of tabs just doesn’t cut it…
Re: Show HN: 10 Years to Build a Free SQL Editor
#14I have a genuine question, intended in good faith: why? Why spend 10 years working on this, only to give it way for free?
Re: Show HN: 10 Years to Build a Free SQL Editor
#15I haven't gotten very far into it, but here's a little feedback about what it took to get to the point where I could try it out.
1. I'm running MacOS 14.4.1.
2. I downloaded the jar file.
3. I double-clicked the jar file. It wouldn't open. I've seen this before, so I navigated to the jar file, right-clicked it and chose open, and it gave me the option to launch it even though it was unsigned after a warning.
4. Then it told me I needed a java runtime, and I should go to java.com to get one.
5. I went to java.com to get one, downloaded the java 8 runtime things defaulted to, and when I went to install it, I got a scary warning that Oracle might sue me if I used this for commercial use. This is my personal machine, but I didn't know what might count as commercial use, so I noped out and decided to look for an open source runtime.
6. I figured out that `brew install java` seemed like what I want and ran that.
7. Once that completed, I double-clicked the jar again. No luck.
8. Since the SQL editor site advised running from the command line if double-clicking didn't work, I tried that. An error message directed me to java.com.
9. I didn't want to go back there, so I did more web searches. I learned that if I ran `sudo ln -sfn /opt/homebrew/opt/openjdk/libexec/openjdk.jdk /Library/Java/JavaVirtualMachines/openjdk.jdk` things might work. So I tried that and went back to right-click the jar and run it. I again accepted the warning. It launched!
10. It asked me for an email address. I just wanted to try out the software, not sign up for email. I declined to enter one.
11. It asked me for a license code. I declined to enter one.
12. Then it told me I was in a 30 day trial mode once the GUI came up.
I'm still interested, but that's the end of my timebox today. I hope I remember to come back and try it some more.
But what's the deal? Is it a 30 day trial for a paid product? Or is it really free? Or do you need email to make it really free?
You might want to look at how JetBrains bundles the JRE with datagrip on Mac. The level of effort needed to try this was maybe higher than I'd consider ideal.
Re: Show HN: 10 Years to Build a Free SQL Editor
#16Re: Show HN: 10 Years to Build a Free SQL Editor
#17Re: Show HN: 10 Years to Build a Free SQL Editor
#18Congrats on launching! I haven't gotten very far into it, but here's a little feedback about what it took to get to the point where I could try it out. 1. I'm running MacOS 14.4.1. 2. I downloaded the jar file. 3. I double-clicked the jar file. It wouldn't open. I've seen this before, so I navigated to the jar file, right-clicked it and chose open, and it gave me the option to launch it even though it was unsigned af…
Re: Show HN: 10 Years to Build a Free SQL Editor
#19Apache 2 license that requires email registration. I don't think such a thing exists.