23 lines
515 B
Markdown
23 lines
515 B
Markdown
|
# youfool-ai-build-demo
|
||
|
|
|
||
|
|
公司AI项目构建DEMO
|
||
|
|
|
||
|
|
## 开发环境
|
||
|
|
|
||
|
|
jdk21
|
||
|
|
|
||
|
|
## 环境准备
|
||
|
|
|
||
|
|
向量存储表创建语句
|
||
|
|
```sql
|
||
|
|
CREATE EXTENSION IF NOT EXISTS vector; -- 数据库打开相关扩展
|
||
|
|
CREATE EXTENSION IF NOT EXISTS hstore;
|
||
|
|
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
|
||
|
|
CREATE TABLE IF NOT EXISTS vector_store (
|
||
|
|
id uuid DEFAULT uuid_generate_v4() PRIMARY KEY,
|
||
|
|
content text,
|
||
|
|
metadata json,
|
||
|
|
embedding vector(1536)
|
||
|
|
);
|
||
|
|
CREATE INDEX ON vector_store USING HNSW (embedding vector_cosine_ops);
|
||
|
|
```
|