18 Months of Pgvector Learnings in 47 Minutes (Tutorial)

---
name: 18-months-of-pgvector-learnings-in-47-minutes-tutorial
version: "1.0.0"
description: "Building AI applications with PostgreSQL and pgvector"
source: "https://www.youtube.com/watch?v=Ua6LDIOVN1s"
tags: [pgvector, pgai, pgvectorscale, TimescaleDB, PostgreSQL]
---

# 18 Months of Pgvector Learnings in 47 Minutes (Tutorial)

> Auto-generated from: 18 Months of Pgvector Learnings in 47 Minutes (Tutorial) by Tiger Data (creators of TimescaleDB)

## Prerequisites
- PostgreSQL 14+
- pgvector extension
- pg_vector_scale extension
- pgai extension
- OpenAI API Key

## Quick Start
1. `CREATE EXTENSION pgvector`
2. `CREATE EXTENSION pg_vector_scale`
3. `CREATE EXTENSION pgai`
4. `CREATE TABLE quotes (id UUID PRIMARY KEY, quote TEXT, person TEXT, embedding VECTOR(1536))`
5. `UPDATE quotes SET embedding = openai_embedding(quote, 'text-embedding-3-small')`

## What You Get
- Content Type: hybrid
- Difficulty: intermediate
- Tools: pgvector, pgai, pgvectorscale, TimescaleDB, PostgreSQL