Build backend functionality including generating routes, handling requests/responses, and connecting to databases.
Route Generation
Handling Requests & Responses
Database Connectivity
Backend Best Practices
// Example Express.js route with DB connection
import express from 'express';
import { getUserById } from './services/userService.js';
const router = express.Router();
router.get('/users/:id', async (req, res) => {
try {
const user = await getUserById(req.params.id);
if (!user) return res.status(404).json({ message: 'User not found' });
res.json(user);
} catch (error) {
console.error(error);
res.status(500).json({ message: 'Server error' });
}
});
export default router;
// Example DB service
import db from './db.js';
export async function getUserById(id) {
const result = await db.query('SELECT * FROM users WHERE id = $1', [id]);
return result.rows[0];
}