Configuring the Superuser, On-Prem Server Profile, and Repository Server

Navicat On-Prem Server is an on-premise solution for hosting a cloud environment where you can securely store Navicat objects internally at your location. It's one of two Navicat products whose goal is to foster increased collaboration amongst team members - the other being Navicat Cloud. The main difference between these two solutions is the location of shared objects: in the case of Navicat Cloud, they are stored in a central location on Navicat's servers, whereas the Navicat On-Prem Server resides on your organization's infrastructure. That being said, you can also install Navicat On-Prem Server on Amazon Linux 2 or within a Docker container. Today's blog will cover the first steps for configuring Navicat On-Prem Server on Windows 10 with a MySQL 8 Community Server instance. The next blog article will complete the series with the remaining steps.

[Read More]

Navicat Collaboration provides the means for your team to collaborate on a variety of database objects, including connection settings, queries, aggregation pipelines, snippets, model workspaces, BI workspaces and virtual group information. Navicat offers two options for Collaboration: Navicat Cloud and Navicat On-Prem Server. Whereas Navicat Cloud offers a central space for your team to store Navicat objects, Navicat On-Prem Server is an on-premise solution for hosting a cloud environment where you can securely store Navicat objects internally at your location. Today's blog will describe how Navicat On-Prem Server helps foster collaboration within your team and manage MySQL and MariaDB instances more effectively.

[Read More]

One of the most powerful SQL features is the JOIN operation, providing an elegant and simple means of combining every row from one table with every row from another table. However, there are times that we may want to find values from one table that are NOT present in another table. As we'll see in today's blog article, joins can be utilized for this purpose as well, by including a predicate on which to join the tables. Known as anti joins, these can be helpful in answering a variety of business-related questions, such as:

• Which customers did not place an order?
• Which employees have not been assigned a department?
• Which salespeople did not close a deal this week?

This blog will offer a primer on the types of anti joins and how to write them using a few examples based on the PostgreSQL dvdrental database. We'll write and execute the queries in Navicat Premium Lite 17.

[Read More]

Most database developers and administrators are familiar with the standard inner, outer, left, and right JOIN types. While these can be written using ANSI SQL, there are other types of joins that are based on relational algebra operators that don't have a syntax representation in SQL. Today we'll be looking at one such join type: the Semi Join. Next week we'll tackle the similar Anti Join. To gain a better understanding of how these types of joins work, we'll execute some SELECT queries in Navicat Premium Lite 17 against the PostgreSQL dvdrental database. It's a free database that's based on the MySQL Sakila Sample Database.

[Read More]