Node.js LTS et patterns backend

VérifiéSûr

Runtime Node.js 20 LTS avec Express et TypeScript pour services backend. Couvre ESM, PostgreSQL, async/await et gestion de connexions.

Spar Skills Guide Bot
DeveloppementIntermédiaire
4002/06/2026
Claude Code
#nodejs#backend#express#typescript#postgresql

Recommandé pour

Notre avis

Compétence Node.js 20 LTS pour le développement backend avec Express, TypeScript et PostgreSQL.

Points forts

  • Utilisation des modules ES (ESM) avec TypeScript
  • Gestion des connexions PostgreSQL avec pool
  • Patterns asynchrones et transactions avec rollback
  • Support crypto et Buffer pour la manipulation de données

Limites

  • Spécifique au backend INVOOPAY, nécessite adaptation
  • Ne couvre pas les tests ou le déploiement
  • Dépend de PostgreSQL, non adapté à d'autres bases
Quand l'utiliser

Utilisez cette compétence pour construire un backend Node.js Express avec PostgreSQL et TypeScript.

Quand l'éviter

Ne l'utilisez pas pour du développement frontend ou des environnements sans Node.js.

Analyse de sécurité

Sûr
Score qualité88/100

The skill contains standard Node.js patterns and code examples for backend development. No destructive, exfiltrating, or obfuscated actions are present. Allowed tools include Bash but the skill does not instruct any shell commands.

Aucun point d'attention détecté

Exemples

Set up Node backend
Initialize a new Node.js backend project with Express, TypeScript, and ESM module system.
Database connection pool
Create a PostgreSQL connection pool with pg, handling errors and timeouts.
Transaction with rollback
Implement a database transaction with commit and rollback logic in a Node.js service.

name: node description: | Node.js LTS runtime and server-side JavaScript patterns for INVOOPAY backend. Use when: working with backend services, async operations, crypto, Buffer handling, or Node.js APIs. allowed-tools: Read, Edit, Write, Glob, Grep, Bash

Node Skill

Node.js 20 LTS runtime powering Express + TypeScript backend. Uses ES modules ("type": "module") with tsx for development. PostgreSQL via pg with connection pooling. Sharp for image processing.

Quick Start

Module System (ESM)

// backend/src/server.ts - Entry point
import app from './app.js';           // .js extension required for ESM
import { env } from './config/env.js';

app.listen(env.port, () => {
  console.log(`Backend listening on port ${env.port}`);
});

Environment Configuration

// backend/src/config/env.ts - Validated env with defaults
import dotenv from 'dotenv';
dotenv.config();

const required = (value: string | undefined, fallback?: string) => {
  if (value) return value;
  if (fallback !== undefined) return fallback;
  throw new Error('Missing required environment variable');
};

export const env = {
  port: Number(process.env.PORT ?? 4000),
  dbHost: process.env.DB_HOST ?? 'localhost',
  jwtSecret: required(process.env.JWT_SECRET, 'dev-only-secret'),
  nodeEnv: process.env.NODE_ENV ?? 'development',
};

Database Connection Pool

// backend/src/db/client.ts
import pg from 'pg';
const { Pool } = pg;

export const pool = new Pool({
  host: env.dbHost,
  max: 20,                    // Max connections
  idleTimeoutMillis: 30000,   // Close idle after 30s
  connectionTimeoutMillis: 2000,
});

pool.on('error', (err) => {
  console.error('Unexpected error on idle client', err);
  process.exit(-1);           // Crash on pool errors
});

Key Concepts

| Concept | Usage | Example | |---------|-------|---------| | ESM imports | Always use .js extension | import { x } from './mod.js' | | __dirname | Use import.meta.url | path.dirname(fileURLToPath(import.meta.url)) | | Async/await | All I/O operations | await pool.query(...) | | Buffer | Binary data handling | Buffer.from(data, 'hex') | | crypto | Encryption/hashing | crypto.randomBytes(32) |

Common Patterns

Async Service Method

export const productService = {
  async get(id: number, language: string = 'en') {
    const result = await pool.query(
      'SELECT * FROM products WHERE id = $1', [id]
    );
    if (!result.rows[0]) return null;
    return mapProduct(result.rows[0]);
  }
};

Transaction with Rollback

const client = await pool.connect();
try {
  await client.query('BEGIN');
  await client.query('INSERT ...', [...]);
  await client.query('UPDATE ...', [...]);
  await client.query('COMMIT');
} catch (error) {
  await client.query('ROLLBACK');
  throw error;
} finally {
  client.release();  // Always release!
}

See Also

  • patterns - Async patterns, error handling
  • types - TypeScript integration
  • modules - Project structure, imports
  • errors - Error handling patterns

Related Skills

For Express routes and middleware, see the express skill. For database queries, see the postgresql skill. For TypeScript patterns, see the typescript skill.

Skills similaires