Skip to content

Latest commit

 

History

History
98 lines (51 loc) · 6.21 KB

20240311_02.md

File metadata and controls

98 lines (51 loc) · 6.21 KB

PostgreSQL数据库相关AI项目: 向量、机器人、SQL & TEXT 、优化器、配置

作者

digoal

日期

2024-03-11

标签

PostgreSQL , PolarDB , DuckDB , 向量数据库 , 机器人 , SQL & TEXT , 优化器 , 配置


背景

https://github.com/ftisiot/postgresql-ai-projects

List of PostgreSQL® AI projects and resources

A curated list of PostgreSQL® project including or addressing AI

This list includes projects, extensions or demos showcasing how to use PostgreSQL® in the AI landscape

➕ Extensions

  • pgvector: open-source vector similarity search for PostgreSQL. Includes vector storage and similarity search, as well as IVFFlat and HNSW indexing
  • pg_vectorize: open-source PostgreSQL extension that automates the transformation and orchestration of text to embeddings, allowing vector and semantic search on existing data with as little as two function calls.
  • postgresml: Generative AI and Simple ML with PostgreSQL. Perform Text classification, Translation, Summarization directly in SQL within the PostgreSQL database.

💡 Applications

🤖 Bots

📑 Text to SQL and SQL to Text

⚡️ Query Optimizer

  • EverSQL query optimizer: AI-driven query optimizer based on SQL and database metadata. Monitor your database and receive performance insights and improvement suggestions for free

🎛️ Configuration Tuning

  • Ottertune: AI to optimize your Amazon RDS and Aurora database
  • DBTune: AI driven PostgreSQL configuration tuning engine

✏️ Content

👩‍💻Code examples

What's next

Presentation slides

digoal's wechat