Squirrel: Universal SQL, NoSQL client

If you need to use multiple databases in your work, and you don't want to switch between multiple clients. Then you need to find a client tool that supports multiple databases. If you want to connect multiple relational databases, you can use Navicat Premium. But if you are using NoSQL (such as HBase, MongoDB, etc.), it is recommended to use the Squirrel SQL Client.

1. Installation

: http://squirrel-sql.sourceforge.net/

Installation: Java–jar Squirrel.jar

During the installation process, you can select the relevant plug-in:

2. Configuring Database connections

In Java, the way to get a connection using JDBC is:

= = = ="";D rivermanager.getconnection (Url,username,password); 

So when you use squirrel to connect to a database, you only need to configure the driver class, as well as the URL, username, password.

Before configuring, place the database driver in the ${squirrel_home}/lib directory . Then open the squirrel configuration related driver, connection.

Configuration driver

Configuration drivers are actually configuration driverclassname. The specific actions are:

driver>[+] # > Configuration driver. The following is a built-in MySQL-driven configuration.

Only name, classname, must be configured.

Configure the connection

Configuring the connection is actually the configuration URL, username, password. URL is required, username, password is determined by the password of the database. When you configure a connection, you specify which driver it uses.

If there is a use to a different MySQL database case. You can configure multiple connections, which can be shared by a single database driver. The following is a database connection that is configured to be available:

The configuration is complete and can be connected to use.

When using HBase, if you also use Phoenix, you can use squirrel to configure the Phoenix driver to access the HBase database:

Configure the connection and use the driver:

You can then access the data in HBase.

Squirrel: Universal SQL, NoSQL client