Show HN: 10 Years to Build a Free SQL Editor

#1

Post by RyanHamilton » Mon, Jun 03, 2024, 12:56 PM UTC

I have spent large parts of the last 10+ years building an SQL Editor. The tool is targeted at data analysts, a lot of effort has gone into charting, visualizing and excel export. If this sounds useful to you, it's Free, please give it a try and let me know any feedback.

Show HN: 10 Years to Build a Free SQL Editor
timestored.com

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

#2

Post by RyanHamilton » Mon, Jun 03, 2024, 12:58 PM UTC

I should say a massive thanks to all the users over the years that provided feedback and feature suggestions. Also a big thanks to the excellent JFreeChart/Flatlaf libraries that do most the work to make qStudio look good.

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

#3

Post by Trufa » Mon, Jun 03, 2024, 1:27 PM UTC

Congrats on the launch!!

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

#4

Post by hu3 » Mon, Jun 03, 2024, 1:28 PM UTC

Grats on the launch!

Link of the repo: https://github.com/timeseries/qstudio

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

#5

Post by numlocked » Mon, Jun 03, 2024, 1:32 PM UTC

Hi - I am trying to run this on an Intel Mac. I got it to launch once, and attempted to open a small (~30mb) sqlite DB, and got a crash. It now hangs/freezes as soon as the application opens (taking over > a full core of CPU e.g. 120% plus utilization in Activity Monitor), even after deleting and re-downloading the .jar file. Any ideas? Would love to check this out!

edit: Apple silicon, which I note because the process type in activity monitor is 'Intel'

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

#6

Post by numlocked » Mon, Jun 03, 2024, 1:37 PM UTC

numlocked wrote: post #5

Hi - I am trying to run this on an Intel Mac. I got it to launch once, and attempted to open a small (~30mb) sqlite DB, and got a crash. It now hangs/freezes as soon as the application opens (taking over > a full core of CPU e.g. 120% plus utilization in Activity Monitor), even after deleting and re-downloading the .jar file. Any ideas? Would love to check this out! edit: Apple silicon, which I note because the proce…

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!

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

#7

Post by bbkane » Mon, Jun 03, 2024, 1:46 PM UTC

I'll check this out, I've been looking for a SQL editor with plotting support!

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

#8

Post by arsalanb » Mon, Jun 03, 2024, 1:56 PM UTC

Out of curiosity, what took you 10 years? Keen to hear your journey as someone building in the same space..

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

#9

Post by Svetlitski » Mon, Jun 03, 2024, 1:57 PM UTC

I 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

#10

Post by menomatter » Mon, Jun 03, 2024, 2:04 PM UTC

Congratulations on the launch! is there any write up on how it's different than other popular db management tools?