RedditFavorites
Products Services VPNs Android apps Subreddits

What are /r/dbeaver's favorite Products & Services?
From 3.5 billion Reddit comments

Services

The most popular Services mentioned in /r/dbeaver:

#1

DBeaver

18 /r/dbeaver comments

The most popular reviews in /r/dbeaver:

YoYo-Pete · /r/dbeaver
1 point
·
31st Aug 2020

Posted on 2020-08-30 by Serge

Major changes since 7.1:

  • Simplified database structure view was added
  • Database maintenance tools can be saved as tasks now
  • Table and schema size statistics were added in the database navigator
  • Import from multiple CSV files was added. Files can be imported into new or existing tables
  • Many problems with UI freeze on disconnect or query cancel were fixed
  • Database navigator rendering was redesigned
  • A number of problems with keyboard shortcuts were fixed
  • Git integration was improved: now we show file status in the Project Explorer view
  • New database drivers were added: YugabyteDB and SQreamDB

Changes since 7.1.5:

  • Problem with database list load was fixed (PostgreSQL, Redshift, MySQL, Oracle, SQL Server)
  • Metadata editor: edit property form rendering was improved (non-applicable fields are hidden)
  • Performance for table statistics reading was improved
  • Data viewer:
    • Column ordering was fixed (for custom SQL queries)
    • UUID transform: version 2 support was added
  • Default database name and default user name were added for many database drivers
  • Data export: custom data type formatting support was fixed
  • PostgreSQL:
    • Cursor fetch was fixed
    • Native client was upgraded to version 12
    • Table OID support was fixed (PG 12)
    • PgPass parser was improved (support for escaped characters was added)
  • Oracle:
    • Materialized view comment editor was fixed
    • View definition reading was fixed (for non-DBA users)
    • Table reading now uses DBA views (optional)
    • Profile resources metadata reading was fixed
  • MariaDB/MySQL: table column resolving was fixed
  • CockroachDB: connectivity problem was fixed
  • Greenplum:
    • Metadata search was fixed (for procedures)
    • Table metadata reading was fixed
  • Dark theme support was improved (tab folders, toolbars)
  • A large number of minor UI bugfixes
YoYo-Pete · /r/dbeaver
1 point
·
16th Jul 2020

Thanks bud... Few things:

If you want to tag someone on reddit, you use /u/{username} like this: /u/pantshirtshoes

DBeaver has nice dark themes and other colorings. Try seeing what you like. Code coloring means things so find the theme that you enjoy looking at. :)

As for your problem, I cant reproduce it. I walked through all my settings. I dicked around for over an hour here and I'm stumped. You might try asking on https://dbeaver.io/ as the developer and folks can sound off.

YoYo-Pete · /r/dbeaver
1 point
·
14th Jul 2020

DBeaver 7.1.2

Posted on 2020-07-05 by Serge

  • Data viewer:
    • Now we refresh entire row after cell value update (handy if you have triggers)
    • Generate SQL context menu was fixed
    • Horizontal scroll with mouse wheel support was added
    • Export data in source code (PHP arrays) format was added
    • Bug with Ctrl+Backspace handler was fixed
  • SQL Editor:
    • Query cancel handler was improved (problem with UI stuck was fixed)
    • Now we show query information in the result tab tooltip
    • Query parser was fixed (active query extraction for Ctrl+Enter action)
    • Template variables (${word_selection} and ${line_selection}) support was fixed
  • Navigator:
    • Icons for “Create object” actions were fixed
    • Main menu File items were reordered
    • Heading and trailing spaces trim was added to all edit dialogs/panels
  • Session manager: problem with multiple windows was fixed
  • SQL Server: Database tools (index rebuild, triggers disable) were redesigned
  • Firebird: new table and table column creation was fixed
  • PostgreSQL: Table partition DDL was fixed
  • MySQL: CHECK constraints edit support was added
  • Oracle:
    • Table statistics read was fixed
    • Schema indexes folder was added
    • Check constraints editor was added
    • Trigger status icon was fixed
  • Exasol: (thanks to u/Sargul)
    • Metadata read performance was improved
    • Metadata search support was added
    • Table references
    • Index create DDL was fixed
    • Table statistics read performance was improved
  • Redshift: driver download was fixed
  • SQreamDB driver was added
  • YugabyteDB driver was added
  • We upgraded Eclipse platform version to 2020-06. It affects dark theme and General preferences and fixes several minor bugs
YoYo-Pete · /r/dbeaver
1 point
·
6th Apr 2020

DBeaver 7.0.2

Posted on 2020-04-05 by Serge

  • Database navigator:
    • Simplified database structure view was added
    • Navigator view settings and presets were added
  • Object editor:
    • Context menu was added to the object breadcrumbs
    • Object alter script now can be opened in SQL editor
  • Data editor:
    • Preference and data format changes now applying immediately (without data refresh)
    • Scrollbar position reset in columns reorder/filtering was fixed
    • Number of selected rows/columns/cells now shown in the status bar
    • Query filter history save/load was fixed
    • Floating point numbers (4-byte precision) rendering was fixed
  • SQL Editor: quick search tool was added (ctrl+alt+shift+f)
  • Driver copy was fixed (problem with read-only URL)
  • PostgreSQL:
    • PGPASS support was fixed
    • Database information (ctype, collate) reading was fixed
    • Problems with default database change were fixed
    • OID types rendering fix
    • Domain metadata reading was fixed (base type qualified name)
    • Extra options were added to database backup/restore wizards
  • Redshift: data type resolution was fixed (array types)
  • SQL Server:
    • Driver download and “reset to default” was fixed
    • Default schema detection was added
    • Problems with read-only query results were fixed
    • Column comments edit was fixed
  • MySQL:
    • Permission editor was fixed (schema privileges)
    • Index rename support was added
  • Exasol:
    • Security tree (Exasol 7) was fixed
    • Auto-completion for builtin functions was added
    • Foreign keys metadata was fixed
  • Oracle: “drop procedure” support was fixed
  • SAP HANA: driver download was fixed
  • Firebird: driver version was upgraded (4.0)
  • Many other minor bug fixes
YoYo-Pete · /r/dbeaver
1 point
·
24th Mar 2020

DBeaver 7.0.1

Posted on 2020-03-22 by Serge

  • Data viewer:
    • Search/replace in selected rows support was added
    • Problem with Find/Replace and scrolling was fixed
    • Floating point numbers rendering/copying was fixed (precision fix)
  • SQL editor:
    • Connection initialization was fixed (active schema set)
    • Auto-completion for DROP/ALTER procedure/function was added
    • Auto-completion for asterisk (*) was fixed
    • Auto-completion for table aliases was disabled
    • Auto sync with database navigator was fixed (proper catalog/schema change)
  • ERD viewer: table resize support was added
  • Query manager: full query text view was fixed
  • Connections invalidate was fixed (redundant connections open) and invalidate performance was improved
  • Schema compare (simple):
    • Compare progress visualization was fixed
    • Stored procedures body compare was fixed
  • SSH tunnel: default user name (current OS user) is used when user name not set
  • PostgreSQL:
    • PGPASS authentication was added
    • Unique key indexes visibility was fixed
    • Schema permissions viewer/editor was added
    • Function/procedure create dialog was fixed
    • Options for tables/functions DDL viewer now saved
    • Enum values editor was added
    • Array values copy-paste was fixed
  • Oracle:
    • Automatic driver download was added
    • View constraints create/drop support was added
  • DB2 LUW:
    • Automatic driver download was added
    • Table references read was fixed
  • SQL Server:
    • Driver download (native artifacts) was fixed
    • Custom SQL query result editor was fixed
    • Schema selector (main toolbar) was fixed
  • SQLite: column rename support was added
  • Snap package was significantly improved (thanks to u/galgalesh)
  • Many other minor bug fixes
YoYo-Pete · /r/dbeaver
1 point
·
3rd Feb 2020

DBeaver 6.3.4

Posted on 2020-02-02 by Serge

  • Active database/schema selector behavior was significantly improved
  • Smart commit mode was enhanced:
    • Switching to auto-commit after the end of transaction
    • Smart commit for table editors
    • Transactions preference page was added
  • Data transfer:
    • CSV export parameters (quote mode) were added
    • Add/remove table to existing data transfer task was fixed
  • SQL editor:
    • “Select all rows” query generation was fixed
    • Read data in console now uses correct default schema
    • Data viewer:
      • Show boolean values as checkboxes (configurable)
      • Row colors customization was fixed
    • Connection editor:
      • Multiple connection editor dialogs can be opened now
      • Extra variables were introduced, config UI was improved
    • Apache Phoenix:
      • Driver version was updated
      • Schema-less tables read was fixed
      • Index create support was added
      • SQL autocomplete was fixed
    • Exasol: metadata editor was significantly improved
    • Neo4j: complex data types (structs/arrays) support was fixed
    • Snowflake: index editor was fixed, view editor was fixed
    • PostgreSQL:
      • Backup for selected tables was fixed
      • Execute script on the selected database was fixed
    • Greenplum 6.x: table DDL was fixed
    • Oracle: PL/SQL parser was fixed (code blocks)
    • A lot of minor bugfixes
YoYo-Pete · /r/dbeaver
1 point
·
23rd Jan 2020

DBeaver 6.3.3

Posted on 2020-01-19 by Serge

  • Tasks:
    • SQL script execute task was added
    • Variables support was added
    • Grouping of tasks by project/type was added
    • Active database/schema now saved for custom SQL queries
    • Target table mapping was fixed for database-to-database data transfer
  • Data viewer:
    • Column filter UI was improved (multi-value select, value search)
    • Null XML columns support was fixed
    • Column value transformations and coloring was fixed
    • Context menu was improved (layout was change, missing commands were added)
    • Problem with missing toolbar actions was fixed
    • Hex editor coloring was improved, dark theme support was added
  • SQL editor:
    • Auto-complete now respects active schema
    • Database output read was fixed (async mode)
    • Hyperlinks and object navigation were fixed
    • Aliases generation algorithm was improved
  • PostgreSQL:
    • Database restore task was fixed (target database)
    • SQL parser was fixed (BEGIN/END keywords)
  • Oracle: procedures/views source code editor was fixed
  • MySQL: database restore log level config was fixed
  • Netezza: views and procedures source extraction was fixed
  • Hive: view editor was fixed
  • Neo4j: arrays support was fixed, SQL parser was fixed
  • Metadata editor: current database detection was fixed
  • Tooltips for database navigator were improved
  • Variables in connection parameters now enabled by default
  • Connection type permissions save was fixed
  • Dark theme support was improved in the main toolbar and in different dialogs
  • SSH agents support was fixed (now we use ssh-agent on Linux)
  • SSH + private key + password: configuration dialog was fixed
  • A lot of minor bugfixes
YoYo-Pete · /r/dbeaver
1 point
·
6th Jan 2020

DBeaver 6.3.2

Posted on 2020-01-05 by Serge

  • Database backup/restore/sql tools (PostgreSQL, MySQL, Oracle) now can be saved as tasks
  • Smart auto-commit mode was introduced (enable transactions vefore data modifying query execute)
  • SQL editor:
    • Alias generation was improved
    • Output log flush eas fixed
    • Default database assign (for SQL script) was fixed
  • Data editor: advances paste now respects NULLs for dates and numbers
  • PostgreSQL:
    • $$ strings parser was fixed
    • Domain type arrays support was fixed
  • DB2 (iSeries, z/OS): new connection issue was fixed
  • Oracle: session manager now shows servr-side execution plans (thanks to u/SergDzh)
  • MySQL: database backup/restore was fixed
  • Firebird: unique key DDL was fixed
  • Number of fixes and improvements in backup/restore tools
  • Workspace switch: last chosen workspace is now saved between app restarts
  • Dark theme support was improved (toolbars, dark colors customization)
  • Eclipse 4.6 support was fixed
  • Problem with missing toolbar buttons was fixed (Linux)
  • A lot of minor bugfixes
YoYo-Pete · /r/dbeaver
1 point
·
6th Dec 2019

DBeaver 6.3.0

Posted on 2019-12-01 by Serge

  • SSH Agent support was added (pageant and ssh-agent)
  • Disconnect project/folder/all actions were reworked
  • Problem with connection properties save was fixed
  • Connection properties dialogs UI was improved (test connection, password save, pref page search)
  • Task management UI was improved (task create/save actions in data transfer wizard)
  • ER diagrams: dummy errors are now suppressed (now they present in log file only)
  • Legacy Eclipse plugins installation support was added (with hold update site format)
  • Dark theme support was significantly improved
  • Auto-commit mode behavior change:
    • Toolbar toggle now affects current connection only
    • Mode change affects active DBeaver session only
  • Data export:
    • Export from SQL script now supports commands (@set and others)
    • Saved settings loading was fixed
    • XLSX exporter now respects export configuration
  • Data editor:
    • Fetch size can be changed before query execute
    • Spatial viewer now supports different pluggable tiles (mapbox, osm, etc)
    • Wrong date/time format now treated as error
  • SQL Editor: editor layout now saved between DBeaver sessions
  • Object editor (tables, views, etc) now checks for object name duplicates
  • Oracle: now we use full type name presentation by default
  • PostgreSQL: support of extra type aliases and array data types was added
  • CockroachDB: native CDB data types were added
  • Impala: active schema change support was added
  • A lot of minor UI/DB-specific bug fixes
YoYo-Pete · /r/dbeaver
1 point
·
4th Nov 2019

DBeaver 6.2.4

Posted on 2019-11-03 by Serge

  • SQL editor:
    • Select row count from custom query was fixed (ORDER BY now allowed)
    • Parameters/variable binding was fixed
    • Export from query with parameters was fixed
    • Number of improvements in intellisense algorithms
  • Data viewer:
    • Smooth scrolling mode was added
    • Number of fixes in floating point numbers handling
    • Option for short/fully qualified table names in SQL script was added
    • Grid state save/restore (after ordering/filter apply) was fixed
    • Tabs pin + drag-n-drop behavior was fixed
  • Tables navigation was fixed (filter value refresh)
  • Query manager: query ordering/refresh was fixed
  • ERD: problem with broken layout after config change was fixed
  • CSV export: row separator config was added
  • PostgreSQL:
    • $$ delimiters handle was fixed
    • Function parameters default value reading was fixed
  • Oracle: table column comments save was fixed
  • SQL Server: functions and synonyms support was added in object search
  • Java version in Windows ad MacOS installers was upgraded to OpenJDK 11.0.5
  • A lot of other minor UI fixes
YoYo-Pete · /r/dbeaver
1 point
·
29th Oct 2019

DBeaver 6.2.3

Posted on 2019-10-21 by Serge

  • SQL Editor: parameters binding dialog improvements (value preview)
  • Data viewer:
    • Result tabs drag-n-drop support was added
    • Spatial data viewer was fixed (tooltips generator)
  • Task editor: add/remove tables for existing task was fixed
  • Virtual foreign keys support was fixed (table rename support)
  • Oracle: Q-style quoting support was added
  • PostgreSQL:
    • Foreign Data Wrappers configurator wizard was added
    • $$-quote support was fixed
    • Dependencies info reading was fixed (PG12)
    • Function signature generator was fixed (FQ type names)
  • MySQL: column autoincrement flag editor was fixed
  • Elasticsearch: driver version was updated
  • Windows: app crash problem was fixed
  • MacOS: app notarization added for all distributions
  • Eclipse plugin: create .dbeaver folder on demand
  • A lot of minor UI fixes
YoYo-Pete · /r/dbeaver
1 point
·
24th Sep 2019

DBeaver 6.2.1

Posted on 2019-09-22 by Serge

Release notes:

  • Data viewer:
    • Spatial (GIS) presentation improved (tooltips, different shape colors for different columns)
    • JSON render performance was significantly improved
    • XML value viewer was fixed (proper error handle)
    • XML auto-formatting was fixed (extra whitespaces)
    • Context menu “Navigate” was added (returned)
    • Floating numbers representation was fixed (exponential view)
    • Columns transformation settings dialog was fixed
  • SQL Editor: update row count calculation was fixed
  • MySQL: date/time formatting was fixed
  • PostgreSQL: 3D geometry columns render was fixed
  • SQL Server: problem with identifiers with “go” characters was fixed
  • Oracle: SQL parser was fixed (CASE WHEN ELSE END)
  • Connection settings:
    • Load multiple data-sources*.json files
    • Respect preference changes (timeouts and other) in “Test Connection” dialog.
    • Project export/import wizard was fixed
  • Database metadata search wizard was fixed
  • New database drivers:
    • H2GIS
    • Kognitio
    • Opendistro (Elasticsearch)
  • A lot of other minor UI bugs were fixed
YoYo-Pete · /r/dbeaver
1 point
·
10th Sep 2019

DBeaver 6.2

Posted on 2019-09-08 by Serge

  • Data viewer:
    • JSON highlighting/formatting was added
    • Select/deselect rows with alt+click was improved
    • Reference panel now supports virtual foreign keys
    • “Set to default value” action was fixed (for timestamp columns)
    • Dictionary read was fixed
  • ERD:
    • Table/schema diagram edit is now supported
    • Virtual foreign keys support was added
  • Database navigator:
    • Transactions tracking was improved (+now commit/rollback actions are always active)
    • Cross-project connections copy-paste and drag-n-drop was fixed
    • Navigator tree state save (and restore on restart) was added (thanks to loro2)
    • Columns reordering was fixed
    • Global filters configuration was fixed
    • Connection permissions are now supported in connection type (prod, dev, test)
  • SQL editor:
    • Query execution time logging was fixed
    • Generate SQL dialog was improved (FQ names, copy to clipboard)
    • Script selector panel UI was fixed
    • Variables binding now can be skipped for a query/script
    • JDBC fetch size now set for custom SQL queries
  • Data export now reuses SQL editor connection
  • Metadata editor: columns drop was fixed
  • SQL Server:
    • NVARCHAR/NCHAR length calculation was fixed
    • Column default value edit support was added
    • DDL for TEXT/NTEXT data types was fixed
  • PostgreSQL:
    • Driver now uses URL template (by default)
    • Column comments for new tables now saved properly
  • SQL Server Data Warehouse support was added
  • MySQL: bit stream data type support was fixed
  • CockroachDB: table metadata read was fixed
  • Apache Derby driver was upgraded
  • Teradata: multiple resultsets support was added
  • Test connection dialog was redesigned
  • Driver libraries cache was fixed (re-download of Maven artifacts)
  • Widows registry reading was fixed (Java 8 compatibility)
  • Many other minor bugs were fixed