Top 10 open-source SQL client databases are no longer difficult to manage

Source: Internet
Author: User
Tags sql client

BKJIA exclusive Article] the SQL client is an essential tool for every developer. They help developers easily Execute SQL queries in any database. They are also very important for solving any database-related problems.

1. SQuirreL SQL Client

SQuirreL SQL Client is currently the most popular open-source SQL Client. It provides a graphical Java program that allows you to view the structure of a JDBC-compatible database, view the data in the table, SQL commands, and so on.

2. iSQL-Viewer

ISQL-Viewer is an open source JDBC compatible database 2.x client written in Java. It implements the cross-platform jdbc api function. It has everything through a single interface. The iSQL-Viewer browser is compatible with most database platforms, including PostgreSQL, MySQL, Oracle, and Informix. ISQL-Viewer provides multiple tools and functions to execute common database tasks.

3. LiquiBase

LiquiBase is an open-source LGPL database that is used to track, manage, and change the application database. It is built on a simple premise: All Database changes are stored in a readable form and can be traced to source code control checks.

4. Henplus

HenPlus is an SQL shell written in Java. JDBC provides support for any database. Therefore, it is basically supported by any database. Why do we need this? Any database comes with some shells, but they all have missing features and some shells which cannot be used at all ). If you use these databases once, if you are a developer and when you do it all, you will feel how boring it is to switch between these tools.

5. QuantumDB

QuantumDB is a simple but powerful database access plug-in based on the Eclipse development platform. QuantumDB allows you to connect to a database linked to the JDBC driver, using standard audit modes: tables, views, and sequences to find columns, indexes, and foreign key information, ad hoc query publishing or other SQL statements in the database.

  • Detailed description of the Execution Plan for capturing Oracle SQL statements
  • Use partition and load balancing to make your MySQL bigger and better
  • SQL Server data platform helps Xiamen International Bank quickly
  • Top 10 MySQL optimization skills for WEB programmers
  • Microsoft apsaradb SQL Azure is about to be released or provide PH

6. dbbrowser

DBBrowser is an open-source cross-platform tool GPL. It can be used to view the content of a database. It supports CLOBS and BLOBS. It is designed to support Oracle and MySQL. You never have to write SQL statements to view the SQL window, even the data provided by SQL. Supports ergraph object relationships), XMLTypes, and more DBMS plans are included in future versions.

7. Jackcess

Jackcess is a client written in Java only for reading and writing data to the MS Access database. This is not an application. No graphical user interface. This is a library that other developers intend to use to build Java applications.

8. SQL Workbench-J

QL Workbench-J is the front-end of an SQL database DBMS independet. It is available in batch processing mode and has powerful Export and Import capabilities. It also provides some extensions to SQL support variable replacement, with the local blob file name), and tries to process the SQL database in a unified manner. It can directly copy data in two batches and different server tables on the graphic user interface.

9. SQL Admin

SQL Admin is a Java client. Applications connect to and query different databases through JDBC. The main idea is to build a multi-platform and multi-database thin client.

10. SQLeonardo

SQLeonardo is a powerful and easy-to-use database query tool ,. When you work with SQLeonardo, it means that you do not need to understand SQL, but only need to work in the graphic environment and data in this environment, which is targeted at the standard programming language of the database.

Related Article

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.