How I create a database for my applications. Selecting a program for writing a database Download a database system management program

DbVisualizer 9.1.5

DbVisualizer is a database tool for developers and database administrators, helping you with both the development and maintenance of your databases.

Firebird 2.5.2

Firebird is a relational database offering many ANSI SQL standard features that runs on Linux, Windows, and a variety of Unix platforms. Firebird offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers.

Reitec.PMM 1.2.1.0

Reitec.PMM is a free tool for the management of test equipment as part of quality assurance.

WowBase 1.1

Create your own database quickly and easily.

MyContacts 3.1

Managing contacts, birthdays and dates/tasks.

LibreOffice Rus for Windows 3.6.4

Office suite LibreOffice is the best free alternative for Microsoft Office 2003, 2007 and even 2010.

PhpMyAdmin 3.5.3

phpMyAdmin Rus is a program for managing a MySQL database, which you can download and use for free - both at home and in an organization. Russian version.

Oracle MySQL for Linux, UNIX, *BSD and other *nix 5.5.28 Final / 6.0.6 Beta

Oracle MySQL - Famous database server. Famous for its impeccable stability and speed.

Oracle MySQL for Windows 5.5.28 Final / 6.0.6 Beta

MySQL is one of the most popular open source databases and is completely free to download and use.

Databases

↓ New in the category "Programs for managing and working with databases.":

Free
ProjectDB 5.0.1.2 is an application with project generation capabilities that will allow you to manage large amounts of information. The ProjectDB application was developed taking into account the work of the MS SQL Server program, and development is also underway to connect such free databases as PostgeSQL or MySQL.

Free
DBACentral for MySQL 1.8.3 is a solution similar to MS Access that allows you to perform server administration, database development, and also has the ability to perform advanced data management.

Free
FlexTracer 2.12.1.543 is a powerful tracer for SQL queries and works with various databases and functions that are exported from DLLs. The FlexTracer application will help you view the result of executing functions, execution time and their parameters.

Free
Excel-to-MySQL 2.5 is an application for converting MS Excel documents into MySQL databases. The Excel-to-MySQL application has the ability to create new MySQL databases or write to already saved or created databases.

Free
EMS MySQL Manager Pro 4.1.2.1 is an application that is a powerful and quite effective tool for administering the MySQL server and managing its objects.

Free
DegisyDb 1.0 is free library, which has 12 components to perform management and other operations with databases.

Free
dbForge Studio for MySQL 5.0.36 is a professional and free application, which will help MySQL users and database developers work more conveniently and quickly.

Free
DB Navigator for DBF 2.0.0.21 will make it possible to conveniently and simply process data in databases. The DBNavigator for DBF application allows you to perform database operations such as adding, editing and deleting tables, as well as writing, executing SQL scripts, copying entire tables or their structures.

Free
Database Workshop 5.32 is an application for working with various databases. The Database Workshop application allows you to perform professional database processing and is equipped with extensive capabilities for analyzing the databases under study.

Free
Database Tour 6.5.2.1048 is a powerful and convenient application that will do the work with databases for you. The Database Tour application works with data in various formats and will help simplify or automate the most frequently performed database operations.

Free
CDBF - DBF Viewer and Editor 2.15 is a fairly powerful editor and viewer of DBF format files, which makes it possible to perform a large number of operations with databases and without resorting to programming using the standard Windows interface.

Free
Access-to-MySQL Pro 2.5 is a quality application for converting your databases from Access format to a format such as MySQL. The Access-to-MySQL Pro application supports all MySQL data types and file attributes, and can also work with all versions of MySQL servers that run in operating systems, both Windows, Linux or Unix.

Many companies create various feature-rich applications to facilitate database management, development and administration.

Majority relational databases Data systems, with the exception of MS Access, consist of two separate components: the “back-end”, where the data is stored, and the “front-end” - the user interface for interacting with the data. This type of design is quite clever, as it parallelizes a two-layer programming model that separates the data layer from user interface and allows you to concentrate the software market directly on improving your products. This model opens the door for third parties to build their own applications to interact with different databases.

On the Internet, anyone can find many products for developing and administering MySQL databases. We decided to collect the 10 most popular tools in one article so that you can save your time.

1.Workbench

MySQL Workbench distributed under a free license - Community Edition and with an annual paid subscription - Standard Edition. The latter includes additional features, which can significantly improve the productivity of both developers and database administrators.

The cost is free.

What makes Workbench popular?

• the ability to present the database model in graphical form, as well as editing data in a table;
• the presence of a simple and functional mechanism for creating relationships between table fields, among which a “many-to-many” relationship is implemented with the ability to create a relationship table;
• the Reverse Engineering function allows you to restore the structure of tables and relationships from the one that was implemented earlier and stored on the database server;
• the presence of an SQL query editor, which makes it possible, when sent to the server, to receive a response in tabular form and other features.

2. Navicat

Second place Navicat(developed by PremiumSoft CyberTech Ltd) is a tool for developing and administering databases that runs on any MySQL server starting from version 3.21. For MySQL, Navicat is available to run on platforms Microsoft Windows, Mac OS X and Linux.

Product prices range from $199 to $379.

What makes Navicat popular?

• Availability of a visual query designer;
• the ability to import, export and backup data;
• ability to create reports;
• SSH and HTTP tunneling;
• migration and synchronization of data and structure;
• task scheduling tool and other features.

3. PHPMyAdmin

PHPMyAdmin is a free open source application designed for administering the MySQL DBMS. PHPMyAdmin is a web interface with which you can administer the MySQL server, run commands and view the contents of tables and databases through a browser.

The cost is free.

What makes PHPMyAdmin popular?

• the ability to manage the MySQL DBMS without directly entering SQL commands;
• as a control panel PHPMyAdmin provides the ability to administer dedicated databases;
• intensive development;
• the ability to integrate PHPMyAdmin into your own developments thanks to the GNU General Public License and other features.

4. dbForge Studio for MySQL

dbForge Studio for MySQL- a tool of interest to both MySQL users and database developers. With its help, you can easily automate routine work and save time. Today, dbForge Studio for MySQL is available in three editions: Express, Standard and Professional, which allows you to choose the tool that you need. You can use dbForge Studio for MySQL in both the commercial and free versions.

There are both free and paid versions, with the latter priced at $49.95 (standard edition) and $99.99 (professional edition).

What makes dbForge Studio popular?

• availability of funds for centralized administration;
• database comparison tools;
• visual query profiler;
• the ability to manage user privileges;
• availability of a Database Designer, which allows you to build visual diagrams;
• improved work with database projects and other features.

5.HeidiSQL

HeidiSQL is a free database management tool. A worthy alternative to PHPMyAdmin, which allows you to create and edit tables, views, triggers, procedures, as well as view and edit data. HeidiSQL also provides the ability to export data in both SQL file, and to the clipboard on other servers.

The cost is free.

What makes HeidiSQL popular?

• the ability to connect to the server using the command line;
• the ability to batch optimize and restore tables;
• the ability to edit columns, indexes and foreign keys of tables, edit the body and parameters of SQL procedures, triggers, etc.;
• easy formatting of unordered SQL;
• table synchronization between different databases and other features.

6. SQL Maestro for MySQL

SQL Maestro for MySQL- a tool for administration, development and management of the most popular DBMS. A convenient graphical interface makes it possible to execute SQL queries and scripts, manage user privileges, export and create backups data.

Depending on the selected license and use case, the cost of this tool ranges from $99 to $1,949.

What makes SQL Maestro for MySQL popular?

• version support MySQL servers from version 3.23;
• Availability of a database designer;
• the ability to edit, group, sort and filter data;
• visual query builder;
• SSH and HTTP tunneling;
• BLOB editor and other features.

7. EMS SQL Manager for MySQL

EMS SQL Manager for MySQL is a database development and administration tool that supports various MySQL features and works with all versions of MySQL older than 3.23. With its help, you have the ability to visually edit, import and export databases, execute SQL scripts, manage user privileges, visually design MySQL databases.

There is a paid and free version applications. The latter has a number of functional limitations. The cost of the paid version varies between 95 – 245 US dollars.

What makes EMS SQL Manager for MySQL popular?

• UTF8 data support;
• easy management of various MySQL objects;
• compatible with all versions from 3.23 to 6.0 inclusive;
• availability of graphic and text tools for generating queries;
• SSH and HTTP tunneling;
• convenient report designer and other features.

8. SQLyog

SQLyog- one of the most powerful tools that combines MySQL features Administrator, PHPMyAdmin and some other tools for database administration and development. SQLyog runs on Microsoft Windows, Windows NT platforms. and Linux using Wine.

There are both free and paid versions of SQLyog available. The paid version costs from $99 to $1,499 (varies depending on the number of users and license, with or without support).

What makes SQLyog popular?

• convenient query builder;
• possibility of data synchronization;
• Unicode support;
• SSH and HTTP, HTTPS tunneling;
• “smart” auto-shutdown;
• intelligent code completion and other features.

9. DBTools Manager

DBTools Manager- a data management application with built-in support for MySQL, PostgreSQL, MSAccess, MSSQL Server, Oracle and other databases. Supported platforms: Windows 2000, XP, Vista, 7.

DBTools Manager is available in free (Standard) and paid versions (Enterprise). Cost is $69.90 per license, with discounts available when purchasing multiple licenses.

You can learn more about and purchase DBTools Manager here

EMS Database Management Solutions offers a comprehensive suite of free programs for database management, which will allow you to increase the productivity of working with data and the efficiency of database administration. These free database management programs can help you solve most administrative tasks by providing essential functionality for database and data application developers without having to rely on multiple, multi-faceted SQL utilities.

EMS SQL Manager Freeware is suitable for both beginners and experienced developers; it will make it easy to control the data infrastructure thanks to the availability of all the necessary tools for organizing the effective functioning of database systems. Our free tools give you the ability to administer servers and develop databases, manage users and security, view and edit data, and perform a number of other tasks using one powerful application with an intuitive graphical interface.

Using EMS SQL Manager Freeware, you can work with servers, databases and schemas, view, edit, search, group, sort and filter data, create and run SQL queries using a powerful SQL editor, work with multiple selected objects simultaneously and much more .

We offer a wide range of free database administration programs for the most popular servers. EMS SQL Manager Freeware supports all server objects, database and table objects, as well as latest versions servers and functionality of the corresponding RDBMS.