#Dbeaver sql editor driver#

For example, DBeaver can use the JDBC-ODBC Bridge that used to be included in the Java distribution.

#Dbeaver sql editor driver#

To access a database by using an ODBC driver, DBeaver uses a JDBC-ODBC Bridge driver to convert between ODBC and JDBC calls. A JDBC driver implements the JDBC API for a particular database. JDBC is a Java application programming interface (API) that connects Java to relational databases (and other tabular data, such as spreadsheets and flat files). To interact with a database, a Java application uses a JDBC driver.

The ability to search database objects (tables, columns, constraints and procedures).ĭBeaver is written in Java.

The ability to browse and edit database metadata (tables, columns, keys and indexes).

The ability to use DBeaver as a remote database manager makes it easy to administer multiple databases on multiple platforms from a single location. For example, to export your query results as web page tables, right-click on the Results view in DBeaver, select Export Resultset, and then click Export to HTML.ĭBeaver can be installed either on the database server or on a remote machine. You can use DBeaver to save tables or query results in several formats such as CSV, SQL 'Insert' statements and HTML. To insert the contents of a template into the SQL editor, you simply type the template's name and press the TAB key. To save its users' time, DBeaver provides SQL templates, which are snippets of commonly used SQL code. The DBeaver SQL editor has auto completion and database-specific syntax highlighting to facilitate the creation, analysis, and debugging of complex queries. DBeaver is a database management tool and SQL client that runs on Windows, Linux, OS X and UNIX (AIX, HP-UX and Solaris) platforms.