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

71–80 of 101 posts

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

#71

Post by lyu07282 »

RyanHamilton wrote: post #66
lyu07282 wrote: post #46

Earlier quoted context omitted.

I don't think open source means what you think it does. https://github.com/timeseries/qstudio/tree/master

I intentionally have avoided saying "open source" as it's not yet. Please let me know where it says it, as I may have made a mistake. I just haven't seen enough demand from current or potential users to justify the effort. If you feel strongly on this, please leave a comment here to help justify the effort: https://github.com/timeseries/qstudio/issues/43

You host binary blob releases in the qstudio GitHub alongside a License file in the repo indicating apache license. If you didn't open source everything that made up those releases including it's dependencies, you should remove or clarify what exactly is covered by the license to avoid the confusion.

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

#73

Post by RyanHamilton »

iamcreasy wrote: post #72

This looks cool. What kept you motivated to continue building this when similar tools available?

Most the tools today didn't exist when I started. At each point in time I looked up and didn't see a better tool. The initial competition was focussed on DBA tasks, my colleagues and I mostly analyse large data. So we don't perform a lot of DBA tasks or manual editing of data (it's too large for that). We mostly select or create new tables that are cleaned up version using coded fixes.

There are better tools now, partly why qStudio is free as I don't believe it could compete with the paid offerings. My main profit making focus has moved onto a new niche that I think is underserved....building real-time apps based on a database. qStudio acts as a good advertisement and brand awareness for that much heavier product.

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

#74

Post by RyanHamilton »

jvalencia wrote: post #29
ramon156 wrote: post #22

Be careful on some of these claims > Supports every database Does it.

No Cassandra :-/

qStudio allows loading your own .jar file with JDBC drivers: https://www.timestored.com/pulse/help/connections-custom-jdb... In theory Cassandra has a JDBC driver: https://github.com/ing-bank/cassandra-jdbc-wrapper It's not pretty and not seamless but it should work and if it doesn't and I can fix it, I'm happy to help.

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

#75

Post by dopeboy »

I've known Ryan for those 10 years, back when we met at Morgan Stanley. He is one of the most persistent and hard working engineers I know.

To people asking why he's giving it away for free: partially because it's content marketing (duh), but mostly because this has been a labor of love for him that he wants to let loose into the world.

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

#76

Post by RyanHamilton »

lyu07282 wrote: post #71
RyanHamilton wrote: post #66

Earlier quoted context omitted.

I intentionally have avoided saying "open source" as it's not yet. Please let me know where it says it, as I may have made a mistake. I just haven't seen enough demand from current or potential users to justify the effort. If you feel strongly on this, please leave a comment here to help justify the effort: https://github.com/timeseries/qstudio/issues/43

You host binary blob releases in the qstudio GitHub alongside a License file in the repo indicating apache license. If you didn't open source everything that made up those releases including it's dependencies, you should remove or clarify what exactly is covered by the license to avoid the confusion.

I added the releases at the specific request of 1 large finance firm, a top 3 American bank by size. They requested it as their procurement department trusted downloads from github more than timestored.com. It probably sounds insane to you (or anyone sensible) especially as the downloads are digitally signed but I could write essays on the crazy hoops large firms ask you to jump through to provide software.

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

#78

Post by RyanHamilton »

fiddletwix wrote: post #77

If I wanted to use this in a corporate environment as a dev, I didn't see any links telling me pricing or who to contact. Is this user error on my part?

It's absolutely Free for all databases except one very niche database only used in finance. Please raise issues on github https://github.com/timeseries/qstudio/issues/new or email me.

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

#80

Post by whartung »

RyanHamilton wrote: post #62
hoistbypetard wrote: post #15

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

Massive thanks for this. I've opened an issue to ensure I improve this: https://github.com/timeseries/qstudio/issues/54 To be honest I've delayed improving Mac as I don't use the platform myself so I don't know how people usually install java apps on mac. I guess it's time I dove in and properly solved this. With the upcoming windows spyware I may have to move platform anyway.

This could well be a good opportunity to dig into jlink and jpackage and use that to build native installs for the different platforms, bundling the JDK.

In my experiments, I was able to pull it off for Mac and Windows, but Linux was still a bit wild west as to how to properly package it (for me), so they just get a fat jar. It's doable, I just didn't do it.

It helps if you use the Java modularity to trim down the runtime.

I was able to distribute my FX app (which requires platform specific binaries) that way.

Post reply on HN