Presented by:

Ns

Nico Schlebusch

Slash IT Systems, Apace Systems
No video of the event yet, sorry!

DBeaver as an alternative to pgAdmin III

DBeaver is free universal SQL client/database tool for developers and database administrators. It can work with any database server which has a JDBC or ODBC driver.

DBeaver provide some functionality that is really missing in pgAdmin in my opinion: - ER diagram builder/editor - Data type presentation choices

Highlights (Key differences that make it worthwile)

  • filtering of data
  • changing of db's
  • Display epoch values as readable timestamps
  • Define which field to display when filtering on foreign keys
  • Generate SQL statements from existing rows
  • Copy data as JSON, HTML, etc

Shortcut keys

  • Alt-Up/Down to jump between queries
  • Query results in a new page/view - Ctrl-\
  • Queries are separated by delimiters or an empty line
  • Ctrl-Shift-E = Execution plan

Features

  • Database schema browser
  • Metadata editor (tables, columns, keys, indexes)
  • SQL statements/scripts execution
  • SQL highlighting
  • Auto completion
  • Formatting
  • Result set/table view/edit/search
  • BLOB/CLOB view/edit support
  • Scrollable result sets
  • Transactions management
  • ER diagrams
  • Server sessions management
  • Transaction locks management
  • SSH/SOCKS support
  • Mock data generator
  • Stored procedures debugger
  • Data import/export/migration

Date:
2019 October 8 13:20
Duration:
20 min
Room:
Marathon
Conference:
South Africa 2019
Language:
Track:
Ops and Administration
Difficulty:
Easy