# Node.JS ORMs

Based on [*I tried 8 different Postgres ORMs* by Beyond Fireship](https://www.youtube.com/watch?v=4QN1BzxF8wM)

|                                              | **PG**  | **Postgres.JS** | **Knex**      | **Kysely**    | **Sequelize** | **TypeORM** | **Prisma** | **Drizzle** |
|:---------------------------------------------|:-------:|:---------------:|:-------------:|:-------------:|:-------------:|:-----------:|:----------:|:-----------:|
| Type                                         | Raw SQL | Raw SQL         | Query Builder | Query Builder | ORM           | ORM         | ORM        | ORM         |
| Supports PostgreSQL                          | ✅       | ✅               | ✅             | ✅             | ✅             | ✅           | ✅          | ✅           |
| Supports MySQL                               | ❌       | ❌               | ✅             | ✅             | ✅             | ✅           | ✅          | ✅           |
| Supports SQLite                              | ❌       | ❌               | ✅             | ✅             | ✅             | ✅           | ✅          | ✅           |
| Has Migrations & Tool for It                 | ❌       | ❌               | ✅             | ✅             | ✅             | ✅           | ✅          | ✅           |
| InteliSense (Can Define Types Automatically) | ❌       | ❌               | ❌             | ✅             | ❌             | ✅           | ✅          | ✅           |