What is a Object Relational Mapper 🌱

What is an ORM

Object-relational-mappers allow you to write queries to an SQL (What Database do I use) database using the object-oriented paradigm of your preferred programming language. SQL code can get pretty complicated once you start writing advancedd queries, so using an ORM makes it easier to write complicated queries on your database.

Using an ORM abstracts away the database system so that you can easily switch from say MySQL to PostgreSQL.

  • TypeORM
    • runs in a variety of environments including node.js, React Native, Electron
    • can be used with TypeScript or JavaScript
    • supports MySQL / MariaDB / Postgres / CockroachDB / SQLite / Microsoft SQL Server / Oracle / SAP Hana / sql.js
    • also supports MongoDB NoSQL database
  • Prisma.js
    • Runs with Node.js
    • must be used with Typescript
    • supports PostgreSQL, MySQL, and SQLite databases

NoSQL ORMs

NoSQL Databases have similar tools like ORMs to map objects to the database, but they are specific depending on the type of database. MongoDB for example which is a document based database, has the package mongoose which is called an ODM on the other hand is an Object Document Mapper (ODM).

Notes mentioning this note

How to Build a Full Stack Application
Frontend User interface that displays information and makes calls to the API to update it.
What is GraphQL
REST APIs Traditional REST APIs fetch information about specific resources (a resource could be a user, a blog post, etc.)...

Here are all the notes in this garden, along with their links, visualized as a graph.