Navicat Blog

Trace Queries on your PostgreSQL Instances with Navicat Monitor 3 Mar 16, 2023 by Robert Gravelle

Navicat Monitor 3 comes packed with a variety of exciting new features. Case in point, you can now create traces that collect query data based on selected filters from the server log. When creating a trace, you can define criteria to filter the data collected by SQL Profiler and set a schedule for executing the trace. In today's blog we'll learn how to create a trace and view its results.

Monitoring PostgreSQL with Navicat Monitor 3.0 Mar 10, 2023 by Robert Gravelle

Version 3 of Navicat Monitor has just be released. Unsurprisingly, it packs many outstanding new features, as well as numerous improvements to existing features. One of the most noteworthy changes between version 2 and 3 is added support for PostgreSQL, including an SQL Profiler for PostgreSQL instances.

Today's blog will provide a quick guide on getting setup to monitor your be PostgreSQL instances using Navicat Monitor 3.0.

Navicat Monitor 3.0 is Here! Mar 3, 2023 by Robert Gravelle

It seems like only yesterday that Navicat Monitor 2.0 was released, adding great new features to an already stellar product. Now, version 3.0 is introducing yet more outstanding features, including:

  • Support monitoring PostgreSQL instances.
  • Support SQL Profiler for PostgreSQL instances.
  • Enhanced Query Analyzer.
  • Enhanced Long Running Queries.
  • Many other new features and improvements.

Of course, all of Navicat Monitor's existing functionality remains in place, including:

  • Agentless Architecture
  • Real-time Performance Monitoring
  • See how your instances are currently functioning easily
  • Advanced root cause analysis
  • Set custom alert thresholds
  • Get notifications via email, SMS or SNMP
  • Replication Monitoring
  • Powerful Query Analyzer
  • and more...

In today's blog, we'll be taking a look at the brand new Navicat Monitor 3.0 with the emphasis being on the new features listed above.

A Quick Guide to Naming Conventions in SQL - Part 1 Feb 15, 2023 by Robert Gravelle

Table Names

Naming conventions are a set of rules (written or unwritten) that should be utilized in order to increase the readability of the data model. You may apply these rules when naming anything inside the database, including tables, columns, primary and foreign keys, stored procedures, functions, views, etc. You need not apply rules to all database objects. For instance, it would be perfectly fine to limit naming convention rules to tables and column names. It's really your decision, as using a naming convention is not mandatory, but beneficial nonetheless. This three part series will present some commonly used naming conventions and provide some tips for formulating your own. Part 1 will cover Table names, while Part 2 will focus on column names. Finally, Part 3 will address Naming Conventions for other database objects such as Foreign Keys, Procedures, Functions, and Views.

Supercharging Your Queries with Navicat and ChatGPT Feb 9, 2023 by Robert Gravelle

It's official: the age of Artificial Intelligence (AI) has arrived! Until our new overlords decide to use us to power their machines, let's take the time to fully enjoy all the benefits they provide and the myriad of ways that they make our lives easier. Case in point, the AI-driven chatbot, ChatGPT, by OpenAI, has been lauded for its ability to produce tremendously spot-on answers to questions across a broad range of topics. And, although ChatGPT may not be making our jobs obsolete just yet, it has proven to be amazingly adept at working with data sets, much like a DBMS. In today's blog, we'll explore how ChatGPT could be utilized to supplement a professional database development and administration tool like Navicat.

Navicat Blogs
Feed Entries
Blog Archives