Vistas, funciones y extensiones

Encapsula lógica y extiende las capacidades de Postgres

Vistas

CREATE VIEW active_users AS
SELECT id, name, email
FROM users
WHERE deleted_at IS NULL;

Vistas materializadas

CREATE MATERIALIZED VIEW daily_sales AS
SELECT date_trunc('day', created_at) AS day,
       SUM(total) AS revenue
FROM orders
GROUP BY 1;

REFRESH MATERIALIZED VIEW daily_sales;

Funciones

CREATE FUNCTION total_orders(user_id INT)
RETURNS INT AS $$
  SELECT COUNT(*) FROM orders WHERE orders.user_id = $1;
$$ LANGUAGE SQL;

Extensiones populares

• uuid-ossp: generación de UUID
• pg_trgm: búsqueda por similitud
• postgis: consultas geoespaciales

Continuar Aprendiendo

Fundamentos de Node.js →Desarrollo de APIs →Apps en Tiempo Real →