AnalyticDB
AnalyticDB for PostgreSQL 是一種大規模平行處理 (MPP) 資料倉儲服務，專為線上分析大量資料而設計。
AnalyticDB for PostgreSQL是基於開源的Greenplum Database項目開發，並由Alibaba Cloud進行深入擴展。 AnalyticDB for PostgreSQL 兼容 ANSI SQL 2003 語法以及 PostgreSQL 和 Oracle 資料庫生態系統。 AnalyticDB for PostgreSQL 還支援行儲和列儲。 AnalyticDB for PostgreSQL 以高性能離線處理 PB 級別的資料，並支援高併發的線上查詢。
您需要使用 pip install -qU langchain-community 安裝 langchain-community 才能使用此整合
本筆記本展示了如何使用與 AnalyticDB 向量資料庫相關的功能。 要執行，您應該有一個 AnalyticDB 實例正在運行
- 使用 AnalyticDB Cloud Vector Database。點擊此處快速部署。
from langchain_community.vectorstores import AnalyticDB
from langchain_openai import OpenAIEmbeddings
from langchain_text_splitters import CharacterTextSplitter
透過呼叫 OpenAI API 來分割文件並取得嵌入 (embeddings)
from langchain_community.document_loaders import TextLoader
loader = TextLoader("../../how_to/state_of_the_union.txt")
documents = loader.load()
text_splitter = CharacterTextSplitter(chunk_size=1000, chunk_overlap=0)
docs = text_splitter.split_documents(documents)
embeddings = OpenAIEmbeddings()
API 參考：TextLoader
透過設定相關的 ENVIRONMENTS 連接到 AnalyticDB。
export PG_HOST={your_analyticdb_hostname}
export PG_PORT={your_analyticdb_port} # Optional, default is 5432
export PG_DATABASE={your_database} # Optional, default is postgres
export PG_USER={database_username}
export PG_PASSWORD={database_password}
然後將您的嵌入 (embeddings) 和文件儲存到 AnalyticDB 中
import os
connection_string = AnalyticDB.connection_string_from_db_params(
driver=os.environ.get("PG_DRIVER", "psycopg2cffi"),
host=os.environ.get("PG_HOST", "localhost"),
port=int(os.environ.get("PG_PORT", "5432")),
database=os.environ.get("PG_DATABASE", "postgres"),
user=os.environ.get("PG_USER", "postgres"),
password=os.environ.get("PG_PASSWORD", "postgres"),
)
vector_db = AnalyticDB.from_documents(
docs,
embeddings,
connection_string=connection_string,
)
查詢和檢索數據
query = "What did the president say about Ketanji Brown Jackson"
docs = vector_db.similarity_search(query)
print(docs[0].page_content)
Tonight. I call on the Senate to: Pass the Freedom to Vote Act. Pass the John Lewis Voting Rights Act. And while you’re at it, pass the Disclose Act so Americans can know who is funding our elections.
Tonight, I’d like to honor someone who has dedicated his life to serve this country: Justice Stephen Breyer—an Army veteran, Constitutional scholar, and retiring Justice of the United States Supreme Court. Justice Breyer, thank you for your service.
One of the most serious constitutional responsibilities a President has is nominating someone to serve on the United States Supreme Court.
And I did that 4 days ago, when I nominated Circuit Court of Appeals Judge Ketanji Brown Jackson. One of our nation’s top legal minds, who will continue Justice Breyer’s legacy of excellence.