Orm Glossary

Browse 14 orm terms defined in plain English, from the cultural dictionary of computing.

14 Orm Terms

Active Record
Active Record is an object-relational mapping (ORM) design pattern where a database row is wrapped in a class instance, and that object carries both the data...
Drizzle
A TypeScript ORM that positions itself as 'if you know SQL, you know Drizzle.' Unlike Prisma's abstracted query API, Drizzle provides a SQL-like query builder...
Ecto
A database toolkit and query DSL for Elixir that provides schemas, changesets for validation, and composable queries without the 'magic' of traditional ORMs....
Eloquent
Laravel's ActiveRecord-style ORM that maps database tables to PHP model classes, providing an expressive syntax for queries, relationships, and mutations.
Entity Framework
Microsoft's open-source ORM for .NET that lets developers work with databases using C# objects and LINQ queries instead of raw SQL. Entity Framework Core is...
Join Table
An associative table used to represent a many-to-many relationship between two other tables, typically by storing one foreign key to each side. Join tables may...
JPA
The Java Persistence API, a specification for mapping Java objects to relational database tables and managing entity lifecycle, queries, and transactions....
N+1 Query Problem
A performance anti-pattern where code executes 1 query to fetch a list of N items, then N additional queries to fetch related data for each item. Common with...
Prisma
A next-generation ORM (Object-Relational Mapping) for Node.js and TypeScript that replaces traditional ORMs with a type-safe database client generated from a...
Query Builder
A programmatic API that lets developers construct database queries using method chaining or composable objects instead of writing raw SQL strings. Query...
Raw SQL
Hand-written SQL statements executed directly against a database, bypassing an ORM or query builder. Developers drop to raw SQL for complex queries,...
SQLAlchemy
The most widely used Python SQL toolkit and ORM, providing both a low-level Core layer for composing SQL expressions as Python objects and a high-level ORM...
TypeORM
An ORM for TypeScript and JavaScript that maps database tables to classes using decorators, supporting both Active Record and Data Mapper patterns across...
Unit of Work
A design pattern (described by Martin Fowler) that maintains a list of objects affected during a business transaction and coordinates writing out changes as a...

Related Topics