Navicat Blog

Getting started with Redis Jun 16, 2023 by Robert Gravelle

Redis is an open source, BSD licensed, advanced key-value store, written in C. It's also referred to as a data structure server, since the keys can contain strings, hashes, lists, sets and sorted sets. This tutorial will provide the fundamentals of Redis concepts needed to start using it right away.

Introducing Navicat for Redis! Jun 9, 2023 by Robert Gravelle

Version 16.2 of Navicat Premium added several exciting new features to an already stellar product, the most noteworthy being Redis support. Now, there is a Navicat administration and development client specifically for Redis. Navicat for Redis offers users an easy-to-access visual interface to visualize and optimize Redis data. It includes a rich set of features for making routine management tasks simpler, easier and more efficient than ever before. It can connect to any local/remote Redis server, and is compatible with cloud databases like Redis Enterprise Cloud, Amazon ElastiCache, Google Memorystore and Microsoft Azure. This blog will outline some of Navicat for Redis's most important features.

A Guide to MySQL Foreign Key Constraints Jun 2, 2023 by Robert Gravelle

During the process of normalization, groups of fields that represent a distinct entity are removed from a larger and/or more central table to a separate one. Common fields (usually IDs) are then employed to maintain their relationship. We can see an example below:

film_id_fk (34K)

In relational database, referential integrity between tables is enforced using foreign key constraints.

This blog will cover how foreign keys work as well as how to create a foreign key constraint in MySQL using Navicat 16 for MySQL .

Creating Views in Navicat 16 May 19, 2023 by Robert Gravelle

As part of the process of normalizing database tables, redundant columns are extracted from higher level tables into separate subsidiary ones. This often occurs due to some fields having a one to many relationship with the parent entity. For example, take the following model that was generated using Navicat Data Modeler:

ups_model (189K)

Multi-Version Concurrency Control in PostgreSQL May 12, 2023 by Robert Gravelle

Whereas most database systems employ locks for concurrency control, PostgreSQL does things a little differently: it maintains data consistency by using a multi-version model, otherwise known as Multi-Version Concurrency Control, or MVCC for short. As a result, when querying a database, each transaction sees a snapshot of data as it was some time before, regardless of the current state of the underlying data. This prevents the transaction from viewing inconsistent data that could be caused by other concurrent transaction updates on the same data, and provides transaction isolation for each database session. This blog article will provide a brief overview of how the MVCC protocol works as well as cover some of the pros and cons of the MVCC approach.

Navicat Blogs
Feed Entries
Blog Archives