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.

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.

Navicat Blogs
Feed Entries
Share
Blog Archives