cheatsheets

Commands I actually use.

Short cheatsheets for day-to-day production work. Every command says what it is for, and your project’s values are set once.

Articles, projects and cheatsheets are written in Spanish.

gcp62 commands · 14 sections

GCP Cloud Run & Ops

Comandos para operar Cloud Run: logs, build y push a Artifact Registry, despliegues, Cloud SQL y Secret Manager.

gcloud auth logingcloud config set project PROJECT_ID

gcpcloud-rundocker

laravel63 commands · 13 sections

Laravel en Producción: Colas, Supervisor y Logs

Comandos para operar Laravel en un servidor: workers con Supervisor, colas pendientes, logs, permisos de storage y caché de configuración.

php artisan tinker>>> array_keys(config('queue.connections'));

laravellinuxsysadmin

linux51 commands · 13 sections

Linux & Sysadmin

Comandos de Linux para el día a día en un servidor: logs, crontab, procesos, puertos, copias y permisos.

journalctl -u nginx.service -fjournalctl --since "2 hours ago"

linuxsysadminbash

sql32 commands · 11 sections

SQL para Data & Analítica

Consultas SQL para analizar datos y acelerar informes: agregados, JOINs, CTEs, funciones de ventana, upserts e índices.

SELECT pais, tipo_suscripcion, COUNT(DISTINCT cliente_id) AS total_clientes, SUM(importe_total) AS ingresos FROM facturacion WHERE estado = 'PAGADO' AND fech…

SELECT c.id, c.email, c.fecha_registro FROM clientes c LEFT JOIN pedidos p ON c.id = p.cliente_id WHERE p.id IS NULL;

sqlanalíticarendimiento