-
Introduction to Views in MongoDB
MongoDB recently introduced views in version 3.4. In today's blog, we'll learn how to create a view in MongoDB using Navicat for MongoDB GUI administration and development tool.
https://www.navicat.com/en/company/aboutus/blog/876-introduction-to-views-in-mongodb.html -
Navicat for MySQL (Mac OS X) Version 8 is released
2009-02-16 Navicat for MySQL (Mac OS X) Version 8 is released PremiumSoft CyberTech Limited today released Navicat for MySQL (Mac OS X) version 8.X.X. Navicat for MySQL is a graphical tool for managing, monitoring, and developing your MySQL database....
https://www.navicat.com/en/company/press-2/62-test-6.html -
Navicat for MySQL (Mac OS X) Version 8 is released
2009-02-16 Navicat for MySQL (Mac OS X) Version 8 is released PremiumSoft CyberTech Limited today released Navicat for MySQL (Mac OS X) version 8.X.X. Navicat for MySQL is a graphical tool for managing, monitoring, and developing your MySQL database....
https://www.navicat.com/en/22-press-ct/364-test-6.html -
Receive Notifications for MySQL/MariaDB Issues
of the main roles of database monitoring is to catch potential issues before they develop into real problems. To that end, Navicat Monitor for MySQL/MariaDB offers advanced root cause analysis that enables you to find in-depth information when an issue...
https://www.navicat.com/en/company/aboutus/blog/974-receive-notifications-for-mysql-mariadb-issues.html -
Using the MySQL Information Schema
you are looking for. In today's blog, we'll explore a few practical uses for the INFORMATION_SCHEMA, as demonstrated using Navicat Premium .
https://www.navicat.com/en/company/aboutus/blog/1054-using-the-mysql-information-schema.html -
How to Query across Multiple Databases
Jun 4, 2019 by Robert Gravelle With Master-Slave topologies and modern practices such as Database sharding becoming increasingly ubiquitous, database administrators (DBAs) and developers are working with multiple databases more than ever before. Doing...
https://www.navicat.com/en/company/aboutus/blog/1059-how-to-query-across-multiple-databases.html -
Connecting to Multiple Databases from a Single Tool
Jun 12, 2019 by Robert Gravelle Many database management and development tools support multiple connections to homogeneous databases, i.e., where they are all of the same type, ALL MySQL, ALL SQL Server, ALL Oracle, etc. On the other hand, very few...
https://www.navicat.com/en/company/aboutus/blog/1061-connecting-to-multiple-databases-from-a-single-tool.html -
Choosing Between VARCHAR and TEXT in MySQL
Feb 19, 2020 by Robert Gravelle One of the changes in MySQL version 5.0.3 included an increase to the maximum length of VARCHAR fields from 255 to 65,535 characters. That made the VARCHAR type more similar to TEXT than ever before. For those of us who...
https://www.navicat.com/en/company/aboutus/blog/1308-choosing-between-varchar-and-text-in-mysql.html -
Navicat for MySQL (Mac OS X) version 7.1.7 is released
2009-01-17 Navicat for MySQL (Mac OS X) version 7.1.7 is released 2009 January, 17 - PremiumSoft CyberTech Limited today released Navicat for MySQL (Mac OS X) version 7.1.7. Navicat for MySQL is a graphical tool for managing, monitoring, and developing...
https://www.navicat.com/en/company/press-2/60-test-4.html -
Navicat for MySQL (Mac OS X) version 7.1.7 is released
2009-01-17 Navicat for MySQL (Mac OS X) version 7.1.7 is released 2009 January, 17 - PremiumSoft CyberTech Limited today released Navicat for MySQL (Mac OS X) version 7.1.7. Navicat for MySQL is a graphical tool for managing, monitoring, and developing...
https://www.navicat.com/en/22-press-ct/362-test-4.html -
Storing Large Files in MongoDB
a separate specification called GridFS for storing and retrieving files. In today's blog, we'll be taking a look at how Navicat for MongoDB implements the GridFS spec to store large files.
https://www.navicat.com/en/company/aboutus/blog/964-storing-large-files-in-mongodb.html -
Working with MySQL Logs (Part 3): the Slow Log
blog series on MySQL logging. We'll be referencing these first three installments later on when we talk about monitoring in Navicat Monitor for MySQL/MariaDB. Part I provided an overview of the different log types on MySQL, highlighted the most...
https://www.navicat.com/en/company/aboutus/blog/972-working-with-mysql-logs-part-3-the-slow-log.html -
Working with MySQL Logs
Today's blog is a primer on MySQL logging - a topic that we'll be referencing later on when we talk about monitoring in Navicat Monitor for MySQL/MariaDB.
https://www.navicat.com/en/company/aboutus/blog/970-working-with-mysql-logs.html -
The SQL Self JOIN
of join is required called a self join. In today's blog, we'll learn how to write a query that includes a self join using Navicat Premium as the database client.
https://www.navicat.com/en/company/aboutus/blog/1214-the-sql-self-join.html -
Perform Full-text Searches in MySQL (Part 2)
distinct types of full-text searches. In today's blog, we'll learn how to perform Natural Language full-text searches in Navicat for MySQL.
https://www.navicat.com/en/company/aboutus/blog/1262-perform-full-text-searches-in-mysql-part-2.html -
Selecting All But One Column In MySQL
Jan 23, 2020 by Robert Gravelle SQL makes selecting all fields in a table quite trivial via the SELECT * (SELECT ALL) clause. Unfortunately, as soon as you omit a column from the list, the SELECT ALL statement goes out the window. Writing out every...
https://www.navicat.com/en/company/aboutus/blog/1304-selecting-all-but-one-column-in-mysql.html -
Eliminating Repeating Groups In Your Database Tables
as well as how to fix them. Since repeating groups are a phenomenon that can affect any relational database, we'll use Navicat Premium as our database development tool.
https://www.navicat.com/en/company/aboutus/blog/1307-eliminating-repeating-groups-in-your-database-tables.html -
Managing Multiple Databases from a Single Application
employ multiple client applications or find one that can accommodate all of the databases that you use. One such tool is Navicat Premium . Not only does it support most of the major Database Management Systems (DBMSes), but it is one of the few tools...
https://www.navicat.com/en/company/aboutus/blog/1115-managing-multiple-databases-from-a-single-application.html -
Our Customer
More than 40% of the Fortune 500 companies rely on Navicat every day. Meet some of our customers Country : ----- Please Select ----- Industry : ----- Please Select ----- Search 3M COMPANY (NYSE: MMM) AMEC Atmos Energy Corporation (NYSE: ATO) Accenture...
https://www.navicat.com/en/company/corporate.html -
Prepare to Migrate Databases to Amazon Aurora
October 3, 2017 by Gavin Being a MySQL compatible relational database engine, Amazon Aurora amalgamates safety, availability and speed of top notch commercial databases with the easiness and cost efficiency of open source database. The engine has been...
https://www.navicat.com/en/company/aboutus/blog/665-prepare-to-migrate-databases-to-amazon-aurora.html
