Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Show HN: 10 Years to Build a Free SQL Editor

timestored.com

Post reply on HN
Print view View original

91–100 of 101 posts

Re: Show HN: 10 Years to Build a Free SQL Editor

#91

Post by SloopJon »

RyanHamilton wrote: post #85
SloopJon wrote: post #84

Earlier quoted context omitted.

I created a Custom JDBC Server connection, but I can't figure out how to specify the driver file. Clicking the Test button offers to download one, but fails with an IndexOutOfBoundsException. I don't see anything relevant in the Settings, and I don't see anything resembling the DBeaver driver manager. I don't know how to translate that Pulse FAQ to qStudio. FWIW, I'm using Java 11 on macOS 14. I have a single qstudio…

What JDBC driver are you trying? I can try it tomorrow possibly even on mac.

Driver download:

https://intersystems-community.github.io/iris-driver-distrib...

Example connection strings:

https://docs.intersystems.com/irislatest/csp/docbook/DocBook...

Instructions for starting a container:

https://docs.intersystems.com/irislatest/csp/docbook/DocBook...

Re: Show HN: 10 Years to Build a Free SQL Editor

#92

Post by josephcooney »

whartung wrote: post #81
PaulHoule wrote: post #12

Yet 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…

I've put a whole 5 minutes of thought into this over the years, but it's something I've always thought I would like in some kind of DB tool. Notably, being able to follow relationships easily. Trivial use case, selecting a bunch of order rows, clicking on the "customer_id" of one of the rows, and it brings up the associated row, following the foreign key. Clicking on something else to open up the dependent tables (li…

DBeaver has what I think you're describing (at least for me with Postgres) - when browsing tables in the 'data' view, and also for query results there is a little icon beside a data field that is a FK, and you can click it to go to the related row. Not quite the full diagram thing you're describing but I think it can do a lot more than I am aware of.

Re: Show HN: 10 Years to Build a Free SQL Editor

#94

Post by semi »

jchw wrote: post #27
numlocked wrote: post #6

Earlier quoted context omitted.

Ah! I figured it out. User error. I had hit "open file" instead of "open database" and the application decided to open the 30mb sqlite DB as text (e.g. a sql query), including syntax highlighting. Simply letting it grind away for 10 minutes or so allowed it actually open the file, at which point I could close the tab and performance is back to normal. Look forward to experimenting!

Hey, that's some amazing QA work. If I were the developer, I'd add a quick check to see if the file appears to be a SQLite database and do something useful in that case.

Probably good to have some basic checks too if it's expecting a text file of SQL queries- like a dismissible warning if it's over a certain size or doesn't appear to be plain text

Re: Show HN: 10 Years to Build a Free SQL Editor

#95

Post by semi »

ktm5j wrote: post #90
hnlmorg wrote: post #69

Earlier quoted context omitted.

No reason why you couldn’t call the ssh binary if it’s available in $PATH. I’ve seen other tools do this too. You’d need to be transparent in your GUI wording that this is forking SSH (in the case of Windows users) but it wouldn’t be an issue for Linux or macOS.

I don't think the guy who you replied to expects anyone to implement their own SSH client to build a tunneling feature. The sensible thing you would do is use a well known library for that.. but that's not any less work than having your program use the SSH binaries to make those features. Honestly it would almost certainly be easier to use a library.

Even easier to just have a doc give some examples of third party tunneling solutions and not have the app try to do anything more than normal connections.

ssh tunneling alone can be done in so many ways with different environments necessitating which might work. are we talking ssh tun/tap IP tunnels? simple port forwarding? either of the above but with a proxyjump required to get there?

Re: Show HN: 10 Years to Build a Free SQL Editor

#96

Post by password4321 »

In response to the default Darcula theme on Windows, specifically the gray for the comments vs. the gray background: https://contrastrebellion.com/

In SQL Management Studio it is easy to work with stored procedures. The server starts the tree on the left, and all databases on the server are the next level down (not a separate connection for each database). Then beneath that (2 levels) each stored procedure is listed and can be opened easily for modification in the editor.

I will return to this app if I need to munge/import data in the future but it's not worth the effort for my normal work with stored procedures as best I can tell from a quick start. It's not immediately clear how to pull a stored procedure up in the editor without running a query manually to grab its definition.

Re: Show HN: 10 Years to Build a Free SQL Editor

#97

Post by page_fault »

PaulHoule wrote: post #12

Yet 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…

All IDEs from JetBrains support interactive database diagrams.

https://www.jetbrains.com/help/idea/creating-diagrams.html#d...

Re: Show HN: 10 Years to Build a Free SQL Editor

#98

Post by RyanHamilton »

darrylb42 wrote: post #40

Looks cool. What is the benefit of registering? I skipped it to try it out. Was very quick looking at my local MySql database. I liked being able to run sql against some local parquet files. Would need to support Redshift via an ssh tunnel for me to use it on a regular basis. I don't want to manage the tunnel with a different tool.

Redshift support added: https://www.timestored.com/qstudio/database/redshift I need to think more about ssh tunnel.

Re: Show HN: 10 Years to Build a Free SQL Editor

#99

Post by MissTake »

Impressive but I did find a few issues using my Intel Mac:

1) Being a Jar there’s no easy way to add it to the Applications folder and launch it “naturally”.

2) The colors I selected for each connection didn’t seem to stick.

3) I can’t find a way to have a connection go against multiple Sql Server databases.

4) Cloning a connection keeps the highlight in the source server in the Server Tree.

5) The Console isn’t easy to view table results on due to it using simple pipe (|) separation.

Re: Show HN: 10 Years to Build a Free SQL Editor

#100

Post by hn1986 »

RyanHamilton wrote: post #68
hn1986 wrote: post #17

Is it possible to quickly see trends (line graph) for a query result.. If I want to see count of orders over time to see if there are any outliers for potential data issues. That'd be neat. or esp if AI can just check the data... if i have average of 100 orders per day but there is one day that has just 5, I'd want to see that easily.

Yes. All charts render directly from queries. It sounds like you want either time-series or step-plot.

i'll give it a shot, thanks!
Post reply on HN