Sunday, June 11, 2023

Vercel database Prisma setup

 


PrismaClientKnownRequestError:
Invalid `prisma.workspace.findMany()` invocation:
The table `public.workspaces` does not exist in the current database.
at pn.handleRequestError (/vercel/path0/node_modules/@prisma/client/runtime/library.js:176:6477)
at pn.handleAndLogRequestError


npx prisma migrate dev

% npx prisma migrate dev

Environment variables loaded from .env

Prisma schema loaded from prisma/schema.prisma

Datasource "db": PostgreSQL database "verceldb", schema "public" at "ep-delicate-dust-021378.us-east-1.postgres.vercel-storage.com:5432"


Error: P3014


% npx prisma migrate resolve --applied 20220223015914_init_database

Environment variables loaded from .env

Prisma schema loaded from prisma/schema.prisma

Datasource "db": PostgreSQL database "verceldb", schema "public" at "ep-delicate-dust-021378.us-east-1.postgres.vercel-storage.com:5432"

Migration 20220223015914_init_database marked as applied.

% npx prisma migrate resolve --applied 20220508151141_add_domain_verification_columns

Environment variables loaded from .env

Prisma schema loaded from prisma/schema.prisma

Datasource "db": PostgreSQL database "verceldb", schema "public" at "ep-delicate-dust-021378.us-east-1.postgres.vercel-storage.com:5432"

Migration 20220508151141_add_domain_verification_columns marked as applied.



Prisma Migrate could not create the shadow database. Please make sure the database user has permission to create databases. Read more about the shadow database (and workarounds) at https://pris.ly/d/migrate-shadow


Original error:

db error: ERROR: permission denied to create database

   0: schema_core::state::DevDiagnostic

             at schema-engine/core/src/state.rs:266



Put env vars to vercel except VERCEL_ prefixed env vars

The value is not a valid System Environment name


Friday, June 2, 2023

Vector store pricings

 

candidates

https://js.langchain.com/docs/modules/indexes/vector_stores/integrations/


typesense cloud $14.40

https://cloud.typesense.org/pricing



https://qdrant.tech/pricing/





https://www.pinecone.io/pricing/

Free plan is not available for now.




https://weaviate.io/pricing

Standard

from

25 /mo
  • $0.050 per 1M vector dimensions stored
    or queried per month




  • supabase

  • https://supabase.com/blog/openai-embeddings-postgres-vector
  • vercel postgres

  • https://vercel.com/templates/next.js/postgres-pgvector