Navicat Blog

Working with Strings in Redis Oct 20, 2023 by Robert Gravelle

Redis is a powerful open-source, in-memory data structure store that is used for various purposes such as caching, session management, real-time analytics, and more. One of the fundamental data types in Redis is strings, which can hold any kind of text or binary data, up to a maximum limit of 512 megabytes. In today's blog, we'll learn how to work with strings in Redis, both using the CLI and Navicat for Redis.

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.

Comparing Database Connectivity: Navicat versus Java-based Tools Sep 28, 2023 by Robert Gravelle

In the realm of database management and development, the choice of tools can greatly impact efficiency and productivity. Java-based tools have emerged as strong contenders, offering diverse capabilities for working with databases. However, when it comes to native database connectivity, the differences between tools can be quite impactful. Let's explore how Navicat's ability to connect to databases natively sets it apart from other Java-based tools in the market.

使用 Redis Hash 2023 年 9 月 15 日,由 Robert Gravelle 撰寫

在 Redis 中,雜湊(Hash)是一種對應字串鍵和欄位值的資料結構。因此,Hash 特別適合用於表示基本物件和儲存計數器分組等。本文將介紹使用 redis-cli 和 Navicat for Redis 管理 Hash 的一些主要命令。

Navicat Blogs
Feed Entries
Blog Archives
Share