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.
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.
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.
netsh int ip show excludedportrange protocol=tcp
This issue was already created on github, 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
After many years Sequel Pro (MySQL only) started having problems so I tried every tool in this class for macOS and ended up standardizing on TablePlus.
It supports most common DBMSs, works on Mac and Windows, and apparently has a Linux alpha.
I still prefer Sequel Pro’s UI but TablePlus is ok. No critical bugs although import of massive or complex MySQL dumps still works more reliably on the official CLI client.
I also use Postico for Postgres https://eggerapps.at/postico/ the UI there is nice as well. It’s the closest I could find to Sequel Pro.
# Mysql Only:
- Sequel Pro (Free, Pretty, Mac only. Has issues with MySQL v8)
- Workbench - https://www.mysql.com/products/workbench (Free, Pretty)
- DBForge - https://www.devart.com/dbforge/mysql/studio/editions.html (Freemium)
- Querious - https://www.araelium.com/querious ($50 one time, Mac only)
- Sequel Ace - https://github.com/Sequel-Ace/Sequel-Ace (Free)
# Postgres Only:
- Postico ($40, Pretty, Mac only)
- PgAdmin - https://www.pgadmin.org (Free, Clunky)
# SQL Server:
- Azure Data Studio - https://docs.microsoft.com/en-us/sql/azure-data-studio (Free, Pretty)
# Multi DB:
- DataGrip ($89 first year, $71 second year, $53/year after that, Clunky, Powerful)
- TablePlus ($50, Pretty, Useful)
- DBeaver (Free version, Clunky, Powerful)
- Heidi (Free, Clunky, Usable)
- SQuirrel (Free, Clunky, Usable)
- http://sequeljoe.ohwg.net (Free, beta)
- Valentina Studio - https://www.valentina-db.com/en/valentina-studio-overview (Freemium, Pretty)
- Aqua Studio - https://www.aquafold.com ($500, Clunky)
- Navicat Premium ($599, Pretty, has good reputation)
- POPSql - https://popsql.com (free for 2 saved DB connections,12/Mo., Pretty)
- Beekeeper Studio (Free, Electron)
- DBGate (Free, Electron)
- VSCode Extensions (Free, Electron)
EDITED based on other comments
If I was getting new, I would definitely check out popsql, tableplus, and datagrip first.
If I was looking for something new right now, I'd try DataGrip first. I'm a huge fan of Jetbrains' products so I'd be happy to pay them for another useful tool.
Just my 2c. I'm sure others have different experiences/likes/dislikes
I am in no way affiliated with the product or it's creators, but have seen many SQL clients and can recommend it.
TablePlus got good enough with its interface, though there are still some parts still feeling unintuitive like ordering of columns through numbering instead of drag/drop style but it's the best of workable solutions. (DataGrip is too heavy)
I've not perceived any Performance improvements beyond the first page opening, which is probably because that's SSR and then shipped to the client pre-processed.
pages usually render within 100ms in both svelte and angular (including the rest call for the data) and there is no stuttering or anything in either unless I implement a leaky feature... Svelte is sometimes even slower, because it needs to fetch the component itself, which is usually prefetched in angular. (Bigger initial payload because of that but that is manageable as well using modules in angular)
And svelte is so much less mature in tooling/hooks etc that I'd expect it to be significantly more tiresome to use in bigger projects.
Its definitely a very interesting framework however. Having the option to choose which component to SSR and which to process fully on the client is incredible.
I really like the UI. And it's impressive what you've achieved.
The main thing that stops me switching right now is DataGrip has a great table/indexes editor that outputs normalised SQL which I use for creating migrations. Otherwise I seriously would have considered it.
I'd really prefer to switch away from sqlitebrowser (AKA "DB Browser for SQLite.exe"). It's a fine tool, but a bit limited.
What you mean exactly with lack of MS telemetry?
I believe the poster is just joking that ADS comes with MS telemetry and yours is free of that :P
Apart from that, well done, I have been looking for a good db client for linux for ages. I use DBeaver at the moment, and it's pretty good, but I do find the interface a bit clunky and yours looks much better.
I am using HeidiSQL and was ok with it, but will try this for my next project.
Question: are you planning to support it for long time, and if so, how are you planning to keep developing it without any income from it?
Now I have reserved 1 man-day per week for my non-profit or very-low-profit projects, dbgate takes 90% of this time. (+of course some evenings and weekends). I am planning to use github sponsors or something like this in future, maybe it would allow me to extend this reserved time.
I will start using this as my daily driver for my personal projects.
Oracle driver licensing is a pain. The way Metabase does it is to have the users download the Oracle jar and add the Oracle driver to a location it can read from.
I am still amazed by how pervasive Oracle usage is for NEW projects in the enterprise. The only large enterprise I know that left Oracle is Amazon when they switched to Postgres and now they offer Redshift as a service to get off Oracle.
Azure cloud should be not problem, what version of MariaDB are you using?
Also there's MySQLWorkbench, but that's specific to MySQL/MariaDB.
Have a look at GraalVM.
I am also looking forward to SQLite
Could you please include filters within the database. (Databas filters)