Sitemap
- 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
Main site
- 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)
Documentation
- 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
Blog
- 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