Database tutorial - IT technology blog
Posted inDatabase

pgvector Guide: Storing and Searching Vector Embeddings in PostgreSQL for AI and RAG Applications

pgvector is a PostgreSQL extension that lets you store and search vector embeddings directly in your existing database — no need to deploy a separate system. This guide covers installation, HNSW index creation, semantic search, and integrating pgvector into a Python RAG pipeline, with practical monitoring tips from real-world experience.
Artificial Intelligence tutorial - IT technology blog
Posted inAI

Securing AI Service API Keys (OpenAI, Claude, Gemini): A 2 AM Production Lesson

AI service API keys are critical assets requiring strict protection. This guide provides detailed instructions on securing API keys for OpenAI, Claude, and Gemini based on real-world experience, preventing leaks that cause financial damage and service disruption. It covers solutions from environment variables to cloud secret management and service-to-service authentication.