immigrant-generator-postgres 0.2.0

Immigrant migrations generator for postgres SQL dialect
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27

!!!TEST
scalar embedding = sql"vector(1024)";
table Embeddings {
	embedding @index.opclass(vector_l2_ops).using(ivfflat);
};
!!!UPDATE
scalar embedding = sql"vector(1024)";
table Embeddings {
	embedding @index.opclass(vector_cosine_ops).using(ivfflat);
};
!!!RESULT
-- updated --
CREATE DOMAIN embedding AS vector(1024);
CREATE TABLE embeddings (
	embedding embedding NOT NULL
);
CREATE INDEX embeddings_embedding_idx ON embeddings USING ivfflat(
	embedding vector_l2_ops
);
-- updated --
DROP INDEX embeddings_embedding_idx;
CREATE INDEX embeddings_embedding_idx ON embeddings USING ivfflat(
	embedding vector_cosine_ops
);
-- updated: cleanup schema changes --
DROP TABLE embeddings;
DROP DOMAIN embedding;