Fundamentals

Query PostgreSQL and MongoDB with Prisma ORM. Filter with where, project with select, sort with orderBy, paginate with limit and offset, and iterate large results one record at a time.

Create, update, delete, and upsert records in PostgreSQL and MongoDB with Prisma ORM, and use createAll, updateAll, and deleteAll for bulk writes.

Query one-to-one, one-to-many, and many-to-many relationships with Prisma ORM on PostgreSQL and MongoDB, with diagrams and tested examples.

Group writes atomically with db.transaction() on PostgreSQL, and run multi-document MongoDB transactions with the MongoDB driver.