Show HN: Simple but Powerful IDE for Databases

https://www.sqlgate.com/

by celinelee • 7 years ago

89 96 7 years ago

gigatexal• 7 years ago

Postgres listed twice on the main page:

“Use SQLGate and raise your work productivity from Oracle to SQLServer, PostgreSQL, MySQL, MariaDB, Tibero and PostgreSQL!”

celinelee4• 7 years ago

Oh! Nice catch! Thanks for letting me know. I'll fix it right away.

m19n• 7 years ago

I love the music for the demo video. Especially the second part. Oracle never sounded better.

Joke aside. Looks like a pretty useful tool. Seems to be focused on workflows.

celinelee4• 7 years ago

Glad to hear you like the music! Hahaha. Thanks for taking a look at the video/tool. Always good to get feedback. :)

stephenr7• 7 years ago

It's 2019 and not a single mention of which OS this runs on. I had to download it to find out it's for Windows.

Might want to make a note of that somewhere.

celinelee4• 7 years ago

That's a very good point. Thank you for the comment! I'll mention it to my team and have that issue fixed. :) We are also currently beta testing a cross-platform IDE, so please stay tuned!

stephenr7• 7 years ago

Can you give some info about the cross platform version - specifically the UI toolkit it uses? i.e. it is Java, QT, Electron, platform-specific UI with a C/C++ core, etc?

jvagner• 7 years ago

Screenshots.

pojntfx• 7 years ago

Whoa. Proprietary IDE for _Windows_ in 2019.

robotron• 7 years ago

One of the team members is on this post stating cross-platform is coming via Electron.

_mitch• 7 years ago

403 Error on this page: https://cms-alpha-www.sqlgate.com/pricing/subscription

Padrio• 7 years ago

On the Frontpage, "Start your Subscription" inside the Description for the Free Version there is the Link [0] which leads to a broken "403 forbidden" page.

[0] https://cms-alpha-www.sqlgate.com/pricing/subscription

hprotagonist• 7 years ago

Featurelist vs. DataGrip?

rntksi• 7 years ago

My main annoyance, so to say, with DataGrip is their certificate handling. It ignores the root certs in MacOS keychain and I have to add those in the app.

But other than that I love it. It's replaced all other SQL tools/ide/admin I've used.

markuman• 7 years ago

I guess dbeaver is much better, more powerfull and open source IDE for databases.

gt565k• 7 years ago

I use dbeaver and it's great. I've got sql server, postgres dbs, and even an old TakeStock / Progress DB working nicely with it.

aiCeivi9• 7 years ago

I also switched, pgAdmin4 is terrible and using pgAdmin3 with new PostgreSQL versions wasn't officially supported (manual driver upgrade mostly worked).

zepearl• 7 years ago

I just needed a DB-client with which 1) I could have multiple SQLs in a single page/file (hope you know what I mean) and 2) execute single ones based on where the cursor is positioned, 3) without a delimiter at the end of each SQL, and 4) see as well execution plans (for some DBs e.g. MariaDB) and 5) to work with multiple databases (MariaDB, PostgreSQL, Clickhouse, DB2, MonetDB, Oracle, generic JDBC) and DBeaver totally saved me and I don't see any alternative (which I now anyway don't need).

I would pay for the "enterprise edition", but for a fixed amount not limited by usage but based on SW-versions (e.g. get upgrades for 1 year and after that to be able to keep using "the old version XYZ" until I have a reason to upgrade for which I would have to pay again). The 149$/year ( https://dbeaver.com/ at the bottom) sounds like it would stop working after 1y no matter which version I'm using :(

CaptainHiggins2• 7 years ago

I'm not sure the "free" version of the product exists. After installing from here https://www.sqlgate.com/product/download and handing over a lot of personal information, I received a time-limited trial version. Uninstalled.

1f97• 7 years ago

how is this better than DataGrip?

michaelmior• 7 years ago

Would be nice to be able to see some high-res screenshots without having to go through watching several videos.

Dnguyen• 7 years ago

I've been using Toad for a long time and looking for something better, less buggy, more performant. Watching the video this looks very promising. Looking at the limitation of the Free version, it's too limiting to really give it a try. For example, only one connection at a time, limit to two tabs, no data import and export, clipboard size limit. I need to see how it handles my everyday usage before I can determine if I want to switch.

m3nu• 7 years ago

Is the video in Korean for everyone or just me?

Phenix88be• 7 years ago

It's hard to find information on this marketing website. Here is a summary gathered from the comments :

- It's for windows

- It's not open source

- They plan to build a cross-platform IDE using Electron

I think we have solid alternative in the open source world and I don't really see how this product is better (This is based on the information provided by the website).

AquaLineSpirit• 7 years ago

What is the open source alternative?

arboghast• 7 years ago

There's DBeaver Community

swest• 7 years ago

Azure Data Studio maybe? https://github.com/Microsoft/azuredatastudio

btreecat• 7 years ago

SquirrleSQL

JimBrimble35• 7 years ago

SQLGate sounds like what the news will call the data breach that happens when everyone who switched to this DBMS gets back door'ed

negamax2• 7 years ago

Why does this look so much like IntelliJ with SQL plugin :/

rgoulter• 7 years ago

FWIW, JetBrains has an IDE for SQL things. https://www.jetbrains.com/datagrip/?fromMenu

(I've no affiliation with JetBrains).

negamax2• 7 years ago

Doesn't this look exactly same to you?

bdcravens3• 7 years ago

Been using Data Grip as my regular database client for a couple of years, very happy.

jak92• 7 years ago

What language is the demo video in ?

https://www.youtube.com/embed/AqHlNy8nnJc?autoplay=1

seanmcdirmid• 7 years ago

That looks like Hangul...so Korean.

Interesting, I think this is the first time I’ve seen a ShowHN from Korea.

nexact• 7 years ago

One-time fee okay. 40$ a month? Hell no.

bdcravens3• 7 years ago

DataGrip is $20 a month for more features. However, after you've paid for 12 months you get perpetual access, so you can essentially pay for 12 months (or yearly at $199) and it essentially becomes a one-time license to that version if you'd rather not keep paying.

(I've been a DataGrip customer for a couple of years now)

h1d• 7 years ago

Also gets cheaper on 2nd and 3rd year.

garbonicc• 7 years ago

For crying out loud why is your site in english and your videos in whatever asian language that is. Gradeschool level mistakes her, wtf.

paracyst• 7 years ago

Tried this for a few minutes at work (very heavy SQL Server shop). It doesn't play well with databases that have different schemas but the same table name.

schema1.users

schema2.users

schema3.users

schema4.users

The auto-complete seems to always choose the last one and it displays it as 'users' with no indication of the schema. This alone makes this unusable for me at the present time

Brozilean• 7 years ago

The logo is very similar to Office 365's...

sebringj• 7 years ago

is "Show HN:" a paid way for companies to advertise on hacker news? If not, awesome, otherwise, I feel a bit naive in thinking HN was a more pure approach to content and would be very disappointed.

uniclaude• 7 years ago

Well the guidelines say that "Show HN is a way to share something that you've made on Hacker News." but it looks like the community is satisfied to have marketers promoting (which is what OP does) instead of builders discussing with other hackers.

I share your disappointment and would like to know how the admins see this.

revskill• 7 years ago

ER design, Query builder, Query Debugger, Query planner, DB Report generation are some best features to me comparing to pgAdmin.

evrydayhustling• 7 years ago

Any screenshots of postgres execution plan exploration? This is 99% of what I'd consider a new tool for. (Other tool suggestions also welcome.)

mika9090• 7 years ago

Written in Delphi

bdcravens3• 7 years ago

$15-25 a month? (or $40 a month for all?) (The free version doesn't support basic things like import and export, so it's really not viable for professionals)

DataGrip is $20/month, for all databases, and includes additional ones this product doesn't support. Nor does it have limits like the number of tabs you can have open. And it's cross platform today.

lunchladydoris• 7 years ago

If you have IntelliJ IDEA Ultimate, try the Database plugin. It essentially turns IntelliJ into DataGrip (their dedicated database IDE).

apeace• 7 years ago

I use Datagrip every day and SQLGate looks very similar.

cr0sh• 7 years ago

Now if only they'd do this with clion.

/yeah, I know that it went the opposite way; it just bugs me that I can't have great C/C++ support in IntelliJ like you used to get with the plugin that no longer works...

tnolet• 7 years ago

If on Mac, try Tableplus. Free version is already great. I use it for Postgres and Redis. Recommended

natalyarostova2• 7 years ago

....The entire video is in Japanese.

pushpop• 7 years ago

That isn’t Japanese, it looks more like Hangul than Kanji. So my guess would be Korean.

natalyarostova2• 7 years ago

Hmm, thanks for letting me know!

Show HN: Simple but Powerful IDE for Databases

Related Stories