One of the standout features of PostgreSQL is its extensive support for user-defined functions and data types. This allows developers to create custom conversion, operator, and aggregate functions. Aggregates offer a powerful way to perform complex calculations and transformations on data, going beyond the standard SQL aggregate functions like SUM, AVG, and COUNT. Both Navicat for PostgreSQL and Navicat Premium make it easy to write custom functions and aggregates that integrate seamlessly with the database, thanks to their specialized graphical user interface (GUI). All we need to do is provide a few details and Navicat produces the pgSQL statement for us! In today's blog, we'll be creating an aggregate to work with the DVD Rental database that concatenates movie titles by category.
Several recent blogs have been dedicated to Navicat's latest collaboration tool: Navicat On-Prem Server. It's an on-premise solution for hosting a cloud environment that allows you to synchronize your connection settings, queries, aggregation pipelines, snippets, model workspaces, BI workspaces and virtual group information across all your devices. In today's blog, we'll learn how to develop queries directly in On-Prem Server, and then share them with our team in real-time.
Adding Projects, Members, and Connections
In a recent blog, we learned about Navicat's latest collaboration tool: Navicat On-Prem Server. It's an on-premise solution for hosting a cloud environment where you can securely store Navicat objects internally at your location. Today's blog will cover how to work with projects in Navicat On-Prem Server. Topics covered will include how to create a project, adding members, and how to configure a connection to your database instance(s).
Available in all editions of Navicat database administration and development tools (including Navicat Premium Lite!), Code Snippets allows you to insert reusable code into your SQL statements when working in the SQL Editor. Besides gaining access to a collection of built-in snippets, you can also define your own. One of the built-in categories supplies special Navicat-only Syntax for customizing the query results tab name as well as for supplying runtime parameters. Today's blog will demonstrate how to use both snippets in your queries using the free MySQL Sakila Database and Navicat Premium 17.
Customizing the App Server Settings and Setting Up Notifications
Navicat On-Prem Server is the perfect on-premise cloud solution for organizations who wish to maintain complete control over their data. By maintaining full control over your system, you can ensure 100% data privacy, while still benefiting from the convenience and features of a cloud-based solution. Navicat On-Prem Server also provides comprehensive management tools for MySQL and MariaDB, enabling efficient administration, monitoring, and management of your database instances.
Last week's blog article covered the first steps for configuring Navicat On-Prem Server on Windows 10 with a MySQL 8 Community Server instance. Today we will go over the App Server, Notification Settings, and Confirmation steps to complete the configuration process.
- 2024 (1)
- 2023 (1)
- 2022 (1)
- 2021 (1)
- 2020 (1)
- 2019 (1)
- 2018 (1)
- 2017 (1)
