Overview

JPDB Admin

Introduction

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

Basic Features

Follows some of the main features that you will find in the JPDB Admin for MariaDB:

Supports the 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 servers.

Management of 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

Table Designer

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 SQL.


Figure: "Table Designer" and tab "SQL Script Editor"

Database Object Management

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

Data Access

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 session, mentioned above.


Figure: Query Editor and SQL Script Editor

Visual Query Builder

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 built.


Figure: Visual Query Builder

Database Export Assistant

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

Table 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

Ready Reports

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

Tool Monitoring

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 running processes.


Figure: Tool Monitoring


Copyright © 2006-2013 Jean Sistemas. All Rights Reserved.