The JPDB Admin for MariaDB
is a complete tool for managing
and developing databases MariaDB, MySQL and Percona Server. With
tool, you can, quickly, visually create tables, views, triggers and
many other structures.
The tool is multi-lingual (Chinese, English, German, Japanese,
Portuguese, Russian and Spanish) and has native distributions for
Windows and Linux GTK or QT for 32bit and 64bit.
Figure: Visual Interface - JPDB
Admin for MariaDB
Follows some of the main features that you will find in the JPDB
Admin for MariaDB
following server databases: MariaDB, MySQL and Percona Server
Are supported most of the latest features in MariaDB, MySQL and
Percona Server. Works with all versions 5.x or later these
Databases and Connections
Practical assistant to quickly create new databases.
Figure: Create Database Assistant
Assistant to manage and save new connections. Register several
local servers, remote or virtual.
Figure: Connections Assistant
This tool allows to user, through of the one "spreadsheet", easily,
create tables (including auto-increment fields, primary keys and
indexes) in a database without requiring knowledge of SQL commands.
You can develop very more, in less time.
Figure: Table Designer
The Table Designer
, also has a tab with a SQL script editor
himself and complete. Allowing customizations in the generated
Figure: "Table Designer" and tab "SQL Script Editor"
Gain access to various dialogues to facilitate the creation,
editing and deleting fields of tables, primary keys, unique keys,
foreign keys, editing table options, users and permissions.
Figure: Some Dialogues
When connecting to a database, you have quick access to the lists
of all the structures it has. There are shortcut menus throughout
to provide access to numerous features.
Figure: Tables list and properties of the selected table
In the Data Access
session, you can quickly list all data
from a table, with automatic pagination, filter, sorting,
inserting, editing, deleting, printing, export and more. Allows you
to view and edit BLOB fields and MEMO fields.
Figure: Data Access session
Query Editor and
SQL Script Editor
With the Query Editor and SQL Script Editor
you can easily
work with SQL commands and functions. This tool has syntax
highlighting, auto complete intelligent, export the SQL script to
HTML with syntax highlighting colorful, reports and other common
resources in a code editor. Performs SQL scripts e displays the
result of your queries, similar to Data Access
Figure: Query Editor and SQL Script Editor
With Visual Query Builder
you can easily create queries
against the data without writing a single line of SQL. Using
resources drag and drop, you can handle tables, relationships,
functions, sorting and grouping. Also, you can save the query model
Figure: Visual Query Builder
This assistant allows export the database for a SQL script and
saving in a file or copying to Clipboard. Allows the extraction of
all data and/or all the database structure, making it easy the
backup. This Assistant allows various configuration options.
Figure: Database Export Assistant
This assistant allows you to export data from one table to CSV,
TXT, SQL, LaTeX, ASCII XML, MSAccess XML, ADO.NET XML, Client
Dataset Delphi XML and Excel XML. You can choose the order and
which fields of the table will be exported. You can perform various
formatting settings for each type of export.
Figure: Table Export Assistant
Several reports are available for printing. For example, you can
generate reports from the tables, the results of queries, SQL
scripts, etc. The reports can be viewed and saved in a own format
or in PDF, HTML, TXT, PNG, JPG or BMP.
Figure: Ready Reports
The Tool Monitoring
allows the user to monitor the
activities of the servers databases MariaDB, MySQL and Percona
Server. Are monitored environment variables, server status, and
Figure: Tool Monitoring
Copyright © 2006-2013 Jean
Sistemas. All Rights Reserved.