Skip to content

Latest commit

 

History

History
66 lines (46 loc) · 3.3 KB

deploy-database.md

File metadata and controls

66 lines (46 loc) · 3.3 KB

Connecting Your Database for Enhanced Features:

This guide outlines the database options and setup steps for enabling features like Chat Link Sharing in your application.

Choose Your Database:

1. Serverless Postgres (default):

  • Available on Vercel, Neon, and other platforms.
  • Less feature-rich but a suitable option depending on your needs.
  • Connection String: Replace placeholders with your Postgres credentials.

2. MongoDB Atlas (alternative):

  • Highly Recommended: More than a database, it's a data platform. MongoDB Atlas is a robust cloud-based platform that offers scalability, security, and a suite of developer tools. No need for a separate vector database, you can query your vector embeddings right within your operational database!
  • Additional Features: MongoDB Atlas is packed with unique features designed to streamline the development process such as: Atlas App Services, Atlas search (with vector search), Atlas charts, Data Federation, and more.
  • Connection String: Replace placeholders with your Atlas credentials.

Environment Variables:

Postgres:

Variable
POSTGRES_PRISMA_URL postgres://USER:[email protected]/SOMEDB?pgbouncer=true&connect_timeout=15
POSTGRES_URL_NON_POOLING (optional) URL for the Postgres database without pooling (specific use cases)

MongoDB:

Variable
MDB_URI mongodb://USER:[email protected]/DATABASE-NAME?retryWrites=true&w=majority

MongoDB Atlas + Prisma

When using MongoDB Atlas, you'll need to make the below changes to the file src/server/prisma/schema.prisma.

...
datasource db {
  provider  = "mongodb"
  url       = env("MDB_URI")
}

//
// Storage of Linked Data
//
model LinkStorage {
  id String @id @default(uuid()) @map("_id")

// ...rest of file

Initial Setup Steps:

  1. Run npx prisma db push: Create or update the database schema (run once after connecting).

Additional Resources: