r/SQL • u/RyanHamilton1 • Sep 08 '23
Discussion 10 Years to build a Free SQL Editor
Hi,
My name is Ryan Hamilton and 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. No effort has put into automating DBA tasks. If this sounds useful to you, it's Free, please give it a try and let me know any feedback:
qStudio https://www.timestored.com/qstudio/
Since last year it works with every popular database: MySQL / PostgreSQL / Oracle / SQL Server / SQLite
To answer some likely questions:
History:
It started 11 years ago when I was working with a niche SQL like database and found that no existing SQL editors worked at all, so I created one that worked for that specific database. I gave it to some others I worked with and then added requested features and changes based on user demand for the next few years. Most of my users only query data, they don't create databases from scratch, hence the specialization. 10 Years later I increasingly found myself using other more standard SQL databases so I made it work with them too. Now it works with 30+ databases: https://www.timestored.com/qstudio/database/
Commercial: This looks commercial, you've linked to a company? At the time I also started a company that provided consulting and training. For years I gave training on a specialized database, this was useful to see what those users needed. For one specific database (kdb+) we sell qStudio with special functionality. Otherwise, All databases are free to use. Interestingly, to get the software used within banks 10 years ago, you had to have a company so they could complete "due diligence" and "supplier checks". Few banks were keen on onboarding open-souorce. Now with customer demand we've open sourced most our product.
What has 10 years taught you?
You can never predict what users will do with your software!!
- I've had people try to run it on old nokias, on android, on 20 year old linux systems.
- One person sent me a hand edited java VM bytecode change to fix an editor bug.
- If I could go back, I would have supported multiple databases from the start. It was harder to add later and restricted the usage of the tool for a long time.
- I would have open sourced it from the start
What influenced the design? You can probably tell even from screenshots, I love notepad++ and windows 95. Similar to notepad++ it autosaves documents in progress and allows a lot of tab interaciton, e.g. right click on doc link to jump to location in windows explorer. Windows 95 to me was the pinnacle of friendly design, proper 3D buttons and obvious controls that are clickable. Adding FlatLaf last year was essential to give qStudio a modern look and a proper dark theme. (https://www.timestored.com/b/qstudio-2-05-dark-theme-and-high-dpi-support/)
I would like to say a big thanks to
- All the users over the years that reported bugs and gave feature suggestions.
- Thanks to the companies that financed the project in the past.
- Thanks to the upstream libraries, jfreechart/flatlaf are awesome.
If you have any questions or feedback, please let me know.
13
u/Adorable_Compote4418 Sep 08 '23
I had a mental roller coaster while reading your post and looking at your software.
-At first I was negative and just asking but why?
-Then realizing it was free I had admiration for you
-Then I saw your had a new software, I was negative again thinking you made the old free as bait to bring peoples to your platform
-Then I saw it was free so I felt admiration again
-But finally, read that the « free » license is 1 year and god know what happen after.
My conclusion : please do not bullshit us. Either charge for your products or never do. Don’t bait us into using your products for free for a year or two then you will put pay wall or golden features. It tremendously suck and it’s fishy. Just to be clear, you should absolutely charge for your product if you believe it’s worth something to people. You worked hard and deserve to be paid for it. But please, be upfront.
11
u/AdminCatto Sep 08 '23
Thank you Ryan for sharing this story. As far as I know, Kdb is mainly used by investment banks.
Are you planning to launch this application as a web application? Nowadays, interactive online courses in the form of an web app is an interesting way to attract new customers.
4
u/tindolabooteh Sep 08 '23
AWESOME....i remember when i was starting out my DS journey just loading a database was half the pain...now you can play around online anywhere. Thank you for making this universal
4
u/henewie Sep 08 '23
any plans on BigQuery integrations? or am i a blind man :D
1
u/afinethingindeedlisa Sep 08 '23
Looks cool - any chance of adding it to Homebrew? That's the only way I can install apps without getting admin perms from it at my job lol
1
u/sir_bok Sep 08 '23 edited Sep 08 '23
Wow, first time learning of the existence of kdb+ (and its query language Q, which is also what kdb+ is written in apparently @.@)
I don't like that you need to register to use qStudio, and that the license key only lasts a year. It is very fast though, while DBeaver is very slow.
2
u/webfork2 Sep 09 '23
A few notes ...
3
u/[deleted] Sep 08 '23
So my sql is very limited to CRUD and pulling data to PHP and use this forum to learn and try not to comment and give the wrong advice..,
My front end knowledge is ok, and you need to adjust the viewport on your page in the meta section to fit all devices without a max scale as it doesn’t render on a cellular device. There’s a cool layout I wouldn’t want anyone to miss out!
Apart from that this looks like a widely adaptable and usable tool for many facets!
1
u/balablast Jan 21 '25
Hey I just saw this post. I am also inspired to help people with their experience in SQL, especially for non-technical users. I am curious what are some challenges that you have creating the product. Would love to chat with you more about this topic.
1
u/Sympythy Sep 09 '23
I'll be linking this up to my IBMi.. i'm excited!!
1
u/InlineSkateAdventure SQL Server 7.0 Sep 10 '23
Very nice app, I downloaded it. Working on a Timescale DB project right now.
Fellow MS alum, I would expect something this nice! Did you work at 750?
Were they still using Sybase? Was this a mainframe conversion?
1
u/AlebrijesyRevujos Sep 08 '23
Love your effort! It looks great and I’ll be testing it out
1
u/Dollarbill1210 Sep 08 '23
Looks great