Ask HN: I'm Confused about using ORM with Front end Frameworks

2 points by bagadurshah 3 years ago | 6 comments

Coming From .NET Core Background, I'm beginner for Javascript Frameworks. I just wanted to know whether to use SQL Server as my database to back my Next.js Project or Can I use any of the existing ORM Services that are provided such as Prisma or Supabase or something?. If so, which is the most widely used ORM for Javascript Frameworks? Help me here please :)

Thanks

smrth 3 years ago |

SQL Server should do just fine. I use Vitess (MySQL hosted on PlanetScale) with Prisma for my Next app, https://debate.land. It works just fine with scale, but I have found myself turning to writing some raw SQL queries to optimize performance/run some nuanced aggregations that Prisma doesn't seem to have a way to handle. If I had to do it again, I'd probably use https://drizle.team. Seems to be a more performant ORM. But for getting started, either will suffice.

bagadurshah 3 years ago | |

I could use Sql Server But, JS World has many different options to choose from, I want to try something new, that's why I asked this one. anyways, thank you for the response.

jo_beef 3 years ago |

I rarely see SQL Server being used alongside Next.js. But Prisma is quite popular in js land. There's also DrizzleORM, which is still relatively new. I'd recommend spending some time exploring both to see what fits you best :)

https://orm.drizzle.team/docs/quick-start

https://www.prisma.io/docs/getting-started/quickstart

bagadurshah 3 years ago | |

Yeah, I expected to see these listed with supabase, firebase. Thank you.

RadiozRadioz 3 years ago |

You can definitely use SQL Server for your JS project, but do note that the general web "culture" is different to .NET's. Most people here are running Open Source stuff like PostgreSQL and MySQL, you're likely to find guides assuming as much. In JS specifically, NoSQL tools like MongoDB are popular and good if they align with your use case.

Side note: this feels more like a Stack Overflow question than an Ask HN post.

bagadurshah 3 years ago | |

Thank you for your response, I was looking which ORM is mostly used by devs as per HN, that's why I asked here.