# Descargar el binario
wget https://github.com/your-repo/oxidedb/releases/download/v1.6.0/oxidedb-server

# Dar permisos y mover
chmod +x oxidedb-server
sudo mv oxidedb-server /usr/local/bin/

# Verificar
oxidedb-server --version

# Iniciar servidor (puerto 5433 por defecto)
oxidedb-server --port 5433 --data-dir ./data

# Conectar con psql estándar
psql -h localhost -p 5433 -U oxide -d oxidedb

# Primera consulta
oxidedb=> SELECT 'Hello OxideDB!' as mensaje;
   mensaje
---------------
 Hello OxideDB!
(1 row)

# Conexión básica
psql -h your-server -p 5433 -U oxide -d oxidedb

# Con password (variable de entorno)
PGPASSWORD='your-password' psql -h server -p 5433 -U oxide -d oxidedb

# Ejecutar query directa
psql -h server -p 5433 -U oxide -d oxidedb -c "SELECT COUNT(*) FROM my_table;"

# Desde Python
import psycopg2
conn = psycopg2.connect(host="server", port=5433, user="oxide", dbname="oxidedb")

-- Registrar tabla desde S3 (Parquet)
REGISTER PARQUET 's3://my-bucket/data/*.parquet' AS ventas;

-- Query directa - 5x más rápido que DuckDB
SELECT region, COUNT(*) as total, SUM(monto) as revenue
FROM ventas
WHERE fecha >= '2024-01-01'
GROUP BY region
ORDER BY revenue DESC;

-- 1.9M rows en 0.75 segundos desde S3

-- Registrar tabla Delta Lake
REGISTER DELTA 's3://my-bucket/delta/sales' AS sales_delta;

-- Query normal
SELECT * FROM sales_delta WHERE amount > 1000;

-- Time Travel: consultar versión anterior
SELECT * FROM sales_delta VERSION AS OF 5;

-- Ver historial de versiones
DELTA HISTORY sales_delta;

# Iniciar con Glue Catalog
oxidedb-server --port 5433 \
  --enable-glue-catalog \
  --aws-region us-east-2

# Las tablas del Glue Catalog se descubren automáticamente
psql> \dt
       List of relations
 Schema |     Name      | Type
--------+---------------+-------
 public | sales         | table
 public | customers     | table
 public | orders        | table

-- Funciones de ventana
SELECT
    region,
    ventas,
    LAG(ventas, 1) OVER (ORDER BY fecha) as ventas_anterior,
    RANK() OVER (PARTITION BY region ORDER BY ventas DESC) as ranking
FROM ventas_tabla;

-- Operaciones ROLLUP y CUBE
SELECT
    region,
    producto,
    SUM(ventas) as total
FROM ventas_tabla
GROUP BY ROLLUP(region, producto);  -- Subtotales jerárquicos

SELECT
    region,
    producto,
    SUM(ventas) as total
FROM ventas_tabla
GROUP BY CUBE(region, producto);    -- Todas las combinaciones

-- Agregaciones complejas con SIMD
SELECT
    region,
    COUNT(*) as transacciones,
    SUM(monto) as total_ventas,
    AVG(monto) as promedio,
    PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY monto) as mediana
FROM transacciones
GROUP BY region
HAVING SUM(monto) > 100000;

-- Tipos numéricos (optimizados con SIMD)
INT, BIGINT, FLOAT, DOUBLE, DECIMAL(p,s)

-- Tipos texto
VARCHAR, TEXT, CHAR(n)

-- Tipos temporales
DATE, TIMESTAMP, TIME, INTERVAL

-- Tipos complejos
ARRAY, JSON (próximamente)

-- Query normal: máximo 500 filas (auto-limit)
SELECT * FROM ventas WHERE fecha >= '2024-01-01';
-- ⚠️ AUTO-LIMIT: Added LIMIT 500

-- Con LIMIT explícito: respeta tu límite
SELECT * FROM ventas WHERE fecha >= '2024-01-01' LIMIT 100;
-- Retorna 100 filas

-- Para exportar TODO: usa LIMIT ALL
SELECT * FROM ventas WHERE fecha >= '2024-01-01' LIMIT ALL;
-- 📤 EXPORT MODE: Retorna todas las filas (624,460 rows)

-- Ver estadísticas del cache
SHOW CACHE;
--  metric          |   value
-- -----------------+-----------
--  hits            | 1523
--  misses          | 234
--  hit_rate        | 86.7%
--  current_entries | 45
--  memory_bytes    | 12458 KB

-- Invalidar cache de una tabla específica
REFRESH TABLE ventas;
-- ✅ Cache invalidado para 'ventas'

-- Limpiar todo el cache
CLEAR CACHE;

-- 1. Declarar cursor (ejecuta query y guarda resultado)
DECLARE export_cursor CURSOR FOR
  SELECT * FROM ventas WHERE fecha >= '2024-01-01';
--  status         | cursor_name   | total_rows
-- ----------------+---------------+------------
--  DECLARE CURSOR | export_cursor | 624460

-- 2. Fetch en lotes (sin saturar memoria)
FETCH 1000 FROM export_cursor;  -- Primeras 1000 filas
FETCH 1000 FROM export_cursor;  -- Siguientes 1000 filas
FETCH ALL FROM export_cursor;   -- Resto de filas

-- 3. Cerrar cursor cuando termines
CLOSE export_cursor;

# Exportar directamente a CSV (streaming, sin límite de memoria)
psql -h server -p 5433 -U oxide -d oxidedb \
  -c "\copy (SELECT * FROM ventas WHERE fecha >= '2024-01-01' LIMIT ALL) TO '/tmp/export.csv' CSV HEADER"

# O usando cursores para control fino
psql -h server -p 5433 -U oxide -d oxidedb << 'EOF'
DECLARE c CURSOR FOR SELECT * FROM ventas;
\copy (FETCH 100000 FROM c) TO 'batch1.csv' CSV HEADER
\copy (FETCH 100000 FROM c) TO 'batch2.csv' CSV HEADER
CLOSE c;
EOF

oxidedb-server [OPTIONS]

Opciones:
  -p, --port <PORT>           Puerto TCP [default: 5432]
  -H, --host <HOST>           Dirección bind [default: 0.0.0.0]
  -d, --data-dir <DIR>        Directorio de datos [default: /var/lib/oxidedb]
  -w, --workers <NUM>         Threads de trabajo [default: CPUs detectadas]
  -v, --verbose               Logging detallado
      --max-memory <MB>       Memoria máxima [default: 4096]
      --batch-size <SIZE>     Tamaño batch SIMD [default: 4096]
      --simd-level <LEVEL>    Nivel SIMD: avx2, avx512 [default: auto]

[server]
port = 5432
host = "0.0.0.0"
data_dir = "/var/lib/oxidedb"
max_connections = 100

[execution]
max_worker_threads = 8
max_memory_mb = 4096
simd_batch_size = 4096
enable_parallel_execution = true

[storage]
parquet_compression = "snappy"
column_chunk_size = 1048576
enable_mmap = true

[logging]
level = "info"
file = "/var/log/oxidedb/server.log"

# Iniciar con configuración optimizada
oxidedb-server --port 5433 \
  --data-dir /var/lib/oxidedb \
  --memory-limit 8589934592 \   # 8GB RAM
  --batch-size 16384 \          # Batch grande para SIMD
  --enable-s3                    # Habilitar S3

# Variables de entorno para S3
export AWS_ACCESS_KEY_ID=...
export AWS_SECRET_ACCESS_KEY=...
export AWS_REGION=us-east-2

# Dockerfile incluido
FROM ubuntu:22.04
COPY oxidedb-server /usr/local/bin/
COPY oxidedb-cli /usr/local/bin/
EXPOSE 5432
CMD ["oxidedb-server", "--port", "5432"]

# Ejecutar container
docker run -d \
  --name oxidedb \
  -p 5432:5432 \
  -v /data:/var/lib/oxidedb \
  oxidedb/server:1.6.0

apiVersion: apps/v1
kind: Deployment
metadata:
  name: oxidedb
spec:
  replicas: 3
  selector:
    matchLabels:
      app: oxidedb
  template:
    metadata:
      labels:
        app: oxidedb
    spec:
      containers:
      - name: oxidedb
        image: oxidedb/server:0.1.0
        ports:
        - containerPort: 5432
        env:
        - name: OXIDEDB_MAX_MEMORY
          value: "8192"