Navicat's database administration and development tools have long been designed with collaboration in mind. Now, thanks to the recent launch of Navicat On-Prem Server, collaboration takes center stage, allowing us to share connection settings, queries, aggregation pipelines, snippets, model workspaces, Business Intelligence (BI) workspaces and virtual group information with team members across the globe - and all in real-time. While the last several blogs described how to share database objects using Navicat On-Prem Server, today's entry will focus on how to accomplish the same thing using Navicat Premium 17.
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.
- 2024 (1)
- 2023 (1)
- 2022 (1)
- 2021 (1)
- 2020 (1)
- 2019 (1)
- 2018 (1)
- 2017 (1)
