9 ms·
DBeaver – open-source database client
- paulryanrogers 3y agoIt's a decent free and cross platform UI. Doesn't have all the DB specific features of a tool like PG admin or MySQL Workbench. Still, I like having the same tool for all my basic needs, and only use a more specialized one where I really need it.
- thunderbong 3y agoCan you elaborate on what DB specific features are missing?
- paulryanrogers 3y agoPgadmin has some in depth stats about the server and can export COPY statements, among other things. MySQL Workbench has some nice planner visualisations.
- teaearlgraycold 3y agoDbeaver is generally great. Sometimes I have weird issues where it just can’t load data after losing connection with Postgres. It’ll act like it’s reconnecting but will invariably fail. I need to manually disconnect and reconnect to get it to work. But otherwise it does everything I need. I install it on all of my computers.
- vbezhenar 3y agoAlso they made a browser database client (cloudbeaver) which is much better than pgdamin IMO. I set it for my company, so people can easily access database without creating tunnels, sharing passwords, etc. I tried pgadmin before, but it was incredibly buggy, almost unusable as a shared installation (often server would just hang until restart). For desktop I, personally, prefer Idea Database plugin, because it's just SQL editor, but incredibly powerful one.
- joshstrange 3y ago> 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).
- htrp 3y ago+1 It's your general swiss army knife for DB tools
- anonu 3y agoI use this successfully with different versions of postgres, SQL server, MySQL, redshift and others. Does the job.
- hackyhacky 3y ago[flagged]
- neals 3y agoI use HeidiSQL for my SQL databases
- nurettin 3y agoThis is a windows program written in delphi. A fitting choice, because Delphi provides both the necessary data grid component and the syntax highlighting editor, as well as connectors to several sql databases. A cross platform version could be written in Lazarus, with the idea that it uses less system resources than a large java program.
- bojan 3y agoI was forced to switch to DBeaver as HeidiSQL isn't allowed at my current employer. I miss how light Heidi is, but I'm not sure I'd switch back now I'm used to all the features DBeaver has.
- Aeolun 3y agoI use a mac and linux now. I think HeidiSQL is the thing I miss most from Windows.
- mappu 3y agoSomeone started a cross-platform rewrite at https://github.com/ragnar-lodbrok/meow-sql https://github.com/ragnar-lodbrok/meow-sql which has made incredible progress.
- deergomoo 3y agoHave they fixed the awful stability issues and the fact that a query that takes longer than ~5s will lock up the entire application until it completes?
- frozenice 3y agoI also use HeidiSQL almost daily. Besides MySQL / MariaDB it also can connect to MSSQL and Postgres. 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.
- cowmix 3y agoDBeaver is amazing. As someone who needs to do adhoc querying / extracting / loading of data from any hosts of system on a daily basis - this tool has saved me over and over again. 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.
- evanelias 3y agoOut of curiosity, why not buy/subscribe to the commercial version then, if this is the clear path for how to support the primary developers of the software?
- cowmix 3y agoI don't like the subscription options they offer. I just want to throw them $50 a year for the CE version -- which I would think is better than $0 a year I'm giving them now.
- evanelias 3y agoFrom my POV, $50/year is not necessarily better than $0. Open source "donations" to open core / commercial OSS businesses typically don't amount to much in total. It's basically a rounding error for most businesses, with the extra downside of accounting/tax tracking. And although many FOSS financial contributors understand that this is a no-strings-attached type of situation, a small portion become very demanding and have unreasonable expectations due to being a supporter. 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?
- worble 3y agoI swear I donated to them via paypal once long ago, but I think they've since removed all those donation links in favor of the EE. 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 https://www.redbubble.com/people/DBeaverCorp/shop
- shortrounddev2 3y agoI use dbeaver extensively at work. I like that you can graphically edit rows and it will start those changes as a transaction, so you can hit ctrl+s to commit the changes
- zmmmmm 3y ago> I like that you can graphically edit rows and it will start those changes as a transaction, so you can hit ctrl+s to commit the changes 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.
- cbb330 3y agoI like dbeaver for browsing DDL, list of tables, examples of schema, data types. also, to edit a few rows here and there as a quick test/fix to something. because its easier to click around than write many 2 line sql to do the same thing. 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?
- singingfish 3y agosame, except I use emaacs org mode instead of jupyter (and have record keeping / backup implemented with git-auto-commit-mode as well)
- lucasfdacunha 3y ago[flagged]
- xnx 3y agoGreat tool. Would be nice of it associating it with .parquet files on Windows allowed DBeaver to connect to them with a double-click.
- Nihilartikel 3y agoI use the duckdb connector as an intermediary for parquet in Dbeaver - it works quite well. I just create views like: Create or replace view parqtable as select * from /pathtoparquet/*.parquet;
- dfee 3y agoI don’t know why it matters to me, but I’ve always been put off by it being ugly and using non-native widgets. That may be the only reason I’ve paid for TablePlus. I’d probably be fine with a great TUI interface, too. So it’s really this intermediate UI that irritates me.
- ramon156 3y agoNot good at supporting GTK either, its the sole reason I do not use it on gnome
- staticlibs 3y agoDBeaver uses SWT toolkit, its widgets are as platform-native as Java can do. Some of them can be much faster with long text editing than default Java Swing widgets.
- ptx 3y agoYup, SWT is a wrapper for actual native widgets, similar to wxWidgets. Some widgets are custom though, like the horrendously ugly tab widgets, which might be what the other commenter is reacting to. And the spacing and alignment usually doesn't look great in most SWT-based apps I've seen, for some reason.
- fiddlerwoaroof 3y agoAt least on Apple platforms, I don’t think SWT uses Apple’s layout algorithms and so you end up with Cocoa controls with slightly wrong spacing
- staticlibs 3y agoDBeaver works surprisingly nicely with less popular DBs. I work with Babelfish for PostgreSQL [1], it supports connections with SQL Server client libs. Most GUI client tools (like SSMS) expect "real" SQL Server on the other end of the wire - depend on various system views for DB introspection, so only partially work with Babelfish. Even if client tool is based on JDBC (like SQuirell SQL), it doesn't guarantee that this tool won't use additional SQL Server-specific queries for introspection. DBeaver is much better at this, I guess it is using JDBC API or DB-neutral INFORMATION_SCHEMA views for introspection. [1] https://babelfishpg.org/ https://babelfishpg.org/
- silentsea90 3y agoThey do use JDBC and even allow you to customize your choice of driver version for a db. It is a bit clunky when one has to resolve missing dependencies but that's just how it works I guess.
- RachelF 3y agoThe free version supports a few, but you need to pay $500 a year if you to talk to more databases or want security or cloud features: https://dbeaver.com/edition/ https://dbeaver.com/edition/ It's a great tool, though, a bit buggy but most useful.
- tasuki 3y agoIn what way is the free version lacking security?
- supriyo-biswas 3y agoI personally like the ER diagram viewer in DBeaver. On a project with very little documentation, it was extremely pleasing to point it to the staging database and be able to visualize the relationships between various entities.
- NewJazz 3y agoSchemaSpy can generate static docs based on a live db, and they include pretty good ER diagrams (IMO). They have a sample on their website (go to the relationships section): https://schemaspy.org/samples/epivirusurf/ 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.
- osigurdson 3y agoFunctionally it is very good, I like it very much. it does show that not all dark modes are created equal however. I think it takes an especially good designer to do dark mode well. A good example of a well done dark mode (in my opinion of course) is Grafana.
- RespectYourself 3y ago[dead]
- 0x073 3y agoSince I used navicat, almost every other db tools feels incomplete.
- i_am_a_squirrel 3y agoI've been using it for 5+ years! So much functionality for a free tool
- sdwvit 3y agoDBeaver is great and has been in my arsenal of dev tools for at least 5 years.
- tiku 3y agoI'm looking for a tool like this that converts the schema to Laravel model files. Why? Because I'm lazy.
- zmmmmm 3y agoI know probably 95% of HN will see it as a downside but one of my favorite things about DBeaver is that because it is implemented on Eclipse you can install nearly any Eclipse plugin and they work. So I installed Vrapper to edit in Vi-mode, some git tools I like, PlantUML, etc. Really makes it a step above other tools in terms of the power and flexibility you can have with it. 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.
- wanderingmind 3y agoWould love to learn how you installed these plugins and tested them. Have you written about this somewhere or can you point to some resources that can help people like me, who use dbeaver but can't customize them well.
- zmmmmm 3y agoIt's straighforward - it doesn't have the Eclipse Marketplace installed so you have to use direct installation, which just means you have to find the plugin site yourself, which is usually on the web site or github page for the plugin. 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 just go from there.
- anotherevan 3y agoI've used Vrapper with Eclipse for years, and I've used Dbeaver for years - yet it has never entered my mind before that I could use Vrapper with Dbeaver! Thanks!
- fuzztester 3y agoWhy start your comment by saying "I know probably 95% of HN will see it as a downside but"? 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.
- deergomoo 3y agoI’m sure some other clients do this too, but one of my favourite DBeaver features is that it will display geospatial column values in an embedded OpenStreetMap pane.
- mvexel 3y agoThis is what keeps me coming back to DBeaver as well. I don't know of any other clients that support display of PostGIS geometry types.
- frankbreetz 3y agoDoes DBeaver have a feature similar to PGAdmin's schema diff(https://www.pgadmin.org/docs/pgadmin4/development/schema_diff.html https://www.pgadmin.org/docs/pgadmin4/development/schema_dif...)? I use this feature quite a bit, if DBeaver has a similar feature. I might try to make the jump.
- paulryanrogers 3y agoYes but not in the community version: https://github.com/dbeaver/dbeaver/wiki/Schema-compare https://github.com/dbeaver/dbeaver/wiki/Schema-compare
- sgarland 3y agoIt’s fine, but I maintain that spending a day or three learning SQL will pay dividends far beyond your initial time investment. 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.
- Glyptodon 3y agoI'm not sure what all is out there these days, but have long found DBeaver a more convenient tool for day to day stuff than pgAdmin though it's certainly not beautiful. What's making it get voted up today?
- Nydhal 3y agoIt's September.
- wood-porch 3y agoEh honestly I found it super cumbersome to use after coming from Sequel Pro (mysql), never really found a better alternative for Postgres though. Perhaps I would use Navicat
- sumedh 3y ago> Perhaps I would use Navicat 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
- interbased 3y agoI mainly use Postico but I’ve noticed coworkers using DBeaver. I like how the tabs are named whereas in Postico I have to leave comments at the top of the query for later. I had to use DBeaver to access a non-Postgres database. I may end up trying it out as my primary tool for a bit.
- 20kleagues 3y agoI absolutely love Postico. For postgres, there really is no comparison for a Mac native db client. DBeaver seems so clunky in comparison, but I use that for everything non postgres.
- s_trumpet 3y agoDBeaver is somewhat clunky, yes, but for me that's a minor downside since it acts as a Swiss army knife, regardless of what DB I'm trying to access. That saves cognitive load from having to learn multiple tools. Pretty much anything with a JDBC driver is fair game. It being cross platform is a big boon as well since I use all 3 major OS fairly regularly - Mac at work, Windows and Linux at home.
- irjustin 3y agoDBeaver is great, but it's so heavy/clunky on OSX. Also, 99% of the time I want 1. tables+data 2. data structure+index of table 3. search 4. sql query 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".
- mixmastamyk 3y agoThere’s an option, simple view on connection or something, that eliminates much of the hierarchy.
- irjustin 3y agoOH WOW. This makes it significantly more usable. Thanks for it! 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.
- rs_rs_rs_rs_rs 3y agoYeah, to me TablePlus feels much better to use than anything else honestly, even if it's not open source.
- wildrhythms 3y agoOn Mac OS I use Sequel Ace for MariaDB/MySQL, it's a spiritual successor to Sequel Pro. Native UI. Works great. https://sequel-ace.com/ https://sequel-ace.com/
- aldousd666 3y agoThis tool is my daily driver for all database stuff I touch. My only complaint is that the update dialog is quite a noisy nag. But that's not a real problem.
- pritambarhate 3y agoI use it regularly for accessing PostgreSQL, MySQL and SQLight. Very happy so far. It’s regularly updated also.
- konzhi 3y agoI only wish that I don't have to re-install my plugins each time dbeaver gets update
- gorm 3y agoIt's a great client and used it for years. But I have some issues. Sometimes the cursor disappear and ctrl-enter stops working. Anyone experienced something similar and know what it could be? I run on a rather minimalistic UI environment and might lack some desktop festures.
- mulmen 3y agoYep, same. A recent update introduced a bug where the entire editor window contents disappear on a diagonal. No idea why. Sometimes adding a newline foxes it, sometimes it doesn’t.
- thih9 3y agoAs much as I want to like it, having used both this and free version of postico for a couple of months I overwhelmingly prefer the latter.
- pragnesh 3y agohttps://dbgate.org/ https://dbgate.org/ is also great db client
- puika 3y agoI love dbeaver, but there's a thing that bugs me every single time. I constantly recreate databases during development, so I have to disconnect databases, then connect, then go dig inside the database tree to where I was before recreating. Am I missing some feature I don't know about?
- HelloNurse 3y agoMaybe improve your organization of database connections into folders to dig more easily?
- Gnarl 3y agoWorst UI experience. Prefer SQuirreL. Personal opinion.
- samuelec 3y agoI have been using it for 3 years with Postgresql and it still buggy. When the db is throwing out an error dbeaver just say that there was an error on line xx followed by java exception stactrace forcing me to login into the db via command line and figure out what is wrong myself. If you want to write and debug a stored procedure then good luck! The ui had many issues and only recently seems to be just usable. At least with Postgresql, I can't really recommend for anything too complex.
- ajsnigrutin 3y agoFor me it's buggy when it has to reconnect to something... eg. i work on something, close the laptop (suspend to mem), and the next day open it up, wait for an hour or two doing other stuff (so there's enough time to notice that the tcp session is down), and dbeaver shows a progress bar and gets stuck there, until i restart it, and click a zillion times to get to the proper psql table. Also, the annoying 'new version,...' popups are annoying. Otherwise, a great gui.
- dicknuckle 3y agoAgreed, I've had mostly the same experience. There was about a month where I wasn't able to run a particular query on Oracle SQL but that's fixed now.
- johnchristopher 3y ago> Also, the annoying 'new version,...' popups are annoying. And the weird wording when you finish restoring a database with the button "next" highlighted, asking for one more ride.
- saikatsg 3y agoThere is a fix regarding connectivity as per the latest release notes: https://dbeaver.io/2024/03/03/dbeaver-24-0-0/ https://dbeaver.io/2024/03/03/dbeaver-24-0-0/ > Connectivity: closing timeout for an idle connection was increased and disabled for embedded
- deleted 3y ago[deleted]
- dikaio 3y agoWhich the team that created kaleidoscope would create a database app.
- dveeden2 3y agoThe viewer for geospatial data is much better than most other GUI clients (and CLI clients are often not very useful for geospatial data).
- overtomanu 3y agoList of db clients I have bookmarked https://dbeaver.io/ https://dbeaver.io/ https://plugins.jetbrains.com/plugin/1800-database-navigator https://plugins.jetbrains.com/plugin/1800-database-navigator https://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html https://www.oracle.com/technetwork/developer-tools/sql-devel... http://squirrel-sql.sourceforge.net/ http://squirrel-sql.sourceforge.net/ https://dbgate.org/screenshots/ https://dbgate.org/screenshots/ TUIs: https://harlequin.sh/ https://harlequin.sh/ https://terminaltrove.com/gobang/ https://terminaltrove.com/gobang/ Not free: https://www.jetbrains.com/datagrip/ https://www.jetbrains.com/datagrip/
- troyvit 3y agoI'll add: CLIs: https://www.mycli.net/ https://www.mycli.net/ https://www.pgcli.com/ https://www.pgcli.com/
- KronisLV 3y agoSome other tools I have also enjoyed: DBVisualizer: https://www.dbvis.com/ https://www.dbvis.com/ (for exploring the schema) Jailer: https://wisser.github.io/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.
- irq-1 3y agohttps://plugins.jetbrains.com/plugin/1800-database-navigator https://plugins.jetbrains.com/plugin/1800-database-navigator This looks good. Anyone have experience with it?
- diseasedyak 3y agoI work primarily with Teradata, and prefer Toad over DBeaver. I've tried to use DBeaver but for some reason when creating objects or performing DML, it looks like the command successfully completed when it actually did not. Perhaps I'm doing something wrong...
- yurytom 3y agoDBeaver is a great free tool. I use it for Postgres.
- Kerbonut 3y agoThrowing another one out there… Azure Data Studio is finally matured and has extensions for MySQL and PostgreSQL.
- LunaSea 3y agoLike most Java software, it's incredibly memory hungry.
- lovestaco 3y agoI use Adminer, very minimal https://github.com/vrana/adminer https://github.com/vrana/adminer
- WeMoveOn 3y agothe different formats you can export data out in is pretty great, especially the export sql option.