Redisgraph - Deep Dive Part 1

Kisore Subburaman — Sat, 26 Sep 2020 07:34:13 +0000

RedisInsight

Hey guys! This is the second part of Redisgraph series. As we talked about RedisInsight earlier, it is a GUI for redis application. We can view the graphical representation of our data. Here, Install RedisInsight contains the steps for installation.
Once installed, run your redis server and redis insight, navigate to http://127.0.0.1:8001/. You will visit the home page of redis insight, there you can create a new database for your project as mentioned below.

Now, a database is created, you can navigate into it. In the sidebar, you can find Redisgraph, get into it. There, you can run commands and execute them. Both graphical and JSON notation of data is available.

CREATE

MATCH

Now, we can see some of the commands withdrawing the example we had from our last tutorial,

SKIP

It is used when we deal with batches of records.

syntax: SKIP [number of records to be skipped]

MATCH (e:emp) RETURN e SKIP 10;

It skips the first 10 records and returns the rest.

LIMIT

It is used to limit the number of records.

syntax: LIMIT [maximum number of records to be retrieved]

MATCH (e:emp) RETURN e LIMIT 10;

It returns only the first 10 records present.

SKIP and LIMIT together

MATCH (e:emp) RETURN e SKIP 10 LIMIT 10;

It skips the first 10 records and lists the next 10.

ORDER BY

It denotes the sorting option [ASC/DESC]. We can specify how the records have to be sorted.

syntax: ORDER BY [field name] [ASC/DESC]

If we want to retrieve records with sorting names of employees ascending order(default).

MATCH (e:emp) RETURN e ORDER BY e.name;

For descending,

MATCH (e:emp) RETURN e ORDER BY e.designation DESC;

Intro to Redisgraph

Kisore Subburaman — Thu, 17 Sep 2020 14:33:53 +0000

Hey guys! This is a series about RedisGraph. For the people out there who are new to this term, it is the first queryable Property Graph database to use sparse matrices to represent the adjacency matrix in graphs and linear algebra to query the graph. Don't panic, it is not as difficult as it seems, in a nutshell, it is a graph-based database where we're going to handle data through nodes and relationships. For guys who have worked in Neo4j, this would be a piece of cake.You can visit the official site here Redisgraph

Let's see the primary features:

It is based on the Property Graph Model.
Nodes are treated as vertices and edges are treated as relationships, that may have attributes.
Nodes can be labeled.
Relationships have a relationship type.
Graphs are represented as sparse adjacency matrices, Cypher as a query language
Cypher queries are translated into linear algebra expressions

Setting up redisgraph

You can find the installation and setup process here Setup Redisgraph

Why should I use Redisgraph?

Faster : Redisgraph provides faster access and retrieval of data.
Straightforward : Since it is based on nodes and relations, it is not a hard nut to crack.
Understandable : Queries are simple commands and clear.
Visual view : To interact with data visually, Redislabs provides a service RedisInsight, we will dig deeper into that service later in our tutorial.

Supported Datatypes

Integer
NULL
String
Boolean
Double

Let's get our hands dirty

We take an example of creating employees of an organization and perform CRUD.

CREATE

    CREATE (e:emp{id:1, name: 'John', age: '24', designation: 'developer'}) RETURN e;

    CREATE (e:emp{id:2, name: 'Jessie', age: '27', designation: 'tester'}) RETURN e;

Here,
* e - alias of the emp, we can use it within this entire command anywhere we needed.
* emp - name of the node.
* data will be given as key-value pair (object).
* RETURN - return the data after creation.

MATCH

It matches all docs(documents) when no condition is given explicitly and when given, it retrieves only the docs matching the condition.

To return the list of all employees

 MATCH (e:emp) RETURN e;

To fetch on condition basis

MATCH (e:emp{id:1}) RETURN e;

MATCH (e:emp) WHERE e.id = 1 RETURN e;

Both ways returns the doc of an employee having id 1.

SET

To update a single property

 MATCH (e:emp{id: 1}) SET e.age=28 RETURN e;

To update more than one property

MATCH (e:emp{id: 1}) SET e.age=28,e.designation=’senior developer’ RETURN e;

DELETE

To delete based on condition

MATCH (e:emp{id:2}) DELETE e;

Boom! It deletes the employee with id 2.
To delete all the docs

MATCH (e:emp) DELETE e;

Forem: DevParadise