DBeaver Enterprise is a database management software that can help make it easier for you to manage your database and it supports all database applications such as; MySQL, Oracle, MariaDB, DB2, SQL Server, PostgreSQL, SQLite, Sybase, MS Access, and other database types.
For you as a web developer, this software is certainly very useful for you in managing, creating and manipulating your database, it is equipped with very complex features to make it easier for you to work so if you want you can try it.
Features of DBeaver Enterprise
Connection to various datasources
Choice of database driver from the variety of supported types. The list of drivers includes drivers for relational, document oriented, key value, time-series and other databases.
Support of user-defined connection types and creation of custom drivers an the Driver Manager
Configuration of standard (host, port, user credentials) as well as advanced connection properties:
SSH tunnel
SOCKS proxy
Shell commands to be executed before/after actual database connection
Bootstrap SQL queries executing in the database session immediately after connecting
NoSQL / BigData databases
DBeaver Enterprise has special extensions for:
MongoDB
Amazon DynamoDB
Google Bigtable
InfluxDB
Apache Cassandra
Redis
Apache Hive
All these databases have SQL interface and you can work with them as with good old relational databases.
And this is not some kind of JDBC driver abstraction – DBeaver EE supports all native data types and databases structure explorer for these databases.
All-in-one
DBeaver EE comes with all existing extensions, you don’t need to install anything else. This includes:
Office formats support
Vector graphics support
SQL debugging framework
Advanced SSH algorithms
Most of the popular database drivers are included in the distribution
A number of Eclipse extensions are included for advanced security and easy installation of 3rd party extensions using Eclipse Marketplace.
Advanced Security
Keep your databases passwords in secured storage protected by master password or use native OS password encrypted storage
Use BouncyCastle advanced security algorithms to connect over SSH or SSL
Data viewer and editor
Multiple data views to fit the variety of users’ needs, for example display of image contents (gif, png, jpeg, bmp) as an image.
Editing of data inline and in a dedicated space
Convenient navigation among data
Custom filters for table contents or query results, including filters based on cell values
Results ordering by column
Data export with all applied filters and orderings
Generation of SQL statements based on selected rows
Basic statistics for selected columns
Mock-Data Generator
You can generate random data (or “mock” data) for tables. And this data should look like the real data.
Enterprise edition includes basic and advanced data generators. Includes:
Numbers
Random strings
Names
Addresses
Credit cards
Domains and IP addresses
Custom regular expressions
Flexible numeric generators
And many more
SQL editor
Organization of scripts into folders and reassignment of database connections for particular scripts
SQL syntax highlighting determined by the database associated with a script
Support for different sets of reserved keywords and system functions for different databases
Import and export of scripts
Visual Query Builder
You may construct complex SQL queries without actual knowledge of SQL.
Make table joins/filtering/ordering visually
Open your existing SQL queries in visual mode, edit and save them – that’s easy
Execute your visually constructed query at any moment and get results on the screen
Analyze complex SQL queries visually
Browser metadata
A tree of database connections with their metadata structures down to the lowest level: tables, views, columns, indexes, procedures, triggers, storage entities (tablespaces, partitions), and security entities (users, roles).
Ability to modify most metadata entities, depending on the database driver capabilities
Display of database objects’ DDL and generation of standard SQL92 DDL according to object structure for some databases
Ability to edit/rename/delete connections and most database objects
Global and local filters, ability to filter database objects by name
Data transfer
Export of data to a file or to another database table with the option to create the destination table if it does not exist.
