Google Colab
Use Google Colab to manage your Supabase Vector store.
Google Colab is a hosted Jupyter Notebook service. It provides free access to computing resources, including GPUs and TPUs, and is well-suited to machine learning, data science, and education. We can use Colab to manage collections using Supabase Vecs.
In this tutorial we'll connect to a database running on the Supabase platform. If you don't already have a database, you can create one here: database.new.
Create a new notebook
Start by visiting colab.research.google.com. There you can create a new notebook.
Install Vecs
We'll use the Supabase Vector client, Vecs, to manage our collections.
At the top of the notebook add the notebook paste the following code and hit the "execute" button (ctrl+enter
):
Connect to your database
Find the Postgres pooler connection string for your Supabase project in the database settings of the dashboard. Copy the "URI" format, which should look something like postgres://postgres.xxxx:password@xxxx.pooler.supabase.com:6543/postgres
Create a new code block below the install block (ctrl+m b
) and add the following code using the Postgres URI you copied above:
Execute the code block (ctrl+enter
). If no errors were returned then your connection was successful.
Create a collection
Now we're going to create a new collection and insert some documents.
Create a new code block below the install block (ctrl+m b
). Add the following code to the code block and execute it (ctrl+enter
):
This will create a table inside your database within the vecs
schema, called colab_collection
. You can view the inserted items in the Table Editor, by selecting the vecs
schema from the schema dropdown.
Query your documents
Now we can search for documents based on their similarity. Create a new code block and execute the following code:
You will see that this returns two documents in an array ['vec1', 'vec0']
:
It also returns a warning:
You can lean more about creating indexes in the Vecs documentation.
Resources
- Vecs API: supabase.github.io/vecs/api