10 ms·
Show HN: Simple but Powerful IDE for Databases
- m19n 7y agoI 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.
- celinelee 7y agoGlad to hear you like the music! Hahaha. Thanks for taking a look at the video/tool. Always good to get feedback. :)
- stephenr 7y agoIt'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.
- celinelee 7y agoThat'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!
- stephenr 7y agoCan 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?
- celinelee 7y agoI'd be delighted to! We're using Electron, React and TypeScript. You can check out our development team's blog here for more information: - Cross-Platform Application Design with Electron, React, and gRPC (https://medium.com/p/c13a429b5346/ https://medium.com/p/c13a429b5346/) - Why Did We Choose React and TypeScript for QueryPie? (https://medium.com/p/56c9b2ab352 https://medium.com/p/56c9b2ab352)
- stephenr 7y agoYou lost me at Electron. Good luck, but I'm not your target market.
- king_magic 7y agoSame. I’ll stick with SSMS.
- slenk 7y agoWhy is there all this hate for Electron here?
- stephenr 7y agoBecause it's terrible.
- slenk 7y agoBut why is it terrible? Just because it's a bulky, but cross-platform solution?
- stephenr 7y agoIt uses ridiculous amounts of resources, introduces security issues (when you remove a bunch of the sandboxing a browser does, but then still execute content that comes from the web, bad things are gonna happen), and generally the apps don't conform to any desktop norms for any platform.
- chmod775 7y agoThis is supposed to be a full-fledged IDE. Those tend to be resource hungry anyways. Plus the interface is looking pretty straightforward and native to me - no bootstrap-ish/whatever website-looking-thing shenanigans disguised as a native application.
- 7y ago
- jvagner 7y agoScreenshots.
- newsoul2019 7y agoWindows? Does anyone use that anymore?
- pojntfx 7y agoWhoa. Proprietary IDE for _Windows_ in 2019.
- robotron 7y agoOne of the team members is on this post stating cross-platform is coming via Electron.
- _mitch 7y ago403 Error on this page: https://cms-alpha-www.sqlgate.com/pricing/subscription https://cms-alpha-www.sqlgate.com/pricing/subscription
- Padrio 7y agoOn 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 https://cms-alpha-www.sqlgate.com/pricing/subscription
- hprotagonist 7y agoFeaturelist vs. DataGrip?
- rntksi 7y agoMy 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 7y agoI guess dbeaver is much better, more powerfull and open source IDE for databases.
- deleted 7y ago[deleted]
- gt565k 7y agoI 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 7y agoI also switched, pgAdmin4 is terrible and using pgAdmin3 with new PostgreSQL versions wasn't officially supported (manual driver upgrade mostly worked).
- zepearl 7y agoI 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/ https://dbeaver.com/ at the bottom) sounds like it would stop working after 1y no matter which version I'm using :(
- CaptainHiggins 7y agoI'm not sure the "free" version of the product exists. After installing from here https://www.sqlgate.com/product/download https://www.sqlgate.com/product/download and handing over a lot of personal information, I received a time-limited trial version. Uninstalled.
- 1f97 7y agohow is this better than DataGrip?
- michaelmior 7y agoWould be nice to be able to see some high-res screenshots without having to go through watching several videos.
- Dnguyen 7y agoI'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 7y agoIs the video in Korean for everyone or just me?
- Phenix88be 7y agoIt'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 7y agoWhat is the open source alternative?
- arboghast 7y agoThere's DBeaver Community
- noir_lord 7y agoPlayed with that a bit a few days ago. It's not going to replace the DB tools in intellij (which are basically DataGrip) but for nearly all my use cases it could. It's really decent.
- HelloNurse 7y agoFor use with Oracle, I switched after many years from Oracle SQL Developer to DBeaver; the latter is rather close, except for advanced Oracle-specific features. SQL Developer caused me significant file system grief by creating recursive directory hard links in the settings folder (on Windows), so it's banned forever from my systems.
- russellbeattie 7y agoI'm pretty sure the GUI developers of DBeaver are blind sadists who want to punish all database admins for their sins. It would be considered 'cruel and unusual' in any U.S. court of law. It's not just ugly, it's a crime against humanity itself. Small animals within 10 yards of a computer inexplicably die any time the program is started. That said, it really is quite useful and usually the best tool to get db stuff done quickly. It's my go to dbadmin app.
- JimBrimble35 7y agoSQLGate sounds like what the news will call the data breach that happens when everyone who switched to this DBMS gets back door'ed
- negamax 7y agoWhy does this look so much like IntelliJ with SQL plugin :/
- rgoulter 7y agoFWIW, JetBrains has an IDE for SQL things. https://www.jetbrains.com/datagrip/?fromMenu https://www.jetbrains.com/datagrip/?fromMenu (I've no affiliation with JetBrains).
- jak92 7y agoWhat language is the demo video in ? https://www.youtube.com/embed/AqHlNy8nnJc?autoplay=1 https://www.youtube.com/embed/AqHlNy8nnJc?autoplay=1
- seanmcdirmid 7y agoThat looks like Hangul...so Korean. Interesting, I think this is the first time I’ve seen a ShowHN from Korea.
- nexact 7y agoOne-time fee okay. 40$ a month? Hell no.
- bdcravens 7y agoDataGrip 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 7y agoAlso gets cheaper on 2nd and 3rd year.
- garbonicc 7y agoFor crying out loud why is your site in english and your videos in whatever asian language that is. Gradeschool level mistakes her, wtf.
- paracyst 7y agoTried 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 7y agoThe logo is very similar to Office 365's...
- sebringj 7y agois "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 7y agoWell 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 7y agoER design, Query builder, Query Debugger, Query planner, DB Report generation are some best features to me comparing to pgAdmin.
- evrydayhustling 7y agoAny screenshots of postgres execution plan exploration? This is 99% of what I'd consider a new tool for. (Other tool suggestions also welcome.)
- mika9090 7y agoWritten in Delphi
- bdcravens 7y 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 7y agoIf you have IntelliJ IDEA Ultimate, try the Database plugin. It essentially turns IntelliJ into DataGrip (their dedicated database IDE).
- tnolet 7y agoIf on Mac, try Tableplus. Free version is already great. I use it for Postgres and Redis. Recommended
- natalyarostova 7y ago....The entire video is in Japanese.
- pushpop 7y agoThat isn’t Japanese, it looks more like Hangul than Kanji. So my guess would be Korean.
- natalyarostova 7y agoHmm, thanks for letting me know!
- gigatexal 7y agoPostgres listed twice on the main page: “Use SQLGate and raise your work productivity from Oracle to SQLServer, PostgreSQL, MySQL, MariaDB, Tibero and PostgreSQL!”
- celinelee 7y agoOh! Nice catch! Thanks for letting me know. I'll fix it right away.