Huge News!Announcing our $40M Series B led by Abstract Ventures.Learn More
Socket
Sign inDemoInstall
Socket

netlify-plugin-prisma-provider

Package Overview
Dependencies
Maintainers
1
Versions
5
Alerts
File Explorer

Advanced tools

Socket logo

Install Socket

Detect and block malicious and high-risk dependencies

Install

netlify-plugin-prisma-provider

Swap out the schema.prisma provider dynamically at build time

  • 0.3.0
  • latest
  • Source
  • npm
  • Socket score

Version published
Maintainers
1
Created
Source

netlify-plugin-prisma-provider

Currently, if you're using Prisma to talk to your database, there is no way to set the database provider dynamically. The url connection string can be set via ENV var, but not the provider:

// schema.prisma

datasource DS {
  provider = "sqlite"
  url      = env("DATABASE_URL")
}

If you want to use a SQLite database locally, but use Postgres in production, there is no way to swap out the provider "sqlite" for "postgresql" once you go to production—the string for the provider must be present in this file before Prisma generates the client libraries.

Prisma has an open issue for letting you set this value via ENV var but there is no planned release date.

Until then, this plugin will swap out the provider for you right before your code is built on Netlify. You can set your preferred production database provider as an environment variable and it will be swapped into schema.prisma right before the build begins.

NOTE: The plugin will only replace the provider if its value is sqlite. If postgresql or mysql is present then the replacement is skipped. If switching between Postgres and MySQL in development and production is needed, open an issue and I'll update the plugin to support this scenario!

As of Prisma's beta3 release their migration scripts look at the provider in each migration's snapshot of schema.prisma and compare those against the url in the main schema.prisma. If the protocol doesn't match the provider it will raise an error during the migration. Starting in version 0.3.0 of this plugin, we will also replace the provider in each of the migration snapshots' copy of schema.prisma and steps.json.

Usage

Add a [[plugins]] entry to your netlify.toml file:

[[plugins]]
package = 'netlify-plugin-prisma-provider'
  [plugins.inputs]
  path = 'prisma/schema.prisma'
  varName = 'DATABASE_PROVIDER'
namedescriptiondefault
pathThe path to the schema.prisma file, relative to the root of your codebase.prisma/schema.prisma
varNameThe name of the ENV variable that contains the provider name.DATABASE_PROVIDER

Add the environment variable in Netlify with the name you provided varName and a value of postgresql or mysql:

image

If you don't set the environment variable it will assume you want to use postgresql and will replace that in your schema.prisma. If you don't want that to happen then you'll need to remove this plugin completely!

Keywords

FAQs

Package last updated on 01 May 2020

Did you know?

Socket

Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.

Install

Related posts

SocketSocket SOC 2 Logo

Product

  • Package Alerts
  • Integrations
  • Docs
  • Pricing
  • FAQ
  • Roadmap
  • Changelog

Packages

npm

Stay in touch

Get open source security insights delivered straight into your inbox.


  • Terms
  • Privacy
  • Security

Made with ⚡️ by Socket Inc