Zero-Maintenance Web Platforms with Astro and Edge D1 Ingestion

The standard restaurant website is often a sluggish WordPress template burdened by twenty outdated plugins, slow PDF menus, and recurring hosting invoices for servers that sit idle 90% of the day.

When building the digital flagship for our properties, we chose a fundamentally different architecture: 100% static output via Astro paired with centralized multi-tenant serverless ingestion on Cloudflare Workers and D1 SQLite.

The Zero-Maintenance Philosophy

Static web pages are unmatched in speed, reliability, and security:

• Instant Edge Delivery: Static HTML, CSS, and images are cached globally across CDN nodes, delivering sub-50ms Time to First Byte (TTFB) on mobile networks.
• Zero Server Upkeep: No Linux operating system patches, no SQL injection vulnerabilities against live databases, and zero vulnerability maintenance windows.
• Cost Efficiency: Static hosting on platforms like GitHub Pages is 100% free with unlimited scale.

Multi-Tenant Ingestion Architecture

While the frontend is static, restaurants still require interactive capabilities: contact inquiries, catering requests, and newsletter subscriptions.

Rather than running heavy backend servers for each restaurant domain, we centralize ingestion through a single lightweight Cloudflare Worker (newsletter.sobremesalabs.io / worker edge):

1. Lightweight Form Dispatch: Forms submit async POST requests with a declarative site_id payload (e.g. azul, haciendacampos, or sobremesalabs).
2. Bot Defense: Cloudflare Turnstile validates human interaction invisibly without frustrating CAPTCHA puzzles, supplemented by invisible honeypot decoy fields.
3. Structured Storage: Ingestion payloads are sanitized and stored in a shared Cloudflare D1 SQLite database with full tenant isolation and audit logs.

This architecture enables multiple venues to operate with zero server maintenance while preserving absolute speed and diner privacy.