Deployment

​

Prerequisites

• GitHub repository with your PaparcApp code
• Render account (free tier available)
• Neon account for PostgreSQL (free tier available)
• n8n instance configured (see Notifications Guide)
• Firebase project set up (for social authentication)

​

Architecture Overview

​

Step 1: Database Setup (Neon)

​

Create Neon Project

1. Sign up at neon.tech
2. Click “New Project”
3. Configure your database:
   • Name: paparcapp-production
   • Region: Choose closest to your users (e.g., US East, EU West)
   • PostgreSQL Version: 15 or latest
4. Click “Create Project”

​

Get Connection String

postgresql://user:[email protected]/paparcapp_db?sslmode=require

​

Initialize Database Schema

1. Open the SQL Editor in Neon console
2. Run the SQL scripts in order:

-- 1. Create tables (from database/01_tables.sql)
CREATE TABLE customer (
    id_customer SERIAL PRIMARY KEY,
    full_name VARCHAR(100) NOT NULL,
    email VARCHAR(100) UNIQUE NOT NULL,
    password_hash VARCHAR(255) NOT NULL,
    phone VARCHAR(20),
    type VARCHAR(20) DEFAULT 'REGISTRADO',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- Continue with all tables from 01_tables.sql...

3. Run constraints (from database/02_constraints.sql)
4. Run indexes (from database/03_indexes.sql)
5. Run initial data (from database/04_initial_data.sql)

psql "postgresql://user:[email protected]/paparcapp_db?sslmode=require" -f database/01_tables.sql

​

Step 2: Render Web Service Setup

​

Create Web Service

1. Log in to Render Dashboard
2. Click “New +” → “Web Service”
3. Connect your GitHub repository
4. Configure the service:

​

Environment Variables

​

Required Variables

# Node Environment
NODE_ENV=production
PORT=3000

# Database (Neon Connection)
DATABASE_URL=postgresql://user:[email protected]/paparcapp_db?sslmode=require

# Session Secret (generate a strong random string)
SESSION_SECRET=your-super-secret-random-string-here-use-password-generator

# n8n Webhook
N8N_WEBHOOK_URL=https://your-n8n-instance.app/webhook/reserva-confirmada

​

Generating SESSION_SECRET

node -e "console.log(require('crypto').randomBytes(32).toString('hex'))"

​

Database Connection Configuration

const { Pool } = require('pg');
require('dotenv').config();

const pool = new Pool({
    connectionString: process.env.DATABASE_URL,
    ssl: {
        rejectUnauthorized: false  // Required for Neon
    }
});

module.exports = {
    query: (text, params) => pool.query(text, params),
    pool: pool,
    connect: () => pool.connect()
};

​

Step 3: Application Configuration

​

Trust Proxy for HTTPS

// Trust Render proxy for secure cookies
app.set('trust proxy', 1);

app.use(session({ 
    secret: process.env.SESSION_SECRET || 'clave_secreta',
    resave: false,
    saveUninitialized: false,
    cookie: {
        maxAge: 1000*60*60, // 1 hour
        secure: process.env.NODE_ENV === 'production' // Enables HTTPS-only cookies
    } 
}));

​

Static Files

app.use(express.static(path.join(__dirname, 'public')));

​

Step 4: Firebase Configuration

​

Update Firebase Config

1. Go to Firebase Console
2. Select your project: paparcapp-b0ac1
3. Navigate to Authentication → Settings → Authorized domains
4. Add your Render domain:
   • your-app.onrender.com
   • Your custom domain (if using one)

​

Environment-Specific Config

const firebaseConfig = {
  apiKey: "AIzaSyD61OFtuypBCC8OuFEHN54VtVprJA00zTI",
  authDomain: "paparcapp-b0ac1.firebaseapp.com",
  projectId: "paparcapp-b0ac1",
  storageBucket: "paparcapp-b0ac1.firebasestorage.app",
  messagingSenderId: "363572926161",
  appId: "1:363572926161:web:20bfb546fa6a1e38c797f0"
};

​

Step 5: Deploy

​

Initial Deployment

1. Push your code to GitHub
2. Render automatically detects the push and starts building
3. Monitor the deployment in Render dashboard:
   • Logs tab shows build progress
   • Look for “Build successful” and “Server started”

​

Deployment Process

# 1. Install dependencies
npm install

# 2. Start application
npm start  # Runs: node ./bin/www

​

Verify Deployment

1. Web Service: Visit https://your-app.onrender.com
2. Database: Check Neon dashboard for active connections
3. Logs: Review Render logs for errors:

# Expected successful startup logs:
Nueva conexión establecida con la base de datos
Cache de precios inicializada correctamente
Server listening on port 3000

​

Step 6: Post-Deployment

​

Create Admin User

-- Generate password hash for 'admin123' (change this!)
-- Use bcrypt with 10 rounds: $2b$10$...

INSERT INTO customer (full_name, email, password_hash, type) 
VALUES (
    'Admin User',
    '[email protected]',
    '$2b$10$YourBcryptHashHere',  -- Replace with actual hash
    'ADMIN'
);

​

Test Critical Features

• User registration and login
• Google/Facebook social login
• Create a reservation
• Email notification received
• Admin dashboard access
• Session persistence
• HTTPS redirects

​

Environment Variables Reference

# Server Configuration
PORT=3000
NODE_ENV=production

# Session Security
SESSION_SECRET=generate-strong-random-secret-minimum-32-characters

# Database Connection (Neon PostgreSQL)
DATABASE_URL=postgresql://user:[email protected]/paparcapp_db?sslmode=require

# Alternative individual DB variables (not used with DATABASE_URL)
# DB_USER=postgres
# DB_PASSWORD=your-password
# DB_HOST=localhost
# DB_PORT=5432
# DB_NAME=paparcapp_db

# Notifications
N8N_WEBHOOK_URL=https://your-n8n-instance.app/webhook/reserva-confirmada

​

Required vs Optional

​

Custom Domain (Optional)

​

Add Custom Domain to Render

1. In Render dashboard, go to Settings → Custom Domain
2. Add your domain: paparcapp.com
3. Configure DNS records at your domain registrar:

CNAME  www  your-app.onrender.com
A      @    <Render IP from dashboard>

4. Render automatically provisions SSL certificate

​

Update Firebase Authorized Domains

​

Monitoring and Logs

​

Render Logs

# View logs
Dashboard → Your Service → Logs

# Common log messages:
"Nueva conexión establecida con la base de datos"  # DB connected ✓
"Cache de precios inicializada correctamente"      # Pricing cache loaded ✓
"Error inesperado en el cliente de la base de datos" # DB error ✗

​

Database Monitoring

• Connections: Track active database connections
• Queries: Monitor slow queries
• Storage: Check database size and limits

​

Error Tracking

• Sentry: Application error monitoring
• LogDNA or Datadog: Log aggregation
• Uptime Robot: Availability monitoring

​

Troubleshooting

​

Common Issues

​

Database Connection Failed

1. Verify DATABASE_URL is correct in Render environment variables
2. Check Neon database is active (not suspended)
3. Ensure ssl: { rejectUnauthorized: false } is set in config/database.js
4. Test connection string locally:
   psql "$DATABASE_URL"
   

​

Session Not Persisting

1. Check SESSION_SECRET is set in environment variables
2. Verify trust proxy is set to 1 in app.js
3. Ensure NODE_ENV=production for secure cookies
4. Check browser isn’t blocking cookies

​

Firebase Auth Fails

1. Add Render domain to Firebase authorized domains
2. Clear browser cache and retry
3. Check Firebase console for service outages

​

Email Notifications Not Sending

1. Verify N8N_WEBHOOK_URL is correct
2. Check n8n workflow is active
3. Test webhook directly with curl:
   curl -X POST "$N8N_WEBHOOK_URL" \
     -H "Content-Type: application/json" \
     -d '{"test": true}'
   
4. Review n8n execution logs

​

Performance Optimization

​

Enable Connection Pooling

const pool = new Pool({
    connectionString: process.env.DATABASE_URL,
    max: 20,        // Maximum pool size
    idleTimeoutMillis: 30000,
    connectionTimeoutMillis: 2000,
});

​

Cache Pricing Data

PricingService.initCache()
  .then(() => {
    console.log("Cache de precios inicializada correctamente");
  })
  .catch((err) => {
    console.error("No se pudo cargar la cache de precio");
    process.exit(1);
  });

​

Scaling Considerations

​

Render Free Tier Limits

• Service spins down after 15 minutes of inactivity
• First request after spin-down takes 30-60 seconds
• 750 hours/month free (enough for 1 service)

​

Upgrading to Paid Plans

• Always-on service (no spin-down)
• Faster builds
• Custom domains with auto-SSL

• Increased storage (10GB)
• Longer data retention
• Branch management

​

Backup Strategy

​

Database Backups (Neon)

• Retention: 7 days (free tier) / 30 days (paid)
• Point-in-time recovery: Available on Pro plan

pg_dump "$DATABASE_URL" > paparcapp_backup_$(date +%Y%m%d).sql

​

Code Backups

• Push to GitHub regularly
• Tag production releases: git tag v1.0.0
• Consider GitHub automated backups or secondary remote

​

Security Checklist

• SESSION_SECRET is strong and unique
• Database credentials are not in code
• HTTPS is enforced (automatic on Render)
• Firebase authorized domains configured
• Admin default password changed
• SQL injection protection (parameterized queries used)
• CORS configured if using API
• Rate limiting considered for auth endpoints

​

Next Steps

​

Additional Resources

• Render Documentation
• Neon Documentation
• Express.js Production Best Practices
• PostgreSQL Performance Tuning