Prisma's Data Guide
Menu
Explore Prisma
    • Introduction to databases
      • What are databases?
      • Comparing database types: how database types evolved to meet different needs
      • Introduction to database schemas
      • Glossary of common database terminology
    • Data modeling
      • Intro (don't panic)
      • Know your problem space
      • Tables, tuples, types
      • Correctness and constraints
      • Making connections
      • Functional units
      • In vivo: information ecosystems
    • Database types
      • Comparing relational and document databases
      • Relational Databases
      • Document Databases
    • PostgreSQL
      • The benefits of PostgreSQL
      • Getting to know PostgreSQL
      • 5 ways to host PostgreSQL databases
      • Setting up a local PostgreSQL database
      • How to configure a PostgreSQL database on RDS
      • Connecting to PostgreSQL databases
      • Authentication and authorization
      • 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
      • Inserting and modifying data
      • Reading and querying data
      • Short guides
    • MySQL
      • 5 ways to host MySQL databases
      • Setting up a local MySQL database
      • Connecting to MySQL databases
      • Authentication and authorization
      • How to create and delete databases and tables in MySQL
      • An introduction to MySQL data types
      • An introduction to MySQL column and table constraints
      • Inserting and modifying data
      • Reading and querying data
      • Tools and utilities
      • Short guides
    • SQLite
      • 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
      • How to export database and table schemas in SQLite
    • Microsoft SQL Server
      • Setting up a local SQL Server database
    • MongoDB
      • What is MongoDB?
      • Setting up a local MongoDB database
      • 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
      • How to query and filter documents in MongoDB
      • Introduction to MongoDB data types
      • Introduction to MongoDB indexes
      • Introduction to MongoDB transactions
      • Introduction to MongoDB connection URIs
      • 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
    • Database tools
      • Top 11 Node.js ORMs, query builders & database libraries in 2022
      • Top 8 TypeScript ORMs, query builders, & database libraries: evaluating type safety
      • What is connection pooling and how does it work?
    • Managing databases
      • Troubleshooting database outages and connection issues
      • How to spot bottlenecks in performance
      • Syncing development databases between team members
      • Database replication
      • Introduction to OLAP and OLTP
      • 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
    • Serverless architecture
      • What is serverless?
      • Top 13 serverless computing and database providers
      • Introduction to common serverless challenges
      • Traditional databases vs serverless databases
      • Serverless glossary
    • Just for fun
      • The United States' most popular databases by state going into 2022

Database types

Share on

Overview

Each style of database has its own strengths and weaknesses. Learn more about common database types to help choose which one is best for you.

In this section

  • Comparing relational and document databases
  • Relational Databases
    • What is an ORM?
    • Comparing SQL, query builders, and ORMs
    • What are database migrations?
    • Strategies for deploying database migrations
    • Using the expand and contract pattern for schema changes
    • Comparing common database infrastructure patterns
  • Document Databases
    • What are document databases?
Edit this page on GitHub

Prisma's Data Guide

A growing library of articles focused on making databases more approachable.

Made with ❤️ by Prisma