GenCodify Studio Publisher Prisma Client - Database client for publisher service
Prisma client library for the GenCodify Studio Publisher service.
``bash`
npm install @gencodify-studio/publisher-prisma-clientor
pnpm add @gencodify-studio/publisher-prisma-clientor
yarn add @gencodify-studio/publisher-prisma-client
This package provides the Prisma client and utilities for database operations in the GenCodify Studio Publisher.
The package supports multiple ways to configure the database connection:
#### Option 1: Single DATABASE_URL (default)
`bash`
DATABASE_URL="postgresql://user:password@host:5432/database?schema=public"
#### Option 2: Individual environment variables
You can use individual environment variables instead of a single connection string:
| Variable | Description | Default |
|----------|-------------|---------|
| DB_HOST | Database host | - |DB_PORT
| | Database port | 5432 |DB_USER
| or DB_USERNAME | Database user | - |DB_PASSWORD
| | Database password | - |DB_NAME
| or DB_DATABASE | Database name | - |DB_SCHEMA
| | Database schema | (optional) |DB_SSL
| | Enable SSL (true/false) | false |
Example:
`bash`
DB_HOST=studio-database.gencodify-infra
DB_PORT=5432
DB_USER=postgres
DB_PASSWORD=your-password
DB_NAME=gencodify
DB_SCHEMA=public
DB_SSL=true
#### Option 3: Programmatic configuration
`typescript
import { createPrisma } from '@gencodify/publisher-prisma-client';
const prisma = createPrisma({
datasourceUrl: 'postgresql://user:password@host:5432/database',
timeout: 5000,
maxWait: 2000,
});
`
Set DEBUG_DB=true to log connection info (password is masked):
`bash`
DEBUG_DB=true node your-app.jsOutput: [Prisma] Connecting to: postgresql://user:**@host:5432/database
`bash`
pnpm generate
`bash``
pnpm migrations
- Prisma 5.12.1
- zod for schema validation
- umzug for migration management
- nanoid for ID generation
MIT