13

I have a production project to develop. It's an e-commerce site. My current stack:

  1. Node.js
  2. TypeScript
  3. PostgreSQL

Now I have to choose an ORM for this project. I think I have two options:

  1. TypeORM. I've used this ORM before. It's good and stable software, but TypeORM has had maintenance issues for a while. I'm not sure about the future of this ORM.
  2. MikroORM. TypeORM lacks some useful features like @Filters (scopes) and bulk subscribers, while MikroORM on the other hand has these features or alternatives (see filters and alternative to bulk subscribers). But MikroORM is less popular and relatively new. And many of MikroORM's features are still in alpha

Summary

ORM with lack of maintenance and features but stable or ORM with great maintenance, new features, but not battle-tested. Which option is better? Or maybe there are some alternatives?

Mike
  • 613
  • 1
  • 10
  • 20

3 Answers3

13

You can check Sequelize - https://sequelize.org, it has a TypeScript support, but the syntax is kind of ugly in my opinion. Among the three, Sequelize is the most mature ORM.

TypeORM is very nice, but has some major bugs like this - https://github.com/typeorm/typeorm/issues/3095. I came across to same or maybe similar problem related with saving one to many relations which i think is one of the most important features of every ORM and it must works properly.

I used MikroORM for a while - Again there are some minor problems which fortunately will be fixed in version 4. Overall, most of the features works properly and almost all of the problems that i had was resolved very quickly after reporting them on github.

Nikolay
  • 330
  • 2
  • 10
6

I recommend Prisma, a new NodeJS ORM with great features and documentation.

Stephen
  • 171
  • 3
  • 3
  • 1
    DId you use it with a REST-API? I have a pretty hard time with it atm, when I want to use it's interfaces in a typescript client – J. Doe Jun 27 '21 at 12:26
  • I have bad experience using this. It has bugs that already fixed in the previous version long time ago but it happened again int the new version. Now still looking for the better option, less of bugs is my priority. – azwar_akbar Mar 02 '22 at 04:40
1

there are a orm named @gradii/fedaco. code converted from laravel eloquent. currently still in wip

actually right now I have no time and interest take long time to maintain this project. typescript code and part of test is not published to public.

xsilen T
  • 1,515
  • 14
  • 10