PostgreSQL vs MongoDB Comparación

-- PostgreSQL - consulta de usuarios y pedidos
CREATE TABLE users (
  id SERIAL PRIMARY KEY,
  email TEXT UNIQUE NOT NULL,
  profile JSONB,
  created_at TIMESTAMPTZ DEFAULT NOW()
);

CREATE TABLE orders (
  id SERIAL PRIMARY KEY,
  user_id INT REFERENCES users(id),
  total NUMERIC(10,2) NOT NULL,
  status TEXT CHECK (status IN ('pending','paid','shipped'))
);

-- Total por usuario con función window
SELECT u.email,
       SUM(o.total) AS gasto_total,
       RANK() OVER (ORDER BY SUM(o.total) DESC) AS posicion
FROM users u
JOIN orders o ON o.user_id = u.id
GROUP BY u.email;

// MongoDB - operaciones de usuarios y pedidos (Node.js)
import { MongoClient } from 'mongodb';

const client = new MongoClient(process.env.MONGO_URI!);
const db = client.db('shop');

// Estructura de documento flexible — sin migración de esquema
await db.collection('users').insertOne({
  email: '[email protected]',
  profile: { bio: 'Desarrollador', social: { github: 'ali' } },
  createdAt: new Date()
});

// Totales de pedidos con aggregation pipeline
const result = await db.collection('orders').aggregate([
  { $match: { status: 'paid' } },
  { $group: { _id: '$userId', gastoTotal: { $sum: '$total' } } },
  { $sort: { gastoTotal: -1 } },
  { $limit: 10 }
]).toArray();