Navicat, manajemen database mySQL

navicat for linux

gowa, muhyamin.com #   The Gateway to MySQL, demikian motto Navicat. Inilah aplikasi yang sangat membantu saya dalam membangun aplikasi web, khususnya dalam manajemen database MySQL. Selain itu ada juga MySQL-Front yang saling menutupi dengan Navicat.

Dari situs resminya (http://www.navicat.com) dinyatakan sebagai berikut:

Navicat MySQL is a powerful MySQL Database Server administration and development tool. It works with any MySQL version from 3.21 or above and supports most of the latest MySQL features including Trigger, Stored Procedure, Function, Event, View, Manage User, and so on. It is also not only sophisticated enough for professional developers, but also easy to learn for new users. With its well-designed Graphical User Interface(GUI), Navicat MySQL lets you quickly and easily create, organize, access and share information in a secure and easy way.

Navicat MySQL is available on three platforms – Microsoft Windows, Mac OS X and Linux. It can connect users to local/remote MySQL Server, providing several utilitarian tools such as Data/Structure Synchronization, Import/Export and Backup to facilitate the process of maintaining data. See the Feature Matrix for details or visit our web-site: http://www.navicat.com

Navicat Features:

Latest MySQL versions support

• Compatible with any MySQL server version.
• Support of Events.
• Support of Triggers.
• Support of Stored Procedures and Functions.
• Support of Views.
• VARCHAR Data Type support. Value from 0 to 65,535 in 5.0.3 and later versions.
• BIT Data Type support.
• BINARY/VARBINARY Data Type support.
• Supports Unicode / Character Set.

Well-designed user interface

• Virtual Grouping for categorizing your works.
• Further data are shown in the tree view.
• Provide better vision for users in table grid.
• Well-described Wizard System.

Powerful data management tools

• Form View support.
• Send notification e-mail for schedule task.
• Foreign Key Auto-Completion.
• Data Synchronization support.
• Structure Synchronization support.
• Support of Tables/Views/Stored Procedures/Events Backup and Restore.
• Support of Tables/View/Stored Procedures/Events Data Transfer.
• Supports Parameter Query.
• dBaseIII memo support in DBF Import Wizard.
• Run Selected in SQL editor.
• Raw mode setting allows user to view the actual data value which stored in the MySQL database.
• Manage Users.

Connection options

• Support of Private Key for SSH Tunnel.
• Provide Auto-reconnection for MySQL server.
• Supports SSL Connection.

Visual Designer

• Support Code-Completion in Query, View and Event.
• Support New Query – create a query from different databases which are within the same connection.
• Support Views in Query Builder.
• Support of Views Builder.

Additional features

• Support of setting global Row Height and Column Width in table grid.
• WordWrap for Query and View Editor.
• Provides a short-cut to terminate a running query.