<p>Based on <a target="_blank" href="https://www.youtube.com/watch?v=4QN1BzxF8wM"><em>I tried 8 different Postgres ORMs</em> by Beyond Fireship</a></p>
<div class="hn-table">
<table>
<thead>
<tr>
<td></td><td><strong>PG</strong></td><td><strong>Postgres.JS</strong></td><td><strong>Knex</strong></td><td><strong>Kysely</strong></td><td><strong>Sequelize</strong></td><td><strong>TypeORM</strong></td><td><strong>Prisma</strong></td><td><strong>Drizzle</strong></td></tr>
</thead>
<tbody>
<tr>
<td>Type</td><td>Raw SQL</td><td>Raw SQL</td><td>Query Builder</td><td>Query Builder</td><td>ORM</td><td>ORM</td><td>ORM</td><td>ORM</td></tr>
<tr>
<td>Supports PostgreSQL</td><td>✅</td><td>✅</td><td>✅</td><td>✅</td><td>✅</td><td>✅</td><td>✅</td><td>✅</td></tr>
<tr>
<td>Supports MySQL</td><td>❌</td><td>❌</td><td>✅</td><td>✅</td><td>✅</td><td>✅</td><td>✅</td><td>✅</td></tr>
<tr>
<td>Supports SQLite</td><td>❌</td><td>❌</td><td>✅</td><td>✅</td><td>✅</td><td>✅</td><td>✅</td><td>✅</td></tr>
<tr>
<td>Has Migrations &amp; Tool for It</td><td>❌</td><td>❌</td><td>✅</td><td>✅</td><td>✅</td><td>✅</td><td>✅</td><td>✅</td></tr>
<tr>
<td>InteliSense (Can Define Types Automatically)</td><td>❌</td><td>❌</td><td>❌</td><td>✅</td><td>❌</td><td>✅</td><td>✅</td><td>✅</td></tr>
</tbody>
</table>
</div>

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) | ❌       | ❌               | ❌             | ✅             | ❌             | ✅           | ✅          | ✅           |


Node.JS ORMs

Senior Developer, Designer, Technologist! 🇮🇷


Senior Developer, Designer, Technologist!

Shahab Movahhedi

Shahab Movahhedi

Node.JS ORMs

	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)	❌	❌	❌	✅	❌	✅	✅	✅