# ORM

Concept · [Technical basics](https://ecosystem.samcarlton.com/technical)

Also called: object-relational mapping, object relational mapper, ORMs

Object-relational mapping. A code library that lets [developers](https://ecosystem.samcarlton.com/software-engineer) work with [database](https://ecosystem.samcarlton.com/database) records as ordinary objects in their [programming language](https://ecosystem.samcarlton.com/tech-stack), without writing database queries by hand.

**For example:** With an ORM, a [developer](https://ecosystem.samcarlton.com/software-engineer) writes customer.orders in code, and the library fetches that customer's orders from the [database](https://ecosystem.samcarlton.com/database).

## Connects to (5)

- [Database](https://ecosystem.samcarlton.com/database): Organized storage for your app's information, such as users, orders and messages, so it can be saved and looked up later.
- [Data model](https://ecosystem.samcarlton.com/data-model): The plan for what information an app stores and how the pieces relate, such as customers, orders and products and which belongs to which.
- [Join table](https://ecosystem.samcarlton.com/join-table): A database table whose only job is to connect two other tables when items on each side can link to many on the other.
- [Back end](https://ecosystem.samcarlton.com/back-end): The part of an app that runs out of sight on a server.
- [Drizzle](https://ecosystem.samcarlton.com/drizzle): An open-source TypeScript library for working with SQL databases such as PostgreSQL and SQLite.

Map view: https://ecosystem.samcarlton.com/orm