Retrieval-Augmented Generation With Claude Sonnet 3.5 and Pgvector | Tiger Data

Home Time series basics Postgres basics Postgres guides Postgres best practices Postgres extensions Postgres for real-time analytics

AI and vector fundamentals

A Brief History of AI: How Did We Get Here, and What's Next?A Beginner’s Guide to Vector Embeddings PostgreSQL as a Vector Database: A Pgvector Tutorial Using Pgvector With Python How to Choose a Vector Database Vector Databases Are the Wrong Abstraction

Cosine similarity

A Guide to Cosine Similarity Implementing Cosine Similarity in Python

Vector databases

Vector Database Options for AWS Vector Store vs. Vector Database: Understanding the Connection

Vectorscale

Fundamentals

Understanding DiskANN HNSW vs. DiskANN

Schema design

Streaming DiskANN: How We Made PostgreSQL as Fast as Pinecone for Vector Data

Vector Database Basics: HNSW

Benchmarks

Pgvector vs. Pinecone: Vector Database Performance and Cost Comparison

Nearest Neighbor Indexes: What Are IVFFlat Indexes in Pgvector and How Do They Work

Tutorials

How to Build LLM Applications With Pgvector Vector Store in LangChain How to Implement RAG With Amazon Bedrock and LangChain Retrieval-Augmented Generation With Claude Sonnet 3.5 and Pgvector RAG Is More Than Just Vector Search

Hybrid search & filtering

PostgreSQL Hybrid Search Using Pgvector and Cohere Implementing Filtered Semantic Search Using Pgvector and JavaScript Refining Vector Search Queries With Time Filters in Pgvector: A Tutorial

Semantic search

Fundamentals

Understanding Semantic Search What Is Vector Search? Vector Search vs Semantic Search When Should You Use Full-Text Search vs. Vector Search?

Image search

Building an AI Image Gallery With OpenAI CLIP, Claude Sonnet 3.5, and Pgvector

AI query interfaces

Text-to-SQL: A Developer’s Zero-to-Hero Guide

Retrieval-Augmented Generation With Claude Sonnet 3.5 and Pgvector | Tiger Data