Navicat Blog

Joining Database Tables on Non-Foreign Key Fields Oct 13, 2023 by Robert Gravelle

In the world of relational databases, joining tables on foreign keys is a common and well-understood practice. However, there are situations where you need to join tables based on non-foreign key fields. This might seem unconventional, but it can be a powerful technique when used appropriately. In this article, we will explore the concept of joining database tables on non-foreign key fields, and we'll demonstrate how to do it using Navicat.

Expiring Keys in Redis Oct 6, 2023 by Robert Gravelle

Redis is a high-performance, in-memory data store known for its speed and versatility. One of its useful features is the ability to set expiration times for keys. Expiring keys in Redis is crucial for managing data and ensuring that outdated or temporary data is automatically removed from the database. In this article, we'll explore how to expire keys in Redis using the redis-cli and Navicat for Redis as well as how this feature can be applied in various scenarios.

Using Hashes in Redis Sep 15, 2023 by Robert Gravelle

In Redis, a Hash is a data structure that maps a string key with field-value pairs. Thus, Hashes are useful for representing basic objects and for storing groupings of counters, among other things. This article will go over some of the main commands for managing hashes, both via the redis-cli and using Navicat for Redis.

A Quick Guide to Redis Sets Sep 8, 2023 by Robert Gravelle

Redis supports several data types for storing collections of items. These include lists, sets, and hashes. Last week's blog article covered the List data type and highlighted some of the main commands for managing them. In today's follow-up we'll be turning our attention to the set type. In Redis, a Set is similar to a List except that it doesn't keep any specific order for its elements and each element must be unique. This article will go over some of the main commands for managing sets, both via the redis-cli and using Navicat for Redis.

Navicat Wins a DBTA Readers' Choice Award! Aug 31, 2023 by Robert Gravelle

In a resounding testament to its commitment to excellence and innovation, Navicat has been announced as the winner of the prestigious Best DBA Solution category in the 2023 DBTA Readers' Choice Awards. (Navicat Data Modeler was also a finalist in the Best Data Modeling Solution category.) The annual awards program, hosted by Database Trends and Applications (DBTA) magazine, celebrates outstanding products and solutions in the dynamic landscape of data management and analytics. The recognition is a result of votes and opinions from DBTA's readership—comprising data and IT professionals hailing from diverse industries.

Navicat Blogs
Feed Entries
Blog Archives