November 25 is the official launching date for Navicat Premium 15. Currently, version 15 packs a wallop of new features and improvements, most notably in data transfers, the SQL Builder, and modeling. It also adds Data Visualization, Dark Mode and native Linux support. In today's blog we'll learn how the new Data Visualization feature helps us turn our database into visuals that provide valuable insights into our data through a wide variety of charts and graphs.
In Part 1, we saw how MySQL provides full-text search capability via FULLTEXT indexing along with three 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.
Full-text Search, or FTS, is one of the techniques employed by search engines to find results in their database(s). You too can harness the power of FTS to search for patterns that are too complex for the Like operator. In today's blog, we'll learn how full-text searching is implemented in MySQL. In part 2, we'll try our hand at some queries using Navicat for MySQL as our database client.
Navicat Monitor, the agentless database server instance monitoring tool for MySQL and MariaDB recently added support for SQL Server. Hence, it can now monitor database process and system resources for locally hosted SQL Server instances as well as those provided via Amazon Web Services (AWS). Today's blog will provide a quick guide for connecting to an SQL Server instance in order to monitor its performance using Navicat Monitor 2.0.
SQL queries often return more than one row of data from the database server. Relational databases provide cursors as a means for iterating over each row of the results set. Does that mean that MongoDB users are out of luck? As it turns out, MongoDB's db.collection.find() function returns a cursor. In MongoDB, cursors themselves provide additional functionality for processing individual rows. In today's blog, we'll learn how to work with MongoDB cursors in Navicat for MongoDB.
- 2019 (1)
- December (1)
- October (1)
- September (1)
- August (1)
- July (1)
- June (1)
- May (1)
- The Between Operator
- Some SELECT Queries You Must Know
- Diagnose Bottlenecks and/or Deadlocks in MySQL 8 using Navicat Monitor
- How the MySQL 8 Performance Schema Helps Diagnose Query Deadlocks
- How the MySQL 8 Performance Schema Helps Diagnose Query Deadlocks (2)
- How the MySQL 8 Performance Schema Helps Diagnose Query Deadlocks (3)
- April (1)
- March (1)
- February (1)
- January (1)
- 2018 (1)
- 2017 (1)
-
Support
-
About Us
