Navicat

Last updated
Navicat
Original author(s) PremiumSoft CyberTech Ltd.
Developer(s) PremiumSoft CyberTech Ltd.
Initial release2002
Stable release
16 [1] / 2021-11-23
Operating system Cross-platform
Available in Multilingual
Type SQL database management and development system
License Proprietary / Shareware
Website www.navicat.com

Navicat is a series of graphical database management and development software produced by CyberTech Ltd. for MySQL, MariaDB, Redis, MongoDB, Oracle, SQLite, PostgreSQL and Microsoft SQL Server. It has an Explorer-like graphical user interface and supports multiple database connections for local and remote databases. Its design is made to meet the needs of a variety of audiences, from database administrators and programmers to various businesses/companies that serve clients and share information with partners. [2] [3]

Contents

History

The initial version of Navicat was developed by Mr. Ken Lin in 2001. The main target of the initial version was to simplify the management of MySQL installations. In 2008, Navicat for MySQL was the winner of the Hong Kong ICT 2008 Award of the Year, Best Business Grand Award and Best Business (Product) Gold Award. [4]

Supported platforms and languages

Navicat is a cross-platform tool and works on Microsoft Windows, Mac OS X and Linux platforms. Upon purchase, users are able to select a language for the software from eleven available languages: English, French, German, Spanish, Japanese, Polish, Russian, Portuguese, Korean, Simplified Chinese and Traditional Chinese.

It supports Linux platform via bundled Wine.

Versions

Standalone versions

Officially released in March 2002, the Windows version of Navicat for MySQL became the first product offered to the public by PremiumSoft. Subsequently, the company released two additional versions of Navicat for MySQL on the Mac OS X and Linux operating system in June and October 2003 respectively. In November 2013, added the support of MariaDB. [5] [6] PremiumSoft continued to expand their Navicat series by releasing Navicat for PostgreSQL for Windows in October 2005 and then for Mac OS X in June 2006. The Linux version of Navicat for PostgreSQL would not be released until 3 years later in August 2009. [7] In August 2008 Navicat decided to further continue their product line and branch out into the Oracle community, creating Navicat for Oracle for Windows and Mac. In August of the following year they followed up with a version for the Linux Platform. [8] The Oracle version of Navicat supports most of the latest Oracle objects features including Directory, Tablespace, Synonym, Materialized View, Trigger, Sequence, and Type, etc. [9] [10] Navicat for SQLite was released for Windows and Mac OS X simultaneously in April 2009, and the Linux version soon followed two months later in June of the same year. [11] In April 2010, Navicat Premium began including Navicat for SQLite starting from version 9 to expand the usability of Navicat Premium. [12] Navicat for SQL Server was released in November 2010 for the Windows platform and Mac OS X. Also at the release, the SQL server version was included in the Premium version of Navicat. In January 2011, support for SQL Azure was added. [13] Navicat for MariaDB was released in November 2013 for Windows, Mac OS X and Linux. Also at the release, the MariaDB version was included in both Navicat Premium and Navicat for MySQL.

In 2018, Navicat started to support NoSQL databases. MongoDB is currently the newest addition to the list of server Navicat supports. The new line of product, called Navicat for MongoDB, was released in July 2018 for Windows, Mac OS X and Linux. It provides a native environment for MongoDB management and supports the extra features like MapReduce, GridFS Buckets. Also at the release, the MongoDB version was included in Navicat Premium.

In May 2023, Navicat for Redis was released. It provides key-value data viewer, Pub/Sub feature, Command Monitor, Backup & Restore etc.

In 2009, PremiumSoft released Navicat Premium, a series of Navicat software that combines all previous Navicat versions into a single version and can connect to different database types including MySQL, Oracle, and PostgreSQL simultaneously, allowing users to do data migration between cross databases. Navicat Premium version also supports cross-platform administration, serving Windows, Mac OS X and Linux. In April 2010, version 9 of Navicat Premium was released, which added the connectivity of SQLite database to Navicat Premium, allowing Navicat Premium to connect to MySQL, Oracle, PostgreSQL and SQLite in a single application. In November 2010, support for Microsoft SQL Server was added. In January 2011, SQL Azure was included. In November 2013, added the support of MariaDB. [12] [14] In July 2018, added the support of MongoDB. In May 2023, Redis has been added to Navicat Premium 16.2.

Navicat Essentials was officially released in November 2011. This is a simple Navicat version for commercial use. The Essentials editions of Navicat lack several features found in the Standard/Enterprise editions, including form view, record filtering, visual query building, data modeling and options for import, export and backup of data, etc. [15]

Navicat Data Modeler Windows version was officially released in March 2012. Then, Mac OS X and Linux version were released in May 2012 and June 2012. This is a standalone product for developers to create data models for MySQL, SQL Server, Oracle, PostgreSQL and SQLite databases. Navicat Data Modeler allows users to visually design database structures, perform reverse/forward engineer process, import table structures from ODBC data sources, generate SQL files and print models to files, etc. In June 2015, added the support of MariaDB databases and several features such as Model Conversion, Physical/Logical/Conceptual model types and Navicat Cloud.

In August 2013, PremiumSoft released a new product - Navicat iOS. [16] It is a database administration tool developed for iOS with features included object viewer & designer, query builder & editor, Navicat Cloud, [17] server monitor, etc. MySQL was supported in the first release. Then, Navicat for PostgreSQL iOS version was released in January 2015. In September 2017, Navicat for MariaDB iOS version was released.

Navicat Cloud is a cloud service for users to synchronize their connection settings, queries, models and virtual groups with multiple platforms and devices. A user can share his project to others for collaborating on connection settings, queries and models.

Navicat Monitor was officially released in April 2018. It is a safe, simple and agentless remote server monitoring tool and supports to monitor MySQL, MariaDB and cloud databases. Users can access Navicat Monitor from anywhere via a web browser. The main features of Navicat Monitor including real-time instance performance monitoring, alert notification, query analyzer, replications monitoring.

Navicat On-Prem Server is an on-premise solution that provides the option to host a cloud environment for storing Navicat objects (connection info, queries, models, groups) internally at user's location.

In Nov 2021, 2 new products, Navicat Charts Creator & Navicat Charts Viewer were released. Navicat Charts Creator is a GUI tool for creating visual representations (charts & dashboards) of database data. Navicat Charts Viewer is a tool for viewing charts workspace files.

Features

Navicat's features include:

There are differences in the features available across operating systems. [18] [19] [20] [21] [22] [23] [24] [25] [26]

Navicat is also compatible with forks of MySQL such as Drizzle, OurDelta, and Percona. [18]

Navicat supports Cloud Databases like Amazon RDS, Amazon Aurora, Amazon Redshift, SQL Azure, Oracle Cloud, Google Cloud and Alibaba Cloud. [18] [19] [20] [21] [23] [26]

See also

Related Research Articles

<span class="mw-page-title-main">MySQL</span> SQL database engine software

MySQL is an open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius's daughter My, and "SQL", the acronym for Structured Query Language. A relational database organizes data into one or more data tables in which data may be related to each other; these relations help structure the data. SQL is a language that programmers use to create, modify and extract data from the relational database, as well as control user access to the database. In addition to relational databases and SQL, an RDBMS like MySQL works with an operating system to implement a relational database in a computer's storage system, manages users, allows for network access and facilitates testing database integrity and creation of backups.

<span class="mw-page-title-main">PostgreSQL</span> Free and open-source relational database management system

PostgreSQL, also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. It was originally named POSTGRES, referring to its origins as a successor to the Ingres database developed at the University of California, Berkeley. In 1996, the project was renamed to PostgreSQL to reflect its support for SQL. After a review in 2007, the development team decided to keep the name PostgreSQL and the alias Postgres.

<span class="mw-page-title-main">IBM Db2</span> Relational model database server

Db2 is a family of data management products, including database servers, developed by IBM. It initially supported the relational model, but was extended to support object–relational features and non-relational structures like JSON and XML. The brand name was originally styled as DB/2, then DB2 until 2017 and finally changed to its present form.

<span class="mw-page-title-main">SQLite</span> Serverless relational database management system (RDBMS)

SQLite is a database engine written in the C programming language. It is not a standalone app; rather, it is a library that software developers embed in their apps. As such, it belongs to the family of embedded databases. It is the most widely deployed database engine, as it is used by several of the top web browsers, operating systems, mobile phones, and other embedded systems.

The following tables compare general and technical information for a number of relational database management systems. Please see the individual products' articles for further information. Unless otherwise specified in footnotes, comparisons are based on the stable versions without any add-ons, extensions or external programs.

<span class="mw-page-title-main">Kexi</span>

Kexi is a visual database applications creator tool by KDE, designed to fill the gap between spreadsheets and database solutions requiring more sophisticated development. Kexi can be used for designing and implementing databases, data inserting and processing, and performing queries. It is developed within the Calligra project but is released separately.

In computing, a solution stack or software stack is a set of software subsystems or components needed to create a complete platform such that no additional software is needed to support applications. Applications are said to "run on" or "run on top of" the resulting platform.

<span class="mw-page-title-main">LAMP (software bundle)</span> Acronym for a common web hosting solution

LAMP is an acronym denoting one of the most common software stacks for many of the web's most popular applications. However, LAMP now refers to a generic software stack model and its components are largely interchangeable.

IBM Spectrum Protect is a data protection platform that gives enterprises a single point of control and administration for backup and recovery. It is the flagship product in the IBM Spectrum Protect family.

A relational database management system uses SQL MERGE statements to INSERT new records or UPDATE existing records depending on whether condition matches. It was officially introduced in the SQL:2003 standard, and expanded in the SQL:2008 standard.

<span class="mw-page-title-main">EnterpriseDB</span> American software company

EnterpriseDB (EDB), a privately held company based in Massachusetts, provides software and services based on the open-source database PostgreSQL, and is one of the largest contributors to Postgres. EDB develops and integrates performance, security, and manageability enhancements into Postgres to support enterprise-class workloads. EDB has also developed database compatibility for Oracle to facilitate the migration of workloads from Oracle to EDB Postgres and to support the operation of many Oracle workloads on EDB Postgres.

<span class="mw-page-title-main">MySQL Workbench</span> Database design graphical tool

MySQL Workbench is a visual database design tool that integrates SQL development, administration, database design, creation and maintenance into a single integrated development environment for the MySQL database system. It is the successor to DBDesigner 4 from fabFORCE.net, and replaces the previous package of software, MySQL GUI Tools Bundle.

Embedded SQL is a method of combining the computing power of a programming language and the database manipulation capabilities of SQL. Embedded SQL statements are SQL statements written inline with the program source code, of the host language. The embedded SQL statements are parsed by an embedded SQL preprocessor and replaced by host-language calls to a code library. The output from the preprocessor is then compiled by the host compiler. This allows programmers to embed SQL statements in programs written in any number of languages such as C/C++, COBOL and Fortran. This differs from SQL-derived programming languages that don't go through discrete preprocessors, such as PL/SQL and T-SQL.

<span class="mw-page-title-main">HeidiSQL</span> Administration tool for relational databases

HeidiSQL is a free and open-source administration tool for MariaDB, MySQL, as well as Microsoft SQL Server, PostgreSQL and SQLite. Its codebase was originally taken from Ansgar Becker's own MySQL-Front 2.5 software. Due to having sold the MySQL-Front branding to an unrelated party, Becker chose "HeidiSQL" as a replacement. The name was suggested by a friend as a tribute to Heidi Klum, and was further reinforced by Becker's own nostalgia for Heidi, Girl of the Alps.

The DUAL table is a special one-row, one-column table present by default in Oracle and other database installations. In Oracle, the table has a single VARCHAR2(1) column called DUMMY that has a value of 'X'. It is suitable for use in selecting a pseudo column such as SYSDATE or USER.

The following tables compare general and technical information for a number of available database administration tools. Please see individual product articles for further information. This article is neither all-inclusive nor necessarily up to date.

An embedded database system is a database management system (DBMS) which is tightly integrated with an application software; it is embedded in the application. It is a broad technology category that includes:

<span class="mw-page-title-main">Database Workbench</span>

Database Workbench is a software application for development and administration of multiple relational databases using SQL, with interoperationality between different database systems, developed by Upscene Productions.

The following outline is provided as an overview of and topical guide to MySQL:

<span class="mw-page-title-main">DBeaver</span> Multi-platform database administration software

DBeaver is a SQL client software application and a database administration tool. For relational databases it uses the JDBC application programming interface (API) to interact with databases via a JDBC driver. For other databases (NoSQL) it uses proprietary database drivers. It provides an editor that supports code completion and syntax highlighting. It provides a plug-in architecture that allows users to modify much of the application's behavior to provide database-specific functionality or features that are database-independent. This is a desktop application written in Java and based on Eclipse platform.

References

  1. ↑ "Press Releases". www.navicat.com. Navicat. Retrieved 2022-04-17.
  2. ↑ Blane Warrene (2004-12-22). "Navicat Review". ONLamp.com. Archived from the original on 2017-04-13. Retrieved 2014-12-01.
  3. 1 2 Zachary Richley. "Navicat MySQL GUI Review". Splash Magazines. Retrieved 2014-12-01.
  4. ↑ "Best Business Grand Award: PremiumSoft CyberTech Ltd. Navicat for MySQL". Hong Kong Computer Society. 2008. Archived from the original on 2014-11-23. Retrieved 2014-12-01.
  5. ↑ "Navicat for MySQL release notes". Navicat. 2002–14. Retrieved 2014-12-01.
  6. ↑ "NaviCat MySQL – MySQL Database Management Tools For Windows". Techmixer. 2009. Retrieved 2014-12-01.
  7. ↑ "Navicat for PostgreSQL release notes". Navicat. 2008–14. Retrieved 2014-12-01.
  8. ↑ "Navicat for Oracle release notes". Navicat. 2008–14. Retrieved 2014-12-01.
  9. ↑ "Navicat for Oracle overview". Navicat. Retrieved 2014-12-01.
  10. ↑ "Navicat for Oracle – Oracle Administration Tools For Windows And Mac". Techmixer. 31 March 2009. Retrieved 2014-12-01.
  11. ↑ "Navicat for SQLite release notes". Navicat. 2010–14. Retrieved 2014-12-01.
  12. 1 2 "Navicat Premium release notes". Navicat. 2009–14. Retrieved 2014-12-01.
  13. ↑ "Navicat for SQL server overview". Navicat. Retrieved 2014-12-01.
  14. ↑ "Navicat Premium – Cross Database Administrator Management Tool". Techmixer. 6 September 2009. Retrieved 2014-12-01.
  15. ↑ "Navicat Essentials features". Navicat. Retrieved 2014-12-01.
  16. ↑ "Navicat iOS". Navicat. Retrieved 2014-12-01.
  17. ↑ "Navicat Cloud". Navicat. Retrieved 2014-12-01.
  18. 1 2 3 "Navicat for MySQL Feature Matrix". Navicat. Retrieved 2014-12-01.
  19. 1 2 "Navicat for MariaDB Feature Matrix". Navicat. Retrieved 2014-12-01.
  20. 1 2 "Navicat for PostgreSQL Feature Matrix". Navicat. Retrieved 2014-12-01.
  21. 1 2 "Navicat for Oracle Feature Matrix". Navicat. Retrieved 2014-12-01.
  22. ↑ "Navicat for SQLite Feature Matrix". Navicat. Retrieved 2014-12-01.
  23. 1 2 "Navicat for SQL Server Feature Matrix". Navicat. Retrieved 2014-12-01.
  24. ↑ "Navicat for MongoDB Feature Matrix". Navicat. Retrieved 2014-12-01.
  25. ↑ "Navicat for Redis Feature Matrix". Navicat. Retrieved 2014-12-01.
  26. 1 2 "Navicat Premium Feature Matrix". Navicat. Retrieved 2014-12-01.
This page is based on this Wikipedia article
Text is available under the CC BY-SA 4.0 license; additional terms may apply.
Images, videos and audio are available under their respective licenses.