10 Open Source database management tools __ Database

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