Squirrel: Universal SQL, NoSQL client

Source: Internet
Author: User
Tags sql 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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.