Search menu provides options to search among files, database objects and across data. Navigate menu allows navigating through scripts and database objects. The DBeaver window contains a menu bar, a toolbar, a shortcut bar, a workspace with one or more editors and views, and a status bar:īy default, the menu bar contains the following menus:įile menu contains menu items for the creation of files, folders, projects, database connections, database projects, and ER diagrams as well as Import and Export items.Įdit menu contains global commands like Cut, Copy, Paste, and Delete targeted at the active element. You can now create, run and view the results of your query in this window. If you want to try your hand at writing your own SQL queries, you can do that by clicking on the SQL Editor button. You can quickly view and edit the data in a table by right-clicking on the table and selecting view data. You are ready to start exploring the northwind database running on a distributed SQL backend using DBeaver.īy expanding out northwind > schemas > public > tables you can quickly visualize all the tables in the northwind database. Working with the Northwind Sample Database Just like a regular PostgreSQL server, password authentication for the postgres user is disabled, and hence no password should be specified.It’s always a good idea to test the connection before proceeding.Īfter the connection is setup you should be able to explore YugaByte DB (aka “PostgreSQL – northwind”) using the database navigator as shown below: You will need to change the port assignment from the default 5432 to 5433. If it is a fresh install, DBeaver will walk you through a wizard to get your connection set up like shown below.įor the purposes of this how-to, I’ve selected the northwind sample database. Once you are installed, let’s launch DBeaver and configure a connection to YugaBye DB. In this blog, we are installing DBeaver community edition version 6.1.3 using the Mac OS X pkg installer + JRE. DBeaver comes in two editions – Community and Enterprise. Please note that for the purposes of this blog post we’ll be focused on getting up and running on a Mac, but DBeaver supports all the major operating platforms.įirst thing to do is download the latest version of DBeaver. The instructions for how to get up and running in just a few minutes can be found in our previous blog post, “The Northwind PostgreSQL Sample Database Running on a Distributed SQL Database.” For the purposes of this blog post we’ll be using the northwind sample database. It is written in Java, and supports a variety of databases including MySQL, PostgreSQL, MariaDB, and even YugaByte DB! In addition to the databases mentioned, there are plugins and extensions for many other data products that support the JDBC driver.In a nutshell, DBeaver gives you all the must-have features that is expected from any database GUI tool including:ĭBeaver is spontaneous and there are a lot of helpful tips that can aid you in configuring and discovering your database flawlessly.īefore we get into DBeaver, you’ll need to setup YugaByte DB and install a sample database. DBeaver is an opensource multi-platform database management tool for developers, SQL programmers, DBA’s and analysts.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |