![]() If DBeaver could sort out the biggest usability issues though, I'd definitely switch to it, as it otherwise looks excellent, particularly for an open source tool. I use it for working with Postgres, but it can be used just as well with other databases such as Oracle. There's a bunch of other small annoyances here and there (such as changing the sort order of a column not cancelling an existing running query, which causes funny results if you want to quickly sort a column in descending order), but I think I could get used to them.Īs much as I hate to recommend it, Navicat seems to have the least unusable GUI from the tools I've tried (or put more positively, it's UI is actually fairly good). DBeaver is a popular open-source SQL editor that can be used with a variety of databases. Another annoying one is that it doesn't handle disconnects/broken connections particularly well, often throwing up errors saying that the connection was lost, and the like this isn't so bad, because you can right-click the connection in the panel and use the reconnect option, but it makes me wonder why this can't be done automatically. My biggest gripe is the way it handles active databases - these have to be manually set (it can't automatically figure out the appropriate DB from context) and all query windows follow this, which means you can't have query tabs associated with different databases. DBeaver is a full management application for developing with various types of databases, not least of which is MySQL and Oracle. Unfortunately, it's UI is rather clunky in ways which makes it difficult for me recommend. In the eventuality that your line of work entails managing, sorting and editing data from multiple databases, then perhaps you should consider giving DBeaver a try.Going to give a bit of an alternative opinion from the majority here: For some reason, I just can't find a MySQL/MariaDB GUI that I completely like.ĭBeaver is really nice - supports many DBMSes, lots of options and features. It is actively maintained, and users are invited to report bugs and suggest features on the DBeaver GitHub page. Apart from MariaDB, it supports MySQL, PostgreSQL, Oracle, MS Access, MongoDB, Redis, and many more databases. Nevertheless, the developer points out that there is a chance some non-JDBC driver databases might work as well. DBeaver is a free and open source multiplatform tool for all people who work with databases. The official DBeaver website can be found at. When it comes to support, you will be happy to learn the tool works well with the vast majority of databases out there, including Apache databases, Firebird, MariaDB, DB2, OrientDB, Postgres, SQL and its variations, Teradata, Yellowbrick, NuoDB, Athena or Babelfish.Įssentially, the tool should have no issue with any database featuring a JDBC driver. Portapps is not affiliated, associated, authorized, endorsed by, or in any way officially connected with DBeaver, or any of its subsidiaries or its affiliates. Depending on your project, you can create multiple scripts that open individual SQL editors, each with their own connection and properties. The SQL editor is a feature that would be best used when making more consistent adjustments. As the name suggests, The Data editor allows you to view and edit data directly from the table you view, which makes it a great option for making small adjustments. If you want to change anything, then you can easily do so from the two main options, namely the Database Object editor or the SQL editor. ![]() Usability is the main goal of this project. The app comes with a comprehensive search function that supports metadata and full-text queries, so you should be able to access the information you need quickly. DBeaver is free and open source universal database tool for developers and database administrators. ![]() Once you load your data, you should be able to navigate the database and open them in individual workspaces where you can easily navigate the information. The program comes with a user-friendly interface, which is quite a trump card considering the nature of the app. As the tool provides a universal database management solution that enables you to analyze, filter and edit data, it may be a good choice for anyone working with multiple databases. DBeaver is a tool well-known for anyone working with data regularly. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |