Databases Flashcards
(3 cards)
ORM
ORM (Object-Relational Mapping) is a way of working with a database that maps tables to objects in code, allowing you to interact with data without writing SQL queries.
Prisma
Prisma is a modern TypeScript ORM that provides type-safe database access and simplifies working with relational databases through an auto-generated query builder.
Works with:
PostgreSQL
MySQL / MariaDB
SQLite
Microsoft SQL Server
Relational database
A relational database is a type of database that stores data in tables (also called relations), where each table consists of rows (records) and columns (fields). Relationships between data are defined using keys, such as primary keys and foreign keys.
PostgreSQL
MySQL / MariaDB
SQLite
Microsoft SQL Server
Oracle