Up to 1000x faster database queries with
Accelerate
->
Sign up for Early Access
Product
Prisma ORM
Client
Write Queries the way you think
Migrate
Generate customisable SQL migrations
Prisma Data Platform
Accelerate
early access
Query up to 1000x faster
Data Browser
Explore and manipulate data in your projects
Data Proxy
Manage and scale your connection pool
Docs
Developer
Get Started
Tutorials
Playground
Prisma Examples
Prisma in your Stack
Support
Ecosystem
Community
Data Guide
Prisma
Playground
Use Cases
Customer Stories
Learn about applications built with Prisma
Enterprise
Up-level your applications with our Data Platform
Company
About
Blog
Careers
Events
Causes
Latest from the blog
Get Started
Sitemap
Main site
Prisma - Database tools for modern application development
About Prisma
Prisma Migrate - Hassle-free database migrations
Prisma Studio - Explore and manipulate your data
Community - Prisma
TypeScript & Prisma
Next.js | Prisma
GraphQL | Prisma
Apollo | Prisma
NestJS | Prisma
Express | Prisma
Hapi | Prisma
Jobs at Prisma
Prisma Ambassador Program
Prisma Day 2021
Prisma Day 2020
Prisma Day 2019
Prisma Serverless Conf 2021
Prisma Enterprise Event 2021
Documentation
Get started
Concepts
Guides
System requirements
Reference
About
Static egress IP addresses
Manage data with Data Browser
Test and run queries with Query Console
Manage schema updates with Schema Viewer
Account
Contact Support
Prisma Data Platform
Set up Prisma
Why Prisma? Comparison with SQL query builders & ORMs
Overview
What is introspection? (Reference)
Prisma Studio (Reference)
Components
PostgreSQL database connector (Reference)
MySQL database connector (Reference)
SQLite database connector (Reference)
MongoDB database connector
CockroachDB database connector (Reference)
Database connectors
Telemetry (Reference)
Telemetry and Editor Setup
Seeding your database
Schema prototyping with db push
Patching / hotfixing a database in production
Migration troubleshooting in production
How to use Prisma with multiple database schemas
How to use Prisma's type system
Using Prisma with CockroachDB
Database (Guides)
Using Prisma with MongoDB
Metrics
Query tracing
Transactions
Performance and optimization
Editor and IDE setup
Development environment
Integration testing with Prisma
Testing with Prisma
Unit testing with Prisma
Deploying projects using Prisma to the cloud
Deploying database changes with Prisma Migrate
Deploy a Node.js application with Prisma
Upgrading to use Preview features (Guides)
Upgrading (Guides)
How to migrate from TypeORM to Prisma
How to migrate from Sequelize to Prisma
How to migrate from Mongoose to Prisma
Migrate to Prisma (Guides)
Prisma error message reference (Reference)
Prisma CLI Command Reference
Prisma environment variables reference
API Reference
Database features matrix (Reference)
Connection URLs (Reference)
Databases supported by Prisma
Database Reference
ORM releases and maturity levels
Ready-to-run examples for various Prisma use cases
Prisma Roadmap – See what we are working on next
Prisma FAQs
Limitations
About Prisma
About the Prisma documentation
Writing template (About)
About Prisma docs
Prisma Data Platform maturity levels
Platform limits and status
About the Prisma Data Platform
Configure Data Proxy for your database application
Deploy with the Data Proxy
Use Prisma Migrate and Introspect with the Data Proxy
Data Proxy considerations and limitations
Data Proxy
Edit project settings in the Prisma Data Platform
Create a project in the Prisma Data Platform
Delete a project in the Prisma Data Platform
Projects in the Prisma Data Platform
View all environments in a project in the Prisma Data Platform
Create a new environment for a project in the Prisma Data Platform
Environments
Delete a project environment in the Prisma Data Platform
Roles and permissions
Add a team member
Change the role of a team member
Remove a team member
Plans and quotas
Team members
Manage plans
Invoices
Data Proxy usage notifications
Payment method and billing information
Billing
Connection to database timed out
Cannot change the database of an environment
Cannot edit the Prisma schema in the Prisma Data Platform
Schema file does not update in the Prisma Data Platform
Troubleshooting
Start from scratch with Prisma
Data modeling with Prisma
What is Prisma? (Overview)
Building REST APIs with Prisma
Building GraphQL servers with Prisma
Is Prisma an ORM? | What is an ORM?
How Prisma fits into your stack
Data sources (Reference)
Generators (Reference)
Names in the underlying database
Supporting features without a PSL equivalent
Data model (Reference)
How to include views in your Prisma schema
How to represent PostgreSQL extensions in your Prisma schema
Indexes
Prisma schema (Reference)
CRUD (Reference)
Select fields (Concepts)
Relation queries (Concepts)
Filtering and sorting (Concepts)
Pagination (Reference)
Aggregation, grouping, and summarizing (Concepts)
Composite types
Transactions and batch queries (Reference)
Full-text search (Preview)
Custom validation
Computed fields
Excluding fields
Custom models
Case sensitivity (Reference)
Null and undefined (Reference)
Query optimization
Using Prisma with PlanetScale
Should you use Prisma as a Node.js/TypeScript ORM?
Debugging (Reference)
Raw database access (Reference)
Module bundlers (Reference)
Database polyfills (Concepts)
Handling exceptions and errors (Reference)
Metrics (Preview)
OpenTelemetry tracing (Preview)
Prisma Client
A mental model for Prisma Migrate
Get started with Prisma Migrate
About migration histories
Legacy Prisma Migrate (Reference)
Prisma Migrate in development and production
Supported database types and features
Prototype your schema
About the shadow database
Prisma Migrate limitations and known issues
Prisma Migrate | Database, Schema, SQL Migration Tool
Prisma CLI Installation (Reference)
Prisma CLI
Query engine (Concepts)
Prisma engines
Prisma Client and Prisma schema preview features
Prisma CLI preview features
Preview features (Reference)
SQL Server on Windows
SQL Server on Docker
Microsoft SQL Server
Prisma vs TypeORM
Prisma vs Sequelize
Prisma vs Mongoose
Comparing Prisma to other ORMs and ODMs.
Adding Prisma Migrate to an existing project
Team development with Prisma Migrate
Baselining a database
Enable PostgreSQL extensions for native database functions
Include unsupported database features
Customize a migration file
Squashing migrations
Generating down migrations
Migration troubleshooting in development
Developing with Prisma Migrate
Creating bug reports for Prisma
Connection management (Guide)
Managing .env files and setting variables
Using multiple .env files.
Environment variables
How to deploy a REST API to Azure Functions with Azure SQL
Deploy a Prisma app to Heroku
Deploy a Prisma app to Koyeb
Deploy to Vercel
Deploy to AWS Lambda
Deploying to Cloudflare Workers
Deploy to Netlify
Deploy to Deno Deploy
Deploying migrations from a local environment
Deploying to a different OS
Caveats when deploying to AWS platforms
Prisma and the Serverless Framework
Platforms Prisma supports for deployment
Upgrade to Prisma 4
Codemods (Guides)
Upgrading versions (Guides)
How to upgrade from Prisma 1 to Prisma version 2.x and later
Schema Incompatibilities | PostgreSQL
Schema Incompatibilities | MySQL
Upgrading the Prisma layer to Prisma 2 | PostgreSQL
Upgrading the Prisma layer to Prisma 2 | MySQL
Upgrade Prisma 1 with nexus-prisma to @nexus/schema
Upgrading from Prisma 1 with prisma-binding to Nexus
Upgrading from Prisma 1 with prisma-binding to SDL-first
Upgrading a REST API from Prisma 1 to Prisma 2
Upgrade from the Prisma 1 MongoDB Beta to Prisma 2 or later
Upgrade from Prisma 1 to Prisma 2
Prisma docs style guide: writing style
Prisma docs style guide: word choice
Prisma docs style guide: spelling, punctuation, and formatting
Prisma docs style guide: example data model
Prisma docs style guide: image guidelines
Prisma docs style guide: GUI guidelines
Boilerplate content
Prisma documentation style guide
MDX components in the Prisma docs
Front matter
Prisma documentation components
Change the environment name and URL handle for a project in the Prisma Data Platform
Change the default project environment in the Prisma Data Platform
Edit environment settings
Connect your database | typescript-postgres
Connect your database | typescript-mysql
Connect your database | typescript-sqlserver
Connect your database | typescript-planetscale
Connect your database | typescript-cockroachdb
Connect your database | node-postgres
Connect your database | node-mysql
Connect your database | node-sqlserver
Connect your database | node-planetscale
Connect your database | node-cockroachdb
Using Prisma Migrate | typescript-postgres
Using Prisma Migrate | typescript-mysql
Using Prisma Migrate | typescript-sqlserver
Using Prisma Migrate | typescript-planetscale
Using Prisma Migrate | typescript-cockroachdb
Using Prisma Migrate | node-postgres
Using Prisma Migrate | node-mysql
Using Prisma Migrate | node-sqlserver
Using Prisma Migrate | node-planetscale
Using Prisma Migrate | node-cockroachdb
Install Prisma Client | typescript-postgres
Install Prisma Client | typescript-mysql
Install Prisma Client | typescript-sqlserver
Install Prisma Client | typescript-planetscale
Install Prisma Client | typescript-cockroachdb
Install Prisma Client | node-postgres
Install Prisma Client | node-mysql
Install Prisma Client | node-sqlserver
Install Prisma Client | node-planetscale
Install Prisma Client | node-cockroachdb
Next steps | typescript-postgres
Next steps | typescript-mysql
Next steps | typescript-sqlserver
Next steps | typescript-planetscale
Next steps | typescript-cockroachdb
Next steps | node-postgres
Next steps | node-mysql
Next steps | node-sqlserver
Next steps | node-planetscale
Next steps | node-cockroachdb
Querying the database | typescript-postgres
Querying the database | typescript-mysql
Querying the database | typescript-sqlserver
Querying the database | typescript-planetscale
Querying the database | typescript-cockroachdb
Querying the database | node-postgres
Querying the database | node-mysql
Querying the database | node-sqlserver
Querying the database | node-planetscale
Querying the database | node-cockroachdb
Prisma docs style guide: Prisma product and component names
Connect your database | typescript-mongodb
Connect your database | node-mongodb
Start from scratch with relational databases (15 min) | typescript-postgres
Start from scratch with relational databases (15 min) | typescript-mysql
Start from scratch with relational databases (15 min) | typescript-sqlserver
Start from scratch with relational databases (15 min) | typescript-planetscale
Start from scratch with relational databases (15 min) | typescript-cockroachdb
Start from scratch with relational databases (15 min) | node-postgres
Start from scratch with relational databases (15 min) | node-mysql
Start from scratch with relational databases (15 min) | node-sqlserver
Start from scratch with relational databases (15 min) | node-planetscale
Start from scratch with relational databases (15 min) | node-cockroachdb
Creating the Prisma schema | typescript-mongodb
Creating the Prisma schema | node-mongodb
Install Prisma Client | typescript-mongodb
Install Prisma Client | node-mongodb
Querying the database | typescript-mongodb
Querying the database | node-mongodb
Next steps | typescript-mongodb
Next steps | node-mongodb
Start from scratch with MongoDB (15 min) | typescript-mongodb
Start from scratch with MongoDB (15 min) | node-mongodb
Connect your database | typescript-postgres
Connect your database | typescript-mysql
Connect your database | typescript-sqlserver
Connect your database | typescript-planetscale
Connect your database | typescript-cockroachdb
Connect your database | node-postgres
Connect your database | node-mysql
Connect your database | node-sqlserver
Connect your database | node-planetscale
Connect your database | node-cockroachdb
Baseline your database | typescript-postgres
Baseline your database | typescript-mysql
Baseline your database | typescript-sqlserver
Baseline your database | typescript-cockroachdb
Baseline your database | node-postgres
Baseline your database | node-mysql
Baseline your database | node-sqlserver
Baseline your database | node-cockroachdb
Install Prisma Client | typescript-postgres
Install Prisma Client | typescript-mysql
Install Prisma Client | typescript-sqlserver
Install Prisma Client | typescript-planetscale
Install Prisma Client | typescript-cockroachdb
Install Prisma Client | node-postgres
Install Prisma Client | node-mysql
Install Prisma Client | node-sqlserver
Install Prisma Client | node-planetscale
Install Prisma Client | node-cockroachdb
Querying the database | typescript-postgres
Querying the database | typescript-mysql
Querying the database | typescript-sqlserver
Querying the database | typescript-planetscale
Querying the database | typescript-cockroachdb
Querying the database | node-postgres
Querying the database | node-mysql
Querying the database | node-sqlserver
Querying the database | node-planetscale
Querying the database | node-cockroachdb
Evolve your Prisma schema with Prisma Migrate | typescript-postgres
Evolve your Prisma schema with Prisma Migrate | typescript-mysql
Evolve your Prisma schema with Prisma Migrate | typescript-sqlserver
Evolve your Prisma schema with Prisma Migrate | typescript-cockroachdb
Evolve your Prisma schema with Prisma Migrate | node-postgres
Evolve your Prisma schema with Prisma Migrate | node-mysql
Evolve your Prisma schema with Prisma Migrate | node-sqlserver
Evolve your Prisma schema with Prisma Migrate | node-cockroachdb
Introspection | typescript-postgres
Introspection | typescript-mysql
Introspection | typescript-sqlserver
Introspection | typescript-planetscale
Introspection | typescript-cockroachdb
Introspection | node-postgres
Introspection | node-mysql
Introspection | node-sqlserver
Introspection | node-planetscale
Introspection | node-cockroachdb
Next steps | typescript-postgres
Next steps | typescript-mysql
Next steps | typescript-sqlserver
Next steps | typescript-planetscale
Next steps | typescript-cockroachdb
Next steps | node-postgres
Next steps | node-mysql
Next steps | node-sqlserver
Next steps | node-planetscale
Next steps | node-cockroachdb
Add Prisma to an existing project that uses a relational database (15 min) | typescript-postgres
Add Prisma to an existing project that uses a relational database (15 min) | typescript-mysql
Add Prisma to an existing project that uses a relational database (15 min) | typescript-sqlserver
Add Prisma to an existing project that uses a relational database (15 min) | typescript-planetscale
Add Prisma to an existing project that uses a relational database (15 min) | typescript-cockroachdb
Add Prisma to an existing project that uses a relational database (15 min) | node-postgres
Add Prisma to an existing project that uses a relational database (15 min) | node-mysql
Add Prisma to an existing project that uses a relational database (15 min) | node-sqlserver
Add Prisma to an existing project that uses a relational database (15 min) | node-planetscale
Add Prisma to an existing project that uses a relational database (15 min) | node-cockroachdb
Connect your database | typescript-mongodb
Connect your database | node-mongodb
Introspection | typescript-mongodb
Introspection | node-mongodb
Install Prisma Client | typescript-mongodb
Install Prisma Client | node-mongodb
Querying the database | typescript-mongodb
Querying the database | node-mongodb
Next steps | typescript-mongodb
Next steps | node-mongodb
Add Prisma to an existing MongoDB project (15 min) | typescript-mongodb
Add Prisma to an existing MongoDB project (15 min) | node-mongodb
One-to-one relations
One-to-many relations
Many-to-many relations
Self-relations
Manage relations between records with relation modes in Prisma
Troubleshooting relations
Relations (Reference)
Generating the client (Concepts)
Instantiating the client (Concepts)
Using custom model and field names (Concepts)
Connecting and disconnecting (Concepts)
Connection pool
Configuring logging (Concepts)
Configuring error formatting (Concepts)
Working with PrismaClient (Concepts)
Working with Json fields (Concepts)
Working with scalar lists/arrays (Concepts)
Working with fields (Concepts)
Operating against partial structures of your model types
Prisma validator
Advanced type safety (Reference)
Middleware sample: soft delete (Reference)
Middleware sample: logging (Reference)
Middleware sample: session data (Reference)
Middleware (Reference)
Prisma Client extensions: model component (Preview)
Prisma Client extensions: client component (Preview)
Prisma Client extensions: query component (Preview)
Prisma Client extensions: result component (Preview)
Shared Prisma Client extensions (Preview)
Prisma Client extensions (Preview)
Modeling and querying many-to-many relations
Autocompletion in GraphQL resolvers with JavaScript
Querying models based on their relations existence
Best practice for instantiating PrismaClient with Next.js
Solve ENOENT package error with vercel/pkg
Compare columns of the same table with raw queries
Help articles
Data validation with CHECK constraints (PostgreSQL)
Advanced data validation (Guides)
Named constraints upgrade path
Referential actions upgrade path
Special rules for referential actions in SQL Server and MongoDB
Referential actions
Troubleshooting
Upgrade to Prisma 3
Advanced database tasks (Guides)
Configure Prisma Client with PgBouncer
Prisma schema API (Reference)
Prisma Client API (Reference)
Blog
Connections, Edges & Nodes in Relay
GraphQL Query Parameters - Best Practices for GraphQL API Design
How to build a Real-Time Chat with GraphQL Subscriptions and Apollo 🌍
Improving Performance with Apollo Query Batching
How to use `create-react-native-app` with GraphQL & Apollo
GraphQL SDL — Schema Definition Language
How to use `create-react-app` with GraphQL & Apollo
Relay Modern’s @connection directive
Relay vs Apollo - Comparing GraphQL clients for React apps
New Tooling to Improve Your GraphQL Workflows
Introducing GraphQL Playground
GraphQL vs Firebase
All you need to know about Apollo Client 2
How to enable CORS for Express-GraphQL & Apollo Server
Getting Started with Relay Modern
GraphQL Server Basics: GraphQL Schemas, TypeDefs & Resolvers Explained
GraphQL Server Basics: The Network Layer
How do GraphQL remote schemas work?
GraphQL Schema Stitching explained: Schema Delegation
GraphQL Basics: Demystifying the `info` Argument in GraphQL Resolvers
How to wrap a REST API with GraphQL - A 3-step tutorial
GraphQL Directive Permissions — Authorization Made Easy
Reasons to use GraphQL | Top 5 Reasons Why and How to use GraphQL
Prisma raises $4.5M to build the GraphQL data layer for all databases
Tutorial: Render Props in React Apollo 2.1
Tutorial: Building a Realtime GraphQL Server with Subscriptions
GraphQL Europe 2018: The GraphQL community comes together in Berlin
New Release Process for Prisma
Open Sourcing GraphQL Middleware - Library to Simplify Your Resolvers
How We're Constantly Improving the Performance of Prisma
How Labelbox Supports Vast Machine Learning Needs with Prisma
Prisma Client (Preview): Simplified & Type-safe Database Access
How HyreCar rewrote their app in 60 days with Prisma
Prisma Admin (Beta): A Modern UI to Manage Your Data
The Problems of "Schema-First" GraphQL Server Development
Introducing GraphQL Nexus: Code-First GraphQL Server Development
Announcing Prisma Day
Using GraphQL Nexus with a Database
How Prisma and GraphQL fit together
Prisma 2 is Coming Soon
New Datamodel Syntax: More Schema Control & Simpler Migrations
State of Prisma 2 (December 2019)
The Guild Takes over Development of the GraphQL CLI & Other Libraries
Prisma 2 Preview: Type-safe Database Access & Declarative Migrations
Prisma 2.0 is in Beta: Type-safe Database Access with Prisma Client
Prisma Raises $12M to Build the Next Generation of Database Tools
Backend with TypeScript PostgreSQL & Prisma: Data Modeling & CRUD
Prisma 2.0: Confidence and productivity for your database
How Prisma Supports Database Transactions
Backend with TypeScript, PostgreSQL & Prisma: REST, Validation & Tests
Prisma 2.10 Adds Preview Support for Microsoft SQL Server
Watch the Talks from Prisma Day 2019!
Backend with TypeScript, PostgreSQL & Prisma: CI & Deployment
Prisma Studio - A Visual Interface for Your Database
Backend with TypeScript, PostgreSQL & Prisma: Authentication & Authz
Prisma Migrate Preview - Database Migrations Simplified
Nexus 1.0: A Major Release for Type-Safe, Code-First GraphQL APIs
Learn TypeScript: A Pocketguide Tutorial
Build an App With Svelte and TypeScript
Full Stack Type Safety with Angular, Nest, Nx, and Prisma
Jamstack with Next.js and Prisma
Announcing Tweets for Trees
How iopool refactored their app in less than 6 months with Prisma
Hassle-Free Database Migrations with Prisma Migrate
A Collaborative Data Browser for Your Database on the Web
The Complete ORM for Node.js & TypeScript
What's new in Prisma? (Q1/21)
Application Monitoring Best Practices
5 Tools for Documenting Your Web API
Prisma Ambassador Program — Building A Community of Experts
How Grover Moves Faster with Prisma
Database Access in React Server Components
How Prisma Helps Rapha Manage Their Mobile Application Data
How Poppy Uses Prisma Client to Ship Confidently
New Course: Fullstack App Using Next.js, GraphQL, TypeScript & Prisma
How Prisma Allowed Pearly to Scale Quickly with an Ultra-Lean Team
Prisma Adopts Semantic Versioning (SemVer)
How migrating from Sequelize to Prisma allowed Invisible to scale
What's new in Prisma? (Q2/21)
Prisma 2.27 Adds Preview Support for MongoDB
Microsoft SQL Server Support in Prisma is Production-Ready
Fullstack App With TypeScript, PostgreSQL, Next.js, Prisma & GraphQL: Data Modeling
How Elsevier Piloted an Innovative Publication Process Quickly and Flexibly with Prisma
Database Access in Serverless Environments with the Prisma Data Proxy
Improving the Prisma Visual Studio Code Extension with WebAssembly
Fullstack App With TypeScript, PostgreSQL, Next.js, Prisma & GraphQL: GraphQL API
Announcing Prisma Serverless Data Conference
Type-safe JavaScript with JsDoc
How Tryg has leveraged Prisma to democratize data
How Panther champions talent over geography with Prisma
What's new in Prisma? (Q3/21)
What's new in Prisma? (Q4/21)
Enabling static egress IPs in the Prisma Data Platform
Prisma support for CockroachDB is now in Preview
Improving Prisma Migrate DX with two new commands
Prisma Adds Support for MongoDB — Join Our Launch Week Celebrations 🎉
Fullstack App With TypeScript, PostgreSQL, Next.js, Prisma & GraphQL: Deployment
Fullstack App With TypeScript, PostgreSQL, Next.js, Prisma & GraphQL: Authentication
Fullstack App With TypeScript, PostgreSQL, Next.js, Prisma & GraphQL: Image upload
What's new in Prisma? (Q1/22)
Build A Fullstack App with Remix, Prisma & MongoDB: Project Setup
Build A Fullstack App with Remix, Prisma & MongoDB: Deployment
Build A Fullstack App with Remix, Prisma & MongoDB: CRUD, Filtering & Sorting
Build A Fullstack App with Remix, Prisma & MongoDB: Authentication
Prisma Raises $40M to Build the Application Data Platform
Prisma Support for CockroachDB Is Production Ready 🪳
Build A Fullstack App with Remix, Prisma & MongoDB: Referential Integrity & Image Uploads
The Prisma Data Platform is now Generally Available
Building a REST API with NestJS and Prisma
Announcing Prisma Day 2022! Our First Hybrid Prisma Day.
Building a REST API with NestJS and Prisma: Input Validation & Transformation
Database access on the Edge with Next.js, Vercel & Prisma Data Proxy
Announcing the Prisma FOSS Fund
Prisma Support for Tracing and Metrics Is Now in Preview
What's new in Prisma? (Q2/22)
How Prisma helps Amplication evolutionize backend development
End-To-End Type-Safety with GraphQL, Prisma & React: Frontend
End-To-End Type-Safety with GraphQL, Prisma & React: API Prep
End-To-End Type-Safety with GraphQL, Prisma & React: Codegen & Deployment
End-To-End Type-Safety with GraphQL, Prisma & React: GraphQL API
Monitor Your Server with Tracing Using OpenTelemetry & Prisma
Improving Query Performance with Indexes using Prisma: Introduction
Improving Query Performance with Indexes using Prisma: B-Tree Index
Database Metrics with Prisma, Prometheus & Grafana
Improving Query Performance with Indexes using Prisma: Hash Indexes
Try Prisma: The Fastest Way to Explore Prisma Examples
How TypeScript 4.9 `satisfies` Your Prisma Workflows
Building a REST API with NestJS and Prisma: Error Handling
Prisma Client Just Became a Lot More Flexible
Prisma Playground: An Interactive Learning Experience for Prisma
The Ultimate Guide to Testing with Prisma: Mocking Prisma Client
What's new in Prisma? (Q4/22)
Introducing Accelerate in Early Access
Prisma Is Expanding Its Executive Team
Build a Fully Type-Safe Application with GraphQL, Prisma & React
Build A Fullstack App with Remix, Prisma & MongoDB
Building a fullstack app using TypeScript, PostgreSQL, Next.js, GraphQL and Prisma
Improving query performance with indexes using Prisma
Building a modern backend with TypeScript, PostgreSQL and Prisma
What is Nexus and how to use it to build GraphQL servers?
Building a REST API with NestJS, PostgreSQL, Swagger and Prisma
Restructuring Prisma
Data Guide
What are databases?
Comparing database types: how database types evolved to meet different needs
Introduction to database schemas
Introduction to databases
Intro (don't panic)
Know your problem space
Tables, tuples, types
Correctness and constraints
Making connections
Functional units
In vivo: information ecosystems
Data modeling
Comparing relational and document databases
The benefits of PostgreSQL
Getting to know PostgreSQL
Database types
5 ways to host PostgreSQL databases
Setting up a local PostgreSQL database
Connecting to PostgreSQL databases
How to configure a PostgreSQL database on RDS
How to create and delete databases and tables in PostgreSQL
An introduction to PostgreSQL data types
An introduction to PostgreSQL column and table constraints
Working with dates in PostgreSQL
PostgreSQL
Setting up a local MySQL database
Connecting to MySQL databases
How to create and delete databases and tables in MySQL
An introduction to MySQL data types
5 ways to host MySQL databases
An introduction to MySQL column and table constraints
MySQL
Setting up a local SQLite database
Importing and exporting data in SQLite
Creating and deleting databases and tables with SQLite
Inserting and deleting data with SQLite
How to perform basic queries with `SELECT` with SQLite
How to update existing data with SQLite
SQLite
Setting up a local SQL Server database
Microsoft SQL Server
What is MongoDB?
Connecting to MongoDB databases
Introduction to provisioning MongoDB Atlas
How to manage users and authentication in MongoDB
How to manage authorization and privileges in MongoDB
How to manage databases and collections in MongoDB
How to manage documents in MongoDB
Introduction to MongoDB data types
How to query and filter documents in MongoDB
Introduction to MongoDB indexes
Introduction to MongoDB connection URIs
Introduction to MongoDB transactions
Working with dates and times in MongoDB
How MongoDB encrypts data
Introduction to MongoDB database tools & utilities
How to sort query results in MongoDB
Introduction to MongoDB Aggregation Framework
MongoDB
Top 11 Node.js ORMs, query builders & database libraries in 2022
Top 8 TypeScript ORMs, query builders, & database libraries: evaluating type safety
Database tools
What is connection pooling and how does it work?
Troubleshooting database outages and connection issues
How to spot bottlenecks in performance
Introduction to OLAP and OLTP
Syncing development databases between team members
How microservices and monoliths impact the database
Introduction to database caching
Introduction to testing in production
Introduction to database backup considerations
Introduction to full-text search
Managing databases
Top 13 serverless computing and database providers
Introduction to common serverless challenges
What is serverless?
Serverless glossary
Traditional databases vs serverless databases
The United States' most popular databases by state going into 2022
Serverless architecture
Just for fun
What are database migrations?
What is an ORM?
Comparing SQL, query builders, and ORMs
Strategies for deploying database migrations
Comparing common database infrastructure patterns
What are document databases?
Relational Databases
Document Databases
An introduction to authorization and authentication in PostgreSQL
Using the expand and contract pattern for schema changes
Managing privileges in PostgreSQL with grant and revoke
Configuring PostgreSQL user authentication
Authentication and authorization
How to insert and delete data in PostgreSQL
How to update existing data in PostgreSQL
How to use `INSERT ON CONFLICT` to upsert data in PostgreSQL
Managing roles and role attributes in PostgreSQL
Importing and exporting data in PostgreSQL
Inserting and modifying data
Understanding and using transactions in PostgreSQL
How to filter query results in PostgreSQL
Using joins to combine data from different tables in PostgreSQL
Introduction to optimizing PostgreSQL performance
Reading and querying data
How to use single and double quotes in PostgreSQL
How to create and delete users in PostgreSQL
Introduction to PostgreSQL connection URIs
How to perform basic queries with `SELECT` in PostgreSQL
Short guides
An introduction to authorization and authentication in MySQL
How to manage users and authentication in MySQL
How to use `GRANT` and `REVOKE` to manage privileges in MySQL
How to manage privileges with roles in MySQL
How to update existing data in MySQL
Authentication and authorization
How to insert and delete data in MySQL
How to use `ON DUPLICATE KEY UPDATE` to upsert data in MySQL
Importing and exporting data in MySQL
Understanding and using transactions in MySQL
Inserting and modifying data
How to perform basic queries with `SELECT` in MySQL
How to filter query results in MySQL
Using joins to combine data from different tables in MySQL
Identifying slow queries in MySQL
Profiling and optimizing slow queries in MySQL
Reading and querying data
Tools and utilities
How to create and delete users in MySQL
How check your MySQL configuration for syntax errors
Short guides
Using `mysql_config_editor` to manage MySQL credentials
Introduction to database replication and its benefits
Database replication
Glossary of common database terminology
Setting up a local MongoDB database
Prisma's Data Guide - Articles to make databases more approachable
How to export database and table schemas in SQLite
How to export database and table schemas in MySQL
How to export database and table schemas in PostgreSQL
Product
Client
Migrate
Data Browser
Data Proxy
Pricing
Developers
Docs
Get Started
Prisma Examples
Data Guide
Prisma in your Stack
Support
Community
Data Platform Status
Use Cases
Customer Stories
Enterprise
Company
About
Blog
Careers
Events
Causes
Terms & Privacy
Newsletter
© 2023 Prisma Data, Inc.