10 Open Source database management tools __ Database

Source: Internet
Author: User
Tags sql client sqlite sqlite database mysql database sqlite manager heidisql
Summary:工欲善其事, its prerequisite. When developers develop a project, they must choose a suitable database, and the database management tool can help developers easily solve many problems.

Any web software and applications need a strong database to support, currently, there are countless database management tools online, and developers choose a suitable for their own is particularly important. This article introduces developers to 10 free database management tools that developers can use for SQL operations, multi-link, multi-database engine operations, and more.

1.Open Keyval


Open Keyval is an open source free key-value database management tool, Web-based and PHP-based, with the goal of managing Web application data in the simplest way. A user simply sends a POST request to store any type of data that responds to the request in JSON format.

2.DBV


DBV, as its name implies, is the database versioning tool, based on PHP development. After the user installs, it can automatically track records, and users can also export these records as SQL files. MySQL database automatically supports DBV by default and allows multiple users to connect.

3.DBeaver


Dbeaver is a common database management tool and SQL client that supports MySQL, PostgreSQL, Oracle, DB2, MSSQL, Sybase, Mimer, HSQLDB, Derby, and other JDBC-compliant databases. Java-based development. Dbeaver provides a graphical interface for viewing the database structure, executing SQL queries and scripts, browsing and exporting data, processing BLOB/CLOB data, modifying the database structure, and more.

4.DBNinja


Dbninja is a web-based MySQL database management tool that uses PHP to develop a desktop-like interface to connect multiple remote and local databases. It supports all the new features including: Triggers, events, views, stored programs, and foreign keys.

5.MyWebSQL


Mywebsql is a web-based MySQL database management client that supports multiple languages. In addition to manipulating tabular data, Mywebsql can control objects including views, stored procedures, triggers, and functions. Supports import \ Export of data and query results. The Mywebsql also includes a SQL editor with syntax coloring.

6.Genghis


Genghis claims to be a single-file MongoDB management application that efficiently manages multiple databases and even servers that help users gather and manage databases and documents.

7.MyDB Studio


MyDB Studio is a free MySQL database management program that almost has all the features you expect. It can connect any number of databases with no limit at the same time. If these databases are behind a firewall or they are local databases, the tool also provides support for SSH channel access to address these issues.

8.HeidiSQL


Heidisql is a Windows-based database management software that means it can manage Microsoft SQL database and MySQL. It's a powerful feature that lets you browse and edit data, create and edit tables, views, stored procedures, triggers, and schedule schedules. In addition, you can export structure and data SQL files.

It is an open source tool developed by German programmers Ansgar Becker and several Delphi programmers. To manage the database through Heidisql, users should log on to the MySQL server with valid credentials and create a session. Heidisql's biggest feature is ease of operation, reasonable interface design, functions are the most practical, especially for DBAs, it emphasizes the MySQL runtime parameters and performance monitoring.

9.SQLite Manager


SQLite Manager is an open source SQLite management tool that manages the SQLite database on your local computer, runs independently (in XULRunner mode), or as Firefox, Thunderbird, Seamonkey, Songbird, Komodo, Gecko and other plug-ins run.

10.sequel.js


Sequel.js is a lightweight JavaScript library that makes it easy to make SQL queries that can be run either on a browser or on all standard SQL queries.

From: Best Design tuts

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.