Why is ORM (Object-Relational Mapping) considered peripheral in development?

ORM (Object-Relational Mapping) is not on the periphery of development. It is a widely used tool, especially in web frameworks, to simplify interaction with relational databases. It may seem peripheral when working with low-level database access or in specific high-load systems where maximum performance and full control over SQL queries are critical.

Advantages of ORM:

• Abstraction: Allows working with data as objects, hiding SQL details.
• Development speed: Reduces the amount of boilerplate code for CRUD operations.
• Security: Often includes protection against SQL injection.
• Portability: Facilitates switching between different DBMSs (although full portability is rarely achieved).
• Maintainability: Improves code readability and supportability.

Disadvantages of ORM:

• Performance: Can generate suboptimal SQL queries.
• Complexity: Learning and proper use of ORM requires time.
• Limitations: Not always suitable for complex aggregations or specific queries.
• "N+1 query problem": A common performance issue related to lazy loading.

Typical ORMs for Node.js:

ORM	Description
Sequelize	A powerful and popular ORM supporting many DBMSs.
TypeORM	Fully written in TypeScript, supports various mapping approaches and DBMSs.
Prisma	Next-generation ORM focusing on strongly typed code and ease of use.

Example of using Sequelize:

// Initializing Sequelize
// const sequelize = new Sequelize('sqlite::memory:'); // Example for in-memory SQLite

// Defining a model
// const User = sequelize.define('User', {
//   firstName: {
//     type: DataTypes.STRING,
//     allowNull: false
//   },
//   lastName: {
//     type: DataTypes.STRING
//   }
// }, {
//   // Other model options go here
// });

// Creating a record
// await User.create({ firstName: 'John', lastName: 'Doe' });

// Finding records
// const users = await User.findAll();
// console.log(JSON.stringify(users, null, 2));

In conclusion, ORM is an important tool in the Node.js developer's arsenal for most applications where convenience and development speed outweigh the need for meticulous query tuning.