DEV Community

Abhinav
Abhinav

Posted on

1

๐ŸŒŸ NestJS + Databases: Making Snake Case Seamless!๐Ÿ

When working with databases in NestJS, one common challenge is managing column naming conventionsโ€”specifically converting camelCase in your code to snake_case in the database. Luckily, the solution doesnโ€™t need to be custom code in most cases! ๐Ÿš€

Hereโ€™s how to handle it effectively:

๐Ÿ”น TypeORM: Use a NamingStrategy, like the popular typeorm-naming-strategies package. It automates the conversion of column and table names to snake_case.

import { SnakeNamingStrategy } from 'typeorm-naming-strategies';

const config = {
  namingStrategy: new SnakeNamingStrategy(),
  // Other TypeORM configs
};
Enter fullscreen mode Exit fullscreen mode

๐Ÿ”น Prisma: Simply use the @map directive in your schema to map camelCase fields to snake_case database columns.

model User {
  firstName String @map("first_name")
}
Enter fullscreen mode Exit fullscreen mode

โœจ Pro Tip: While you could build a custom NestJS pipe for this transformation, it's better to rely on your ORM for these mappingsโ€”itโ€™s cleaner and more efficient. Let the ORM do the heavy lifting for database conventions! ๐Ÿ› ๏ธ

Have you faced similar challenges while working with ORMs in NestJS? Let me know how you handled them! ๐Ÿ‘‡

Top comments (0)

A Workflow Copilot. Tailored to You.

Pieces.app image

Our desktop app, with its intelligent copilot, streamlines coding by generating snippets, extracting code from screenshots, and accelerating problem-solving.

Read the docs

๐Ÿ‘‹ Kindness is contagious

Engage with a sea of insights in this enlightening article, highly esteemed within the encouraging DEV Community. Programmers of every skill level are invited to participate and enrich our shared knowledge.

A simple "thank you" can uplift someone's spirits. Express your appreciation in the comments section!

On DEV, sharing knowledge smooths our journey and strengthens our community bonds. Found this useful? A brief thank you to the author can mean a lot.

Okay