DBeaver – open-source database client
github.com
github.com
It's a great tool, though, a bit buggy but most useful.
They have a sample on their website (go to the relationships section):
https://schemaspy.org/samples/epivirusurf/
The convenience factor is that you don't need a continuous connection to the db to refer to the diagrams or other docs.
Apart from that, you can install it inside regular Eclipse as a plugin, so then you can have your database window and your ER diagram next to your code. Again, something that really sets it apart from dedicated tools.
So you go to Help => Install New Software and then put eg: the Vrapper update site in:
http://vrapper.sourceforge.net/update-site/stable
And this is irrespective of whether that 95% is right or not.
Google "father son and donkey story".
And re: that 95%:
See normal distribution aka bell curve.
And echo chamber and hive mind.
All of the above imply the same main point, just in different ways.
If OP went along the "father, son, and donkey story," then the OP won't have posted it at all.
My point was that there is no need to prepare a defence against downvoters, that too, up front. Not needed at all. Why is their opinion important to the OP? They can have their opinions, he can have his opinion of the same matter. What's the problem? The problem is only if one thinks that HN karma is important. It's totally unimportant.
So what? IMO, HN comments are also unimportant.
In fact, HN is also unimportant. I said that here on HN recently.
Jeez. Does anyone think HN is important in the real world?
In the HN world, HN may be important (and even then, only to some), but then it is an echo chamber.
>There is little point in making a comment that will disappear anyway, since no one will see it.
Maybe. Maybe not. Do you rate the importance or value of your comments by the number of people who see them?
>There is little point in making a comment that will disappear anyway, since no one will see it.
So what? So comment anyway, without bothering about it disappearing, just to express yourself, or refrain from commenting if the disappearing of your comment is so important to you.
Why are you here, though?
First say which of my above statements you refer to.
Until then I cannot meaningfully reply to your question:
>Why are you here, though?
Also, why should I not be here? You have any problem with it?
See what I did there?
Nothing in particular.
> Also, why should I not be here? You have any problem with it?
Not at all.
You might be reading too much into my comment, though.
>>First say which of my above statements you refer to.
>Nothing in particular.
>You might be reading too much into my comment, though.
I cannot be reading too much into your comment if you say that you refer to nothing in particular (out of my statements).
QED.
Be logical, like Spock:
https://en.m.wikipedia.org/wiki/Leonard_Nimoy
kthxbye :)
Preemptive defense against downvotes is a good way to attract them, so that's another reason not to do it.
Unless one doesn't care about downvotes, because, you know, one is not a slave to convention.
he or she (or they), sorry.
I like DataGrip for a very similar reason, relative to IDEA plugins.
Last time I tried to contribute to it, I ended up giving up. They wanted me to sign paperwork simply to report a bug. There was no documentation about how to build the IDE, which is scattered across dozens of repositories. Maybe that has improved, but I doubt it.
They seem to be putting all their eggs into the Theia basket, which is an IDE framework similar to VSCode. Would have been nice to see that energy go towards improving Eclipse instead of reinventing the wheel.
Improving the UI's handling of HiDPI would be nice. One can but dream.
You don't have to sign the CLA (contributor license agreement) if you want to report a bug, but you have if you want to contribute code, even a small patch for a bug you found. That's a legal requirement to protect the Foundation from contributions that may copy/paste proprietary code and to ensure that you will not in the future change your mind and make claims for your contributions. It's not peculiar to Eclipse Foundation, many open source vendors require contributors to sign a CLA [1]
My understanding is that Theia is currently more of a platform than a complete IDE. It is meant to be usable for building cloud-based IDEs, and you can test a distribution on your workstation, but being it a client/server architecture, you currently have to run a docker container locally to test Theia (or at least this was the case in Q3 2023). They are now focusing on the user interface and plug-in architecture of Theia (which is already capable of running VSCode extension). IMHO, for Theia to become really meaningful the server-side part needs to be improved: currently Theia reuses Eclipse JDT and other plug-ins on the back-end, which is fine for a desktop app, but less convenient for a client/server IDE as you will need a separate server-side container running the Eclipse plug-ins for every active user running the Web-based Theia GUI.
With respect to Eclipse itself, it has dramatically improved over the last few years, since the Foundation started making a release every 3 months. You may like the UI or not, but on my workstation it's now much faster and lighter than it used to be, and it's also faster and lighter than IntelliJ. To me the main issue with Eclipse is that it relies on P2 for plug-in distribution, which makes installing Eclipse add-ons a painful process.
[1] https://en.wikipedia.org/wiki/Contributor_License_Agreement
I was unable to create an account for the bug tracker without signing a CLA. Maybe that's changed now, but I'm pretty sure that was the case when I last tried.
I wouldn't say that Eclipse has dramatically improved on the last few years. On the contrary. It feels more sluggish to me and it crashes more frequently than before.
The plugin Marketplace in Eclipse is a steaming pile of shite. Installing plugins is an incredibly slow and painful affair. It can take MINUTES to run a search for a plugin, and while it's loading the rest of the UI just freezes. That's a shame.
But given that I can't even figure out how to build the full IDE with its hundrends of plugins, and the CLA nonsense, I certainly won't be investing my time on trying to fix that.
I used Eclipse on Linux about 8 years ago, and I remember running into frequent issues at that time: the problem was that I was using Ubuntu 16.04, but the SWT widget toolkit maintainers for Linux were Red Hat employees and they were focused mostly on Fedora. For several months SWT was very unstable because the native nature of SWT made it difficult to support it on the different Linux distributions, especially during the transition from GTK2 to GTK3, and considering that Ubuntu was tweaking GTK a lot to achieve its own unique visual style. You can get an idea of the problems the Linux maintainers were having here [1]
At the same time, the release notes of Eclipse clearly stated that that particular version of Ubuntu was not supported. So maybe you are running into the same issue, maybe you are using a Linux distribution that is not amongst the list of officially supported (=tested) Linux distributions.
With respect to market place and plug-ins my experience is different from yours, but having worked on Eclipse plug-ins for years I am certainly a more expert user. As I already said, to me the worst aspect of Eclipse is the p2 package format. It probably solves many problems (e.g. it tries to guarantee that you don't end up with a broken Eclipse instance due to lack of dependencies), but I often think that they could have achieved the same by using plain-old Maven dependencies and BOMs.
[1] https://bugs.eclipse.org/bugs/show_bug.cgi?id=492371
Edit: fixed typos
Eclipse has been my mainstay for ~20 years now, and while I know lots of people probably more authoritative than me will vehemently disagree, I honestly see it as one of the best pieces of software engineering ever made. The flexibility of the UI, the plugin system, incremental compile, the concept of perspectives and the overall stability delivered given how it is built - a complex ecosystem of cooperating plugins - is absolutely amazing. Now I've reached the point of making my own plugins and contributing to others my respect for it only increased.
It's definitely a complex tool and I think the vast majority of people fall over before they get over the hump of learning to use it. For more experienced users, many people still have in their head the image of Eclipse from 2007 and don't realise that it's been on a path of steady but slow linear improvement for more than a decade - another testament to the underlying engineering.
I’d probably be fine with a great TUI interface, too. So it’s really this intermediate UI that irritates me.
I use it on gnome all the time and never run into an issue.
There was a talk [1] at Devoxx 2023 by an Oracle which gave an overview of the current state of the UI ecosystem, and it wasn't too bad, though it seems like it's mainly JavaFX these days. Support for fractional zooming on HiDPI screens on Linux is still shit, unfortunately, which is something that drives me nuts.
What .NET GUI libraries are you referring to because anything other than WPF is tetering on "not a good idea." Have you built anything in Swing, WPF, Winforms, Xamarin Forms, or MAUI? You should give them all a serious test drive and get back to us with some informed comments.
So thank to the developers.
I also use another DB admin tool: HeidiSQL. This one is lightning fast. Most likely because it is native application. Written in Delphi btw
Same thanks to the developer
A free and open source DB management tool is still an impressive feat, but I absolutely would not trust it with anything where blowing up would have consequences.
As already said DB admin tools are not my daily driver. I either did not use Heidi intensively enough to uncover all the problems you mentioned or they've fixed those.
I still prefer it as it is fast and has a nice UI and if they can sort the crashes, I would be a convert.
If you asked me objectively "do you think it's pretty?" I'd probably say no, but never once has this even occurred me when using it since I'm usually just trying to get work done, which I find it very useful for. It's a productivity tool, not an art piece I'm hanging on my wall.
People sometimes forget the importance of user experience and it's why some amazing software barely gets used.
Personally I care about aesthetic and consistency but willing to sacrifice depending on what I'm doing.
UI and UX does matter, even when talking about productivity software.
There can also be an element of inspiration and influence. If all my tools are well designed, I’m more likely to set a high bar for whatever I’m building. If I’m using ugly and poorly designed tool. The bar for whatever I’m making will likely drop to the environment I’m around.
Nonstandard UIs aren't end of the world, but if possible I don't want the extra cognitive load of interacting with 5, 6, 7, whatever slightly different GUI paradigms.
Like most developers I'm using multiple applications at once. Typically I'm using a terminal, text editor, browser, Slack, email, and maybe a database GUI.
A developer's cognition and cognitive load are limiting factors. Increase my cognitive load by X% and there is going to be a Y% increase in how long it takes me to do something and/or a Z% decrease in the quality of the work. Even if X% is small, it adds up pretty quickly. After all if we are employed full time that is 2,000+ hours per year of work.
Again, not just aesthetics. It's little things like, "does this software support the standard keyboard shortcuts for my system?" If CMD+W closes a window in every app except one that's kind of a pain. Etc.
However, I'd also agree with the GP comment. Its use of SWT ui results in some rather weird oddities. The biggest one is that if we configure gnome to use dark mode in linux, we get this absolutely unusable UI with barely visible text in many places. It becomes very obvious in that case which of the widgets are coming from gtk and which are custom rendered - and the distinction between them is stark.
And there doesn't appear to be a clear way to fix it without actually disabling the dark mode at OS level. I'd be perfectly fine if it used some framework that rendered its own widgets that looked a bit different or even if it ignored the dark mode completely and stayed usable.
Another example is Total Commander. I would buy it if it worked they way I think and had proper whitespace instead of being infinitely configurable and using non-conventional UX defaults (hit R I should jump to the first file staring with R, FFS).
If I have to suffer through this shit then so be it. If I don't have to suffer through it...delete.
A fun representation of the need for such beauty is in the game of Rimworld. In this world, the characters you manage react to the beauty of their surroundings, they need it to be beautiful to a degree, similar to how they need comfort, and recreation. Mood is central to the game, and an easy way to improve it generally is to create a beautiful environment, even if the characters are going to do mundane work like butchering.
On a mobile I kind of get it because having apps work in similar ways eases the learning curve (I.e burger menus etc), but all the UI paradigms being used in dbeaver are the same as any other desktop app.
I appreciate the fact that it works identically on Linux as it does Windows (and presumably MacOS). Not even Microsoft maintain consistent use of widgets within their operating system, you still stumble across windows 3.0 looking screens in windows 11.
I say…it’s good that dbeaver eschews native widgets
Also, the annoying 'new version,...' popups are annoying.
Otherwise, a great gui.
And the weird wording when you finish restoring a database with the button "next" highlighted, asking for one more ride.
> Connectivity: closing timeout for an idle connection was increased and disabled for embedded
My beef is there doesn't seem to be a way to contribute $$$ to the OS version -- except for buying/subscribing to the commercial version. Maybe I've missed some web page that explains how to do contribute -- so if anyone knows if there's a way to do that --- post it here.
I mean I kind of get where you're coming from, but on the other hand... outside of software, would you ever praise a product as an amazing life-saver, but express a beef with the makers' lack of a pocket-change GoFundMe?
Presumably any profits they make from merch goes into their pockets, so you could buy something from there that's in the price range you want to donate I suppose https://www.redbubble.com/people/DBeaverCorp/shop
For desktop I, personally, prefer Idea Database plugin, because it's just SQL editor, but incredibly powerful one.
I also quite like DataGrip (essentially a standalone of the IDEA database plugin, or maybe the plugin is a plugin version of the standalone, not sure which came first).
DBVisualizer: https://www.dbvis.com/ (for exploring the schema)
Jailer: https://wisser.github.io/Jailer/ (for data browsing)
Aside from that, it's usually just been a mix of using specialized tools like MySQL Workbench, SQL Developer, pgAdmin and others, or something that tries to do it all like DataGrip.
Didn't actually find anything particularly amazing about DataGrip, but if I'm paying for the JetBrains Ultimate subscription, might as well use it because it's pretty okay.
This looks good. Anyone have experience with it?
One of my favorite features too. I don't doubt this has saved me from some bad mistakes since you can use a methodology of "select rows to change" and manually set their value, then review, then Save, rather than issuing an update that tries to change them with SQL. For small scale ad hoc maintenance it's great.
But, I often use jupyter notebooks for the DML aspect of hard queries and data anlysis, for the power of dataframes and repeatable cells mixed with documentation and sharing.
So all that to say, anyone know if there is a DDL browser equivalent ideal for jupyter notebooks / ipywidgets?
DBeaver aims to be a full admin system and simply getting to the data makes me drill 3-4 levels deep in a tree and it's quite annoying that only adds to the "clunky-ness".
I'm going to give it another serious go. I like TablePlus but I prefer open source options.
I've been using PostBird which fails pretty hard at any "large" data inside a single cell. The columns just bleed everywhere. I'm sad it's not true OSS because I know the community really wanted to take it much further but the original maintainer didn't want to. Their right, I get it, still sad.
A cross platform version could be written in Lazarus, with the idea that it uses less system resources than a large java program.
I recently had to import a CSV with some million rows into MariaDB. Neither HeidiSQL nor DBeaver could do it (tried various settings). IntelliJ worked like a charm.
I use this feature quite a bit, if DBeaver has a similar feature. I might try to make the jump.
I just create views like:
Create or replace view parqtable as select * from /pathtoparquet/*.parquet;
But otherwise it does everything I need. I install it on all of my computers.
A good example of a well done dark mode (in my opinion of course) is Grafana.
Navicat has Data Synchronization feature which you can use to compare and sync data across two databases. I dont think any other DB tool has that feature which also works on a Mac
It's your general swiss army knife for DB tools
That’s not to say you can’t write SQL with a GUI, of course, but judging by the replies it seems like they’re more often used to look at or change tuples via clicking.