7 ms·
Dbeaver – Multi-platform database tool
- guilhas 8y agoSometimes I use it, but data related for sql server, still prefer HeidiSQL.
- deviantfero 8y agoThis is a great tool and it makes my life so much easier, so much better than pgadmin4
- datavirtue 8y agoI work with a huge postgres environment and I use DBeaver every day. Pgadmin is unbearable.
- orthecreedence 8y agoI use DBeaver all the time and love it. MySQL, Postgres, SQLite, etc...all the tools I need in one app. I generally try to avoid Eclipse-based projects because they can be very bloated, but in this case it's easily justifiable.
- babaganoosh89 8y agoCool, can anyone tell how it compares to Datagrip by jetbrains?
- priitmaxx 8y agoDoes datagrip support nosql?
- ashhimself 8y agoNot natively as far as I am aware.
- paulie_a 8y agoNo that I am aware of. But compass for mongo works pretty well. It's fairly simple but to visualize the data and run some queries it's nice.
- deleted 8y ago[deleted]
- genieyclo 8y agoDataGrip:DBeaver::IntelliJ:Eclipse
- krick 8y agoNot sure what you are trying to say.
- petersellers 8y agoDataGrip is essentially a stripped down version of IntelliJ packaged with their database plugin. Dbeaver is similar but using the Eclipse framework instead.
- ChristianGeek 8y agoDataGrip is to DBeaver what IntelliJ is to Eclipse.
- steveneo 8y agoI use jet brains Datagrip as well. It is great (for PostgreSQL) but the big issue is, it cannot connect MySQL database in utf8mb4 encoding. The issue is there for years. Dbeaver is great, there is no such issue to connect utf8mb4 MySQL!
- jesseb 8y agoThis looks great. I currently use a few separate applications for working with various databases, looking forward to giving this a shot instead.
- edgarvaldes 8y agoI use Navicat, and I'm very pleased with it.
- nightbrawler 8y agoSame here, it's hard to beat. And with the addition of MongoDB support, it's really a complete tool for my team.
- brightball 8y agoI’m a huge Navicat fan and it’s the tool I most miss since switching to Linux. Their Linux version is just running the Windows version in Wine. I’ve been using DBeaver and I’ve been very happy with it though. Paid for the enterprise license to help support it too. The biggest tools from Navicat that I miss within DBeaver are the data sync and schema sync tools.
- CWuestefeld 8y agoAs we're starting to move away from MS SQL Server, I'm just starting to use postgresql, and Navicat as a tool. But I'm really underwhelmed by Navicat's features and performance. It doesn't seem like a well-thought-out whole, and lacks a lot of obvious features (let's start with freakin' hotkeys for Run and Run Selected). I just discovered DBeaver today, and while it's not up to the standards of SSMS (which is an amazing tool) with SQL Prompt, it so far beating the pants off Navicat.
- edgarvaldes 8y agoRun is CMD-R, and Run Selected is SHIFT-CMD-R. [0] [0]https://www2.navicat.com/manual/online_manual/en/navicat/mac_manual/KeyShortcut.html https://www2.navicat.com/manual/online_manual/en/navicat/mac...
- dyeje 8y agoI prefer TablePlus personally, DBeaver just feels clunky in comparison.
- bart3r 8y agoI would feel uncomfortable saying the word 'beaver' at work.
- burke 8y agoAs a Canadian, I would have absolutely no problem saying the word 'beaver' at work.
- Jach 8y agoWhy? Is it a bad word in some language?
- bart3r 8y agohttps://www.urbandictionary.com/define.php?term=beaver https://www.urbandictionary.com/define.php?term=beaver
- ASalazarMX 8y agoEvery word in Urban Dictionary has at least one innuendo definition. Specially those that aren't innuendos.
- topspin 8y agoAmong some the term beaver is suggestive, or even offensive. Think Thelma & Louise; "Damn! I hate that! I hate being called a beaver! Don't you?" It's a particularly lowbrow bit of slang and not something that worried me when I recently mentioned the name dbeaver in a professional context, although I am aware of it. It pleases me that I spend my time among people that are either ignorant of this matter or are happy to pretend they are.
- paulie_a 8y agoI'm going to guess the cross over of Thelma and Louise fans and SQL database users is probably fairly low.
- DoubleCribble 8y ago
- escanda 8y agoI am missing bigger screenshots though, I tried opening them separate but they are quite small.
- ocdtrekkie 8y agoI did this as well. I inherently expected screenshots small enough to be mostly unreadable would enlarge if I clicked on them.
- yardshop 8y agoBigger screenshots, even one very large one, can be seen from the links on the Github page: https://github.com/dbeaver/dbeaver https://github.com/dbeaver/dbeaver
- escanda 8y agoThanks!
- jadbox 8y agoPgcli and PgModeler are usually by go-to these days. (Sometimes pgadmin4 if I need to see stats)
- mijoharas 8y agoAll of my colleagues use postico (I'm the only Linux user at my company), which seems quite nice. Can anyone who knows both tell me how this compares to that?
- postit 8y agoI’ve used postico, navicat(mac/Linux) and dbeaver. Postico is very similar to Sequel Pro, simple but effective. Navicat is the more feature complete option, but using wine on Linux is not cool. I’m very happy with dbeaver.
- mewm 8y agoI like to try out new tools likes this, but whilst on my mac, and I generally use Sequel Pro for my databases (I use mysql and mariadb drop-ins). I have my database locally in a docker container, where I forward 3306 to 3300. Entering host as 127.0.0.1 with correct credentials and port, it gives me this error: "Could not connect: Access denied for user 'root'@'172.18.0.1'". This does not happen with Sequel, but occurs with Dbeaver. It actually also happened trying TablePlus which is a piece of software that a fellow commenter was mentioning. I'm sure that it could be solved in my configs by allowing that particular IP, which is the local IP of the virtual machine which is serving docker. However, that is supposed to be completely transparent, thus I should be able to connect through 127.0.0.1. As I haven't looked at the source code, it seems like the host lookup logic is flawed, as it translates my `127.0.0.1` to `172.18.0.1`. Why? Dunno. But this occurred in both Dbeaver and TablePlus. Works in my terminal and in Sequel however.
- lugg 8y agoThis sounds like a docker network problem more than an issue with dbeaver. Try binding MySQL to 0.0.0.0 (all interfaces) instead of 127.0.0.1 (loopback). That said, 127.0.0.1 should be fine provided you connect through the service name or the docker container IP), connecting via 127.0.0.1 doesn't make sense. Then again, it's docker on Mac, so I don't really know. Fwiw, also used sequel pro on Mac, moving to Linux dbeaver was the only thing that came close. Now I don't really mind either but dbeaver is a bit quirky overall.
- mewm 8y agoI know I can solve that by allowing "everytuldhing" to connect, but that is not my point. Hence my ""I'm sure that it could be solved in my configs by allowing that particular IP"" comment. That it's `Docker on mac` is kinda irrelevant, as it's still just a virtual machine with a somewhat static IP. My point is, that when it comes to transparency on that level, this piece of software does not acknowledge that, but Sequel Pro does. I'm not a particular fan of Sequel Pro, but it just works in these types of case. I'm still expecting, that software like this, would be able to handle this type of "proxy mechanism", so from outside the docker container, I could still connect through 127.0.0.1 to it, thus making the default config adequate. Not sure if this is even makes sense, but I feel, that when connecting through a binding docker port, it should still use the origin IP ie. 127.0.0.1
- rejap 8y agoGreat tool and it supports msaccess files
- deleted 8y ago[deleted]
- zmmmmm 8y agoI like DBeaver but I've been having some problems with how it handles timeout of connections. I often end up sitting with it unusable for up to 2 minutes because it can't seem to understand that a connection is dead, despite me setting all the available options to use a shorter timeout. I'm sure this is partly due to my specific network conditions but it nearly destroys its usability while other tools (eg: SquirrelSQL) just don't seem to have the same problem.
- inetknght 8y agoI've used DBeaver at work on Linux to connect to Microsoft SQL servers and also to some PostgreSQL servers. It's not perfect but it's not bad. My experience was annoying (at best) to get drivers to work; particular the tsql ones (since Microsoft didn't provide Linux drivers at the time -- I don't know if that's been rectified). Once they're working though, everything else is fairly intuitive. It's been a couple years since I moved to a different team and no longer need to connect to databases (and can't anymore... yay security). But I've considered using DBeaver at home for personal use.
- thecrumb 8y agoBiggest benefit for me is DBeaver is cross platform so I can use the same tool on Windows (work) and Linux (home).
- ekianjo 8y agoI use DBeaver to connect to Oracle SQL (among other things) and it works well for this purpose. I tried other alternatives too but DBeaver felt the best among them (layout, options, and general speed).
- wkubiak 8y agoAlways used it while ddveloping database connected apps in Eclipse. Never let me down.
- mariopt 8y agoI've been using in on macOS and it just works. There are so many free tools for databases and I'm wondering : How do the devs survive with free versions and/or open source? Don't think donations will amount to any relevant amount.
- codetrotter 8y agoWoah, that ER diagram functionality reminds me of a tool that I tried a long time ago but which I had since forgotten. Back then the tool in question had too many issues and shortcomings, but they may have developed it sufficiently now. https://pgmodeler.io/ https://pgmodeler.io/ Being told about Dbeaver and reminded of pgModeler right now is great because I am currently defining the tables for a project I am working on for a client, and as the number of tables grow jumping back and forth between the files that define each of them adds a still small but noticeable overhead. With a ER diagram tool I might be able to speed up a little part of the definition work. Edit: Hmm, pgModeler might still not be such a great tool https://news.ycombinator.com/item?id=17693582 https://news.ycombinator.com/item?id=17693582
- eyeball 8y agoMy company's IT team won't allow install of non-approved tools. I'm stuck with oracle sql developer. fml.
- zmmmmm 8y agoPretty sure if it's java based you can download it and run it entirely in user space if that is OK. Of course, making an end run around IT policy isn't always an advisable solution even if it does work.
- sixdimensional 8y agoYup, I am in the same boat and DBeaver works great just running standalone even without admin rights.
- rebelde 8y agoNeeds Java. I saw it mentioned in the HeidiSQL thread and thought I would try it. Never completed the installation. Not putting Java on my machine, nope. Yes, I do understand the advantages of Java. Runs everywhere, which is nice. I'm still not installing it.
- zmmmmm 8y agokind of curious about the passionate avoidance of installing Java - is that an anti-Oracle stance or something else? (I tend to be the opposite - if I can find a Java based tool to do the job I'll choose that because they tend to be very self contained, don't often require messing around with other OS dependencies ...)
- rebelde 8y agoIt constantly hassles me with requests to upgrade. Doesn't it sometimes try to trick me into installing something else, too?
- zmmmmm 8y agoYeah, the Oracle installer does / used to do all those things. Apart from anything else, you will now end up agreeing in the fine print not to use Java for certain purposes. Basically, don't use anything Oracle to do with Java. Fortunately there are good ways to get it. OpenJDK and Azul have much more hassle free installations now. I personally use sdkman [1], but conda [2] is another very easy way to get java that won't hassle you. Not that I'm trying to persuade you or anything - I was just curious! [1] https://sdkman.io/ https://sdkman.io/ [2] https://anaconda.org/anaconda/openjdk https://anaconda.org/anaconda/openjdk
- rebelde 8y agoThanks for the reply. You and the others have really lost me about the differences and compatibility of Java, JRE, OpenJDK, sdkman, conda??? Maybe I'm in the middle. I pay enough attention to not want to deal with Java, but I don't know well enough to find other non-Oracle ways. I might research all this someday and lose my distaste of Java. Gave my honest thoughts on this and lost 3 karma points. Not too bad this time. I still have a few more to spend.
- enz 8y agoI used Dbeaver for years. Once with MS-SQL, which was quite unstable... But no problem with MariaDB, SQLite and PostgreSQL. Plus, the built-in support of SSH tunnels is a big plus for my use cases!
- neosavvy 8y agoHow is no one talking about https://www.jetbrains.com/datagrip/ https://www.jetbrains.com/datagrip/ These guys actually fix their bugs. It works on every database known to humans, and also does nearly everything DBeaver appears to do.
- dotjosh 8y agoThis, it's incredible. Amongs many other things, it supports a lot of the navigation/refactoring features of all the other IntelliJ products.
- danellis 8y agoDoes it do anything the IntelliJ database plugin doesn't do?
- yumraj 8y agoPerhaps, but DBeaver is free while Datagrid is not, in fact it is rather expensive at $199. For many people, including me perhaps, something like DBeaver is good enough since it's free.
- tomnipotent 8y ago> rather expensive at $199 Compared to a six-figure salary? Developers tools are a bargain for what we get out of them.
- meddlepal 8y agoDevelopers are hands down one of the cheapest group of customers to deal with. I've been shelling out for IntelliJ Ultimate for years because I want to support JetBrains. At this point I think I could actually get away with just the open source Community Edition, but it's worth paying them for the effort in my mind.
- tomnipotent 8y ago
- blaisio 8y agoIt's a little buggy but it does everything the paid tools do. The only thing I really dislike is it requires Java.
- systems 8y agoSSDT and their DACPAC deployments is very good I wish an open source tool will one day try to offer something similar
- rsyring 8y agoI can't believe how hard it is to find a good database client tool that runs on Linux. I spent hours on Sunday looking for something that worked as well as pgadmin3. I don't prefer these Java tools that force you to manage JDBC drivers and usually share dated and cluttered UIs. Plus, I can't stand having to manage connections to each database instead of to each server. Let me connect to the server and then select my dB. My notes: - Lists - https://wiki.postgresql.org/wiki/PostgreSQL_Clients - https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools - Clients - Most clients are Java, which is a pain b/c - they require you to list the DB in the connection - JDBC drivers can not use a socket connection - UI isn’t great - Valentina Studio - Has free & pro ($199) versions - Was the easiest to get connected initially, but then found bug that showed it wasn’t using socket connection as expected. - Navicat - Linux version is a Wine app - RazorSQL ($100 / year) - Is a Java app - Not much different from SQL Workbench, just use that instead? - TeamSQL - Electron, AppImage - Wanted me to enter an email address just to use the software, became privacy concerned about how much stuff would get sent to their servers - DbVisualizer ($197, $69 renewal) - Java - Downloaded & tried it, typical java app - SQL Workbench/J (OSS) - Java - Datazenit - web based but still Java? - PgManage - too crude - JetBrains DataGrip ($199 / $159) - Java - PgAdmin3 - has lots of errors when used with PostgreSQL 11 - PgAdmin4 - installed, couldn’t get past the splash screen which said it couldn’t find the application server - Sqlectron - Electron - Couldn’t get a DB connection to save - dbForge - Windows only - dbGlass - No longer developed - HeidiSQL - Windows only - DBeaver - OSS and enterprise version
- wmsiler 8y agoDespite being written in Java, DBeaver does let you connect to a server, then pick which database you wish to connect to.
- sk5t 8y agoYou can flip between postgres databases in dbeaver quite easily (dbeaver calls it changing the "active object"). I used to use pgadmin3 every day, and have found dbeaver to be much better, and about the same as DataGrip. Although some things still feel better in psql or pgcli. The vast coverage of JDBC is probably a good reason so many tools use Java. I'm sure you wouldn't prefer they all used ODBC or DBI instead.
- 013a 8y agoI've used TablePlus before (Mac+Windows); its really good, and pretty affordable at a $60 one time charge. https://tableplus.io/ https://tableplus.io/
- dotdi 8y agoTablePlus is very nice and it supports NoSQL databases like Cassandra, CockroachDB, and Redis. It's Electron-based, so it is relatively heavyweight, but I like it a lot.
- mthoms 8y agoMy experience with it wasn't so great. Very buggy and unintuitive. I also got summarily dismissed on github when reporting a very pedestrian bug/oversight. https://github.com/TablePlus/TablePlus/issues/677 https://github.com/TablePlus/TablePlus/issues/677 Aesthetically, it looks great though. I wanted to like it.
- electrotype 8y agoI use Dbeaver everyday. Thanks for it.
- samaysharma 8y agoWhat's the most convenient tool you've found for Postgres?
- zoom6628 8y agoBeen a user of DBeaver for years - across all my platforms. Its does most things well enough that it has not been a problem to use across SQLite, MSSQL, MySQL and various file based data. Easier to use than SQuirreL which used to be my fav. All of these are java tools I think primarily because of starting from JDBC for which there seems to be a driver for just about everything on the planet. So DBeaver scratches my itch of needing same tool across platforms, across databases.
- JimmyL 8y agoI've had better experiences with DataGrip, but if I wasn't at a place that would pay for proper tools, DBeaver is an OK substitute. Neither, though, have the big thing I want in an analytical SQL workspace: Simple charts A whole lot of my work ends up with a three- or four-column table with one column of buckets, and the other being counts of how many things ended up in that bucket. I'd love a view where I could render that into a line or bar chart as a sanity check, and have it update in real-time as I change my query. Instead, I end up having to constantly copy/paste into Excel and do it there. Yes, I should be using a proper BI or visualization tool for real reports. But sometimes I just need a quick line chart to show that yes, that one count is going in the right direction.
- sixdimensional 8y agoHave a look at Metabase. It's open source, web based and runs from a single JAR. Not the same as a full fledged management tool of course, but I like it for simple queries and charts and the price! DbVisualizer also has built in charts that are simple but... not free/open source.
- sixdimensional 8y agoOr if you don't mind the web based approach, Apache Zeppelin too.
- 40four 8y agoI stared using Dbeaver a couple months ago, after looking around for an alternative to HeidiSQL on my Windows 10 laptop at work. Used HeidiSQl for a long time but got fed up with issues with it freezing or crashing, especially when switching DB connections. Dbeaver has been fantastic! Has some feautures Heidi didn't have, very stable & better looking UI. Thumbs up from me, definitely worth giving a try!
- pedrocx486 8y agoNice to see someone that used HeidiSQL. I'm on the same boat. It feels like an abandoned project. I guess it's finally time to install DBeaver and say goodbye to Heidi.
- vanous 8y agoThanks for mentioning this, I will also give DBeaver a shot instead of HeidiSql
- creUsNa 8y ago>feels like an abandoned project HeidiSQL feels like a finished product to me. Really no complaints at all and if you actually take a look at the commits, you'll see that the SINGLE developer puts in a whole lot of effort. https://github.com/HeidiSQL/HeidiSQL/commits/master https://github.com/HeidiSQL/HeidiSQL/commits/master The guy is great and calling the project abandoned is really not fair.
- 40four 8y agoYeah, creUsNa is right, definitely not abandoned, just maintained by one person. And credit to Mr. Becker, HeidiSQL is a fantastic project. I used it for most of my time at my current job, where I came in as a junior developer. My boss and his guys have been supporters of HeidiSQL for years, so they pointed me it to my in my early days. I'm not sure if it is just an issue with my machine, because others in my office still use Heidi and don't report the bugs I am having. Small as they are, they got annoying enough for me to start seeking alternatives. I would still recommend people giving Heidi a spin if they've never tried it.
- tedk-42 8y agoGreat tool with a great name. Anyone who doesn't like it is an idiot :P
- equasar 8y agoNo need to insult whoever dislike your preferences.
- systematical 8y agoLove DBeaver, been using it for years now. Engineer(s) is very responsive with github bug reports too.
- spricket 8y agoDbeaver is the best FOSS database UI tool hands down. I've done a lot of searching and haven't found anything close. Managed to convert my whole office to it in a matter of months. Favorite features: Well integrated ER diagrams that let you quickly see parts of the db related to current table, or the whole thing if you want. SQL generation from structure or data edits. Great for cranking out DB migrations like a boss. Ability to maintain many database connections at once, and support for doing stuff before/after connecting which we widely abuse to setup SSH and VPN connections. Very liberal database support. My original search for a tool like DBeaver was from the need to connect to MySQL, Postgres, and SQL Server and not wanting to use a bunch of different tools. DBeaver supports roughly anything Java supports, which is everything. Wide OS support. Good luck finding another tool that can connect to MS SQL Server on MacOs that isn't garbage or money. The icon is also adorable The only downside is a bit of classic FOSS UI clunk. Not nearly as rediculous as Eclipse or Blender or the like, but it takes a few days to get comfortable.
- wink 8y agoJust installed it for the first time in a few years. - Again I wonder why it doesn't show the tables first, I have to go through Schemas -> Public. - 480 MB of RES RAM, I'm connected to one smallish Postgres DB. - I can't even find "just show me the contents of the table, like 'SELECT * FROM'. I know, maybe it's tailored for Enterprise Database Architects, but this is my smoke test for a DB GUIs: "How long and how many clicks does it take so that it provides more value than: 'psql; \dt+; SELECT * FROM X;'"
- spricket 8y agoMaybe I've been jaded by SSMS and Mysql Management Studio heh. DBeaver actually has a better UI than most DB tools I've used, even though that's still not saying a lot. Mouse over the buttons for an excessive amount of time and the tooltips will tell ya what they do. Double click a table and go to "data" tab to see contents. Schemas ->public is just a side effect of supporting a lot of different databases. Many support schemas Ram is because default java heap size, you could probably change launch params to get it much lower though. On all counts other DB tools I've used are just as obtuse and burn tons of resources. Most are written in Java or another high-level language because it's nigh impossible to get DB drivers for a ton of different databases working together in C. DBeaver is basically leveraging JDBC for what it was designed for
- emmelaich 8y agoDbeaver is great. If you like a cli tool, http://henplus.sourceforge.net/ http://henplus.sourceforge.net/ is ok and easy to modify if you feel inclined. It's written in Jython and used jdbc. There is a version with line-editing around using jline.
- hoerzu 8y agoAnyone using it with exasol? What's your opinion on in memory databases?
- vorticalbox 8y agoAfter installing solusOS I was looking for a replacement for MySql workbench and was suggested this and I have to say it works really well.
- creUsNa 8y agoIf only it didn't have such a PTSD-inducing, eclipse-based UI. HeidiSQL (with WINE) is still by far the best SQL client for me, because the UI is simple yet efficient and very clean.
- fiatjaf 8y agoJust sharing the database management tool I use and love: https://github.com/martingms/vipsql https://github.com/martingms/vipsql
- iron0013 8y agoI've been using DBeaver for years now, and it just keeps getting better and better. I use SQL every day, and DBeaver is the best client I've found. It's shocking to me, actually, how absolutely awful most SQL clients are. It truly was an area that was ripe for "disruption".
- zepearl 8y agoI love DBeaver. Long time ago I started searching for a DB-client similar to "TOAD", but on Linux and targeting only my following key requirements: 1) write & execute single SQLs on a "page" which has multiple SQLs without having to use any terminator (";") between them, 2) ability to show the execution plan of the SQL in which the cursor is positioned and 3) ability to connect to different kinds of databases. I ended up with nothing, and I actually even initially excluded DBeaver as running on Java (personal thing - most Java apps I tried always had some kind of bug which made it a no-go for me). After a while I gave it a try and I ended up being extremely happy with it, especially because I can use it with basically all databases that I am/was using (I'm currently using it mostly with MariaDB & Clickhouse, but used it in the past as well with DB2, Kudu, PostgreSQL).
- tuananh 8y agowhile i kinda like dbeaver on windows. the experience of dbeaver on macOS is terrible.
- vladsanchez 8y agoDoesn't work on the Mac right away. It exits with bunch of Java exceptions ranging from JRE versioning issues to Eclipse exceptions I don't want to care about. Piece of crap in my opinion. Thanks for the suggestion anyways. Next!