3 ms·

Hi all, this is my passion project. I was unable to find nice SQL client for Linux, so I created it on myself. I have created proprietary SQL client for Window

Hi all, this is my passion project. I was unable to find nice SQL client for Linux, so I created it on myself. I have created proprietary SQL client for Windows in past, so this app is influenced by experiences from this work. Recently I have added support also for noSQL, MongoDB. It's built on Electron using Svelte. Although Electron apps tends to be clumsy, partly thanks to Svelte framework is the app fast enough. It's open source (MIT), cross-platform (Linux, Mac, Windows), or can be run as web-based application in browser. Hope it could be useful also for others.

garyclarke27 5y ago
Well done, impressive features, I like the data edit capability, appears to be way better than other clients. I’ll give it a try - gotta be better than PgAdmin!
hardwaresofton 5y ago
Projects like yours are why browsing HN is still a joy -- this is diamond-in-the-rough software, and I never know when I'll come across it (also thanks to HNs stellar moderation and the mods that make that happen). The stack this is built on is pragmatic yet being reasonably cutting edge (at least I think of Electron and Svelte as cutting edge, not "boring" software), the feature set is deep, good support, easy to download and install, and I like the vision (as in the UI has been built by someone who has seen other entries in the space before and is familiar yet not cluttered). Love the project. Please make sure to think of a sustainable way to capture some of the value you're investing into this project, I don't see why it can't take a place as a widely used (No)SQL DB client. Even if it's just a buy-me-a-coffee button (or a paypal 1-time donation button, whatever has least fees), It helps to think ahead to what sustainability looks like before you have 200+ issues filed so you can keep the passion as people like me drive by, use your project and maybe complain but don't contribute.
- janproch 5y ago
  Thanks. My plan is at first to have reasonable big set of active users, who will report problems, ideally also some contributors from community. Buy-me-cofee or donate buttons is next step
jaywalk 5y ago
This looks very impressive! However, I can't get it to work. Just installed it on Windows 10. When I launch it I get a taskbar icon but no actual window. There are also four dbgate.exe processes running, and when I right click on the taskbar icon and close it, three of them remain until I figure out the correct one to End Task on. If there's any further info you'd like from me, I'd be happy to help out. It seems like your app could make my life easier, so I'd really like to get it running. Note: I'm seeing the same thing on two entirely separate Windows 10 machines, so you might have a larger issue on your hands here.
- janproch 5y ago
  Thanks for feedback. It looks like electron problem. This issue was already created on github, https://github.com/dbgate/dbgate/issues/86 https://github.com/dbgate/dbgate/issues/86 . Output from console could be helpful. Next step would be testing dbgate upgrade, probably upgrade of electron would be neccessary
  - jaywalk 5y ago
    My console output is identical to what's already been posted there, so I'll just keep an eye on that issue.
- chocolatkey 5y ago
  I reported this in the GitHub issue as well, but the issue became immediately apparent because I've had this same issue running local servers - HyperV reserves (what I consider) large amounts of ports to do its business. You can run netsh int ip show excludedportrange protocol=tcp to see which ones, and in my case the port DbGate was having issues reserving was in one of the ranges
  - janproch 5y ago
    Thanks, that's obviously the problem

garyclarke27 5y ago

Well done, impressive features, I like the data edit capability, appears to be way better than other clients. I’ll give it a try - gotta be better than PgAdmin!

hardwaresofton 5y ago

Projects like yours are why browsing HN is still a joy -- this is diamond-in-the-rough software, and I never know when I'll come across it (also thanks to HNs stellar moderation and the mods that make that happen). The stack this is built on is pragmatic yet being reasonably cutting edge (at least I think of Electron and Svelte as cutting edge, not "boring" software), the feature set is deep, good support, easy to download and install, and I like the vision (as in the UI has been built by someone who has seen other entries in the space before and is familiar yet not cluttered). Love the project. Please make sure to think of a sustainable way to capture some of the value you're investing into this project, I don't see why it can't take a place as a widely used (No)SQL DB client. Even if it's just a buy-me-a-coffee button (or a paypal 1-time donation button, whatever has least fees), It helps to think ahead to what sustainability looks like before you have 200+ issues filed so you can keep the passion as people like me drive by, use your project and maybe complain but don't contribute.

janproch 5y ago
Thanks. My plan is at first to have reasonable big set of active users, who will report problems, ideally also some contributors from community. Buy-me-cofee or donate buttons is next step

jaywalk 5y ago

This looks very impressive! However, I can't get it to work. Just installed it on Windows 10. When I launch it I get a taskbar icon but no actual window. There are also four dbgate.exe processes running, and when I right click on the taskbar icon and close it, three of them remain until I figure out the correct one to End Task on. If there's any further info you'd like from me, I'd be happy to help out. It seems like your app could make my life easier, so I'd really like to get it running. Note: I'm seeing the same thing on two entirely separate Windows 10 machines, so you might have a larger issue on your hands here.

janproch 5y ago
Thanks for feedback. It looks like electron problem. This issue was already created on github, https://github.com/dbgate/dbgate/issues/86 https://github.com/dbgate/dbgate/issues/86 . Output from console could be helpful. Next step would be testing dbgate upgrade, probably upgrade of electron would be neccessary
- jaywalk 5y ago
  My console output is identical to what's already been posted there, so I'll just keep an eye on that issue.
chocolatkey 5y ago
I reported this in the GitHub issue as well, but the issue became immediately apparent because I've had this same issue running local servers - HyperV reserves (what I consider) large amounts of ports to do its business. You can run netsh int ip show excludedportrange protocol=tcp to see which ones, and in my case the port DbGate was having issues reserving was in one of the ranges
- janproch 5y ago
  Thanks, that's obviously the problem