3 ms·

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

2 points by bagadurshah 3y ago

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

jo_beef 3y 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://orm.drizzle.team/docs/quick-start https://www.prisma.io/docs/getting-started/quickstart https://www.prisma.io/docs/getting-started/quickstart
- bagadurshah 3y ago
  Yeah, I expected to see these listed with supabase, firebase. Thank you.
smrth 3y ago
SQL Server should do just fine. I use Vitess (MySQL hosted on PlanetScale) with Prisma for my Next app, https://debate.land 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 https://drizle.team. Seems to be a more performant ORM. But for getting started, either will suffice.
- bagadurshah 3y 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.
RadiozRadioz 3y 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 3y 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.

2 points by bagadurshah 3y ago

jo_beef 3y 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://orm.drizzle.team/docs/quick-start https://www.prisma.io/docs/getting-started/quickstart https://www.prisma.io/docs/getting-started/quickstart

bagadurshah 3y ago
Yeah, I expected to see these listed with supabase, firebase. Thank you.

smrth 3y ago

SQL Server should do just fine. I use Vitess (MySQL hosted on PlanetScale) with Prisma for my Next app, https://debate.land 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 https://drizle.team. Seems to be a more performant ORM. But for getting started, either will suffice.

bagadurshah 3y 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.

RadiozRadioz 3y 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 3y 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.