Presented by:
Nico Schlebusch
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 11:20 SAST
- Duration:
- 20 min
- Room:
- Marathon
- Conference:
- South Africa 2019
- Language:
- Track:
- Ops and Administration
- Difficulty:
- Easy