Announcing Hasura Notebook: Prototype fast on GenAI apps

Hasura
7 min readAug 31, 2023

Hasura empowers you to rapidly create high-quality data APIs for production purposes. As data sources continue to evolve, Hasura evolves as well, providing you with the capability to construct secure data APIs over versatile data stores, including vectorized data.

If you are new to Hasura, we recommend getting started for free with Hasura Cloud.

As part of Hasura’s evolution, today we’re introducing Hasura Notebooks, a tool designed to facilitate the swift prototyping of cutting-edge GenAI applications.

In this blog, we’ll take you through this new tool to gain a comprehensive understanding of how it works and why you need it.🙂

GenAI revolution

Large Language Models (LLMs) are very large deep neural networks trained on vast amounts of text data mostly scraped from the internet.

LLMs have taken the world by storm because these generalized language models are so good at understanding context, retrieving information, and generating content that can help us with numerous applications. And why not? Automation is the key to efficient applications.

At its core, LLMs learn the word probabilities to predict the next most suitable word given in a sentence. If the sentence is from a domain which the LLM hasn’t been exposed in the training period, then the LLM will make low confidence predictions, which are known as hallucinations.We can deal with this problem by providing LLM context in prompts and instructing it to use the context to complete the task. This process is called grounding.

In order to maximize the potential of LLMs across a wide range of applications, it’s essential to expand the scope of secure data sources. Given the fast-paced environment, it’s equally important to avoid dedicating excessive time to constructing data APIs (a crucial yet somewhat mundane task 🤷‍♀️) when you could be focused on creating exciting and lucrative applications.

Hasura to the rescue!

Let’s learn how you can quickly build secure data APIs and prototypes with a product search demo.

What is Hasura Notebook

Hasura Notebook is a remote Jupyter Notebook with ready-to-run examples and Jupyter Kernel Gateway baked-in to turn your code cells into endpoints.

Hasura Notebooks are great if you want to quickly prototype GenAI application with Hasura or learn GenAI from our existing templated projects.

We are going to building on Hasura Notebook in this blog. Recommended reading before we proceed — Hasura Jupyter Python Notebook & API Server documentation.

Use case: Get a contextual product search powered by OpenAI in under 10 minutes 🚀

As you might have experienced yourself, searches on most e-commerce websites are keyword-oriented. This results in a lot of false positives or irrelevant results and can lead to dissatisfied users. Contextual search is an answer to this problem. Contextual search matches the user query with the product description.

Prerequisites

1. Hasura CLI

If this is your first time using Hasura CLI, you will need to install it. Follow the installation instructions in this doc.

2. Hasura Notebook

Follow the steps in the documentation below to instantiate your Hasura Notebook.

You will know you are ready when you are able to access the Hasura Notebook with a landing page that looks like this.

You can find all the code under https://<connector url>/jupyter/notebook/product_search.

Let’s get building! 🚀

Setup your PostgreSQL database

Step 1: Start a new Neon Cloud PostgreSQL DB or link your existing DB.

More details on Neon Cloud PostgreSQL DB here: https://hasura.io/docs/latest/databases/postgres/neon/

Step 2: Create a new table called `base_products` and track it from the data tab.
Tracking enables the table to be accessible through GraphQL query.

Set up your vector database

Step 1: Create a free 14-day cluster on Weaviate.

Head to https://console.weaviate.cloud/ and register for an account. After confirming via email, click + Create cluster and fill in a name before clicking Create. Once Weaviate has provisioned your sandbox cluster, proceed to the next step.

Step 2: Create the Product schema called Product_vectors.

Product schema ID, Product Name, and Product Description. To execute this, run setup_weaviate.ipynb

Step 3: Add the Weaviate table to Hasura.

Currently, the Weaviate connector is not natively available in Hasura. You can add it to Hasura in two simple steps using the Hasura CLI.

# create connector using our weaviate repo 
hasura connector create my_weaviate_connector:v1 --github-repo-url https://github.com/hasura/weaviate_gdc/tree/main/
# check deployment status to get the endpoint
hasura connector status my_weaviate_connector:v1 
# you can also use list command
hasura connector list
# view logs at any point of time
hasura connector logs my_weaviate_connector:v1
# for more commands explore help section

2. Add the Weaviate connector to Hasura.

Refer to this document for details https://hasura.io/docs/latest/databases/vector-databases/weaviate/

Step 4: Track the table.

Add a remote relationship between PostgreSQL and Weaviate tables

Go to Product_vectors table and add a relationship with the PostgreSQL database as shown below.

Set up an Event Trigger on a PostgreSQL table

Step 1: Fetch your Hasura GraphQL API endpoint and Admin secret.
Move over to cloud.hasura.io and click Projects. From your project, click on the Settings icon to access Project details.

Step 2: Update Hasura GraphQL details in the notebook under Template for event trigger to ETL data.

Open server.ipynb and you can see there are multiple functions with cells commented with # POST /handle_event These are the functions that are available on the endpoint /handle_event.

Update the details in the cell, and you are ready to go.

Don’t forget to restart the Jupyter gateway server.

Step 3: Add the Event Trigger in Hasura.

Head back to the Hasura Console and click on the Event tab to create a new Event. Fill in the required details.

Your webhook URL is your notebook URL (ends with .app) + invoke/handle_event.

You can also fetch your webhook URL by running this CLI command again hasura notebook status.

Add the authorization header required to reach the endpoint from the Hasura notebook.

Generate base64 encoded value. You will need to execute this on terminal of your choice.

echo -n "<username>:<password>" | base64

You can fetch the username and password by executing the following command

hasura notebook status
Key = Authorization Value = Basic <base64 encoded value here>

Now that we have integrated Weaviate with Hasura, we can use a mutation in Hasura to insert data into our Postgres table and auto-vectorize and update our vector DB! You can do this by executing insert_data.ipynb.

Voila! We have vectors with product name and description fields.

Secure semantic search using Hasura

For more on building secure APIs with Hasura, refer to this overview: https://hasura.io/docs/latest/auth/overview/

Let us now go one step further, with complex query powered by LLM.

LLM-powered product search

Step 1: Update Hasura GraphQL and OpenAI details in the notebook under Template for event trigger to ETL data.

Update the details, and you are ready to go.

After updating any of these values, it’s important to restart your notebook. You can do this from the gateway generated earlier using the CLI.

Step 2: Create LLM prompt

This step is available as a template for you. Feel free to tweak the prompt and play with it.

Step 3: Create Hasura Action

Like before, you will need to add Authorization headers.

Step 4: What you just created is a secure API on your LLM query. Integrate the API with your app or just play around on the Hasura Console. You now have the power of the Hasura by your side.

Conclusion

By seamlessly deploying a Jupyter Notebook through the Hasura CLI, you’ve unlocked a world of possibilities. The ability to automatically vectorize relational data has not only accelerated your data manipulation processes but has also paved the way for more efficient and effective analyses.

Moreover, the integration of robust security measures into your LLM queries ensures that your data remains protected at all times. This remarkable journey, powered by Hasura, empowers you to harness the true potential of your data, all while simplifying the intricate processes involved!

With Hasura by your side, what will you build?

Originally published at https://hasura.io on August 31, 2023.

--

--

Hasura

⚡️ Instant realtime GraphQL APIs! Connect Hasura to your database & data sources (GraphQL, REST & 3rd party API) and get a unified data access layer instantly.